العودة إلى Google Sheets
اتصل بـ Knoon AI مع Google Sheets (Google) لأتمتة تدفقات عمل الذكاء الاصطناعي.
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