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