Atrás a Google Sheets

Conectar Knoon AI con Google Sheets (Google) para automatizar flujos de trabajo de AI.

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