Voltar para Google Sheets

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

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