Indietro a Google Sheets

Connetti Knoon AI con Google Sheets (Google) per automatizzare i flussi di lavoro AI.

Append one or more rows from CSV text after existing data in a Google Sheet without overwriting rows.
googleSheetsAppendFromCSV
Beta
Autorizzazioni
  • https://www.googleapis.com/auth/drive.file
Autorizzazioni facoltative
  • https://www.googleapis.com/auth/drive
Parametri
NomeTipoDescrizioneObbligatorio
spreadsheetIdfile Select the Google Sheets file to append rows into.
rangemustache Target sheet and starting cell in A1 notation (e.g. "Sheet1!A2"). This defines the append region; the CSV rows are appended after existing data in that region.
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.
Resi
NomeTipoDescrizione
statusstring INSERTED or ERROR.
sensitive.spreadsheetIdstring Spreadsheet ID.
sensitive.rangestring Requested append range.
sensitive.updatedRangestring Range actually updated.
sensitive.valueInputOptionstring Value input option used.