Voltar para Google Sheets

Conectar Knoon AI com Google Sheets (Google) para automatizar fluxos de trabalho de AI.

Append one or more rows from CSV text after existing data in a Google Sheet without overwriting rows.
googleSheetsAppendFromCSV-V2
Beta
Permissões
  • https://www.googleapis.com/auth/drive.file
Permissões opcionais
  • https://www.googleapis.com/auth/drive
Parâmetros
NomeTipoDescriçãoObrigatório
spreadsheetIdfile Select the Google Sheets file to append rows into.Sim
sheetNamefile Name of the target sheet tab (e.g. "Sheet1").Sim
rangemustache Starting cell in A1 notation that defines the append region (e.g. "A2"). Do not include the sheet name.Sim
valueInputOptionstring How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Sheets parse values and formulas.Sim
csvContentmustache CSV-formatted text for the rows to append. Each line is a row; values separated by commas.Sim
Devoluções
NomeTipoDescrição
statusstring INSERTED or ERROR.
sensitive.spreadsheetIdstring Spreadsheet ID.
sensitive.rangestring Requested append range.
sensitive.updatedRangestring Range actually updated.
sensitive.valueInputOptionstring Value input option used.