Google Sheets に戻る

Google Sheets (Google) と Knoon AI を接続して AI ワークフローを自動化します。

Append one or more rows from CSV text after existing data in a Google Sheet without overwriting rows.
googleSheetsAppendFromCSV-V2
ベータ
権限
  • https://www.googleapis.com/auth/drive.file
オプション権限
  • https://www.googleapis.com/auth/drive
パラメータ
名前タイプ説明必須
spreadsheetIdfile Select the Google Sheets file to append rows into.はい
sheetNamefile Name of the target sheet tab (e.g. "Sheet1").はい
rangemustache Starting cell in A1 notation that defines the append region (e.g. "A2"). Do not include the sheet name.はい
valueInputOptionstring How to treat the cell values: RAW = store exactly as given, USER_ENTERED = let Sheets parse values and formulas.はい
csvContentmustache CSV-formatted text for the rows to append. Each line is a row; values separated by commas.はい
返品
名前タイプ説明
statusstring INSERTED or ERROR.
sensitive.spreadsheetIdstring Spreadsheet ID.
sensitive.rangestring Requested append range.
sensitive.updatedRangestring Range actually updated.
sensitive.valueInputOptionstring Value input option used.