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-V2
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.
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.
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.