Πίσω στο Google Sheets
Σύνδεση Knoon AI με Google Sheets (Google) για αυτοματοποίηση ροών εργασίας AI.
Insert a new sheet row at the requested row number in a Google Sheet and shift existing rows down.
googleSheetsInsertRow
ΒΕΤΑ
Άδειες
Προαιρετικές άδειες
Παράμετροι
| Όνομα | Τύπος | Περιγραφή | Απαραίτητο |
|---|---|---|---|
| spreadsheetId | file | Select the Google Sheets file to insert the row into. | Ναι |
| 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. | Ναι |
| valueInputOption | string | How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Sheets parse values and formulas. | Ναι |
| insertPosition | string | Whether to insert the new sheet row before or after the row referenced by the A1 cell. | Ναι |
| values | array (mustache) | Row values to write into the newly inserted row. | Ναι |
Επιστροφές
| Όνομα | Τύπος | Περιγραφή |
|---|---|---|
| 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