Quay lại Google Sheets
Kết nối Knoon AI với Google Sheets (Google) để tự động hóa các quy trình làm việc AI.
Insert a new sheet row at the requested row number in a Google Sheet and shift existing rows down.
googleSheetsInsertRow
BẢN THỬ NGHIỆM
Quyền hạn
Quyền hạn tùy chọn
Tham số
| Tên | Loại | Mô tả | Bắt buộc |
|---|---|---|---|
| spreadsheetId | file | Select the Google Sheets file to insert the row into. | Có |
| 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. | Có |
| valueInputOption | string | How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Sheets parse values and formulas. | Có |
| insertPosition | string | Whether to insert the new sheet row before or after the row referenced by the A1 cell. | Có |
| values | array (mustache) | Row values to write into the newly inserted row. | Có |
Trả về
| Tên | Loại | Mô tả |
|---|---|---|
| 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