Indietro a Google Sheets

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

Append a new row after existing data in a Google Sheet without overwriting rows.
googleSheetsAppendRow-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 insert the row 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.
valuesarray (mustache)Row values to insert.
Resi
NomeTipoDescrizione
statusstring INSERTED or ERROR.
sensitive.spreadsheetIdstring Spreadsheet ID.
sensitive.updatedRangestring Range where the appended row was placed.