Back to Google Sheets
Connect Knoon AI with Google Sheets (Google) to automate AI workflows.
Insert a new sheet row at the requested row number in a Google Sheet and shift existing rows down.
googleSheetsInsertRow
BETA
Permissions
Optional permissions
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| spreadsheetId | file | Select the Google Sheets file to insert the row into. | Yes |
| range | mustache | Target sheet and starting cell in A1 notation (e.g. "Sheet1!A2"). The referenced row is used together with insertPosition to decide whether the new row is inserted before or after that row, and values are written starting from this column. | Yes |
| valueInputOption | string | How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Sheets parse values and formulas. | Yes |
| insertPosition | string | Whether to insert the new sheet row before or after the row referenced by the A1 cell. | Yes |
| values | array (mustache) | Row values to write into the newly inserted row. | Yes |
Returns
| Name | Type | Description |
|---|---|---|
| status | string | INSERTED or ERROR. |
| sensitive.spreadsheetId | string | Spreadsheet ID. |
| sensitive.updatedRange | string | Range where the inserted row values were written. |
Record Receipt to Google Sheets & Save to Google Drive
Logs receipts to Google Sheets, uploads attachments to Google Drive, and organizes files into unique DocNo folders.
5 min
Extract Bank Statement PDF to Google Sheets
Extract data from bank statement PDF and generate a spreadsheet in Google Sheets for review and analysis.
4 min