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
ベータ
権限
  • https://www.googleapis.com/auth/drive.file
オプション権限
  • https://www.googleapis.com/auth/drive
パラメータ
名前タイプ説明必須
spreadsheetIdfile Select the Google Sheets file to append rows into.はい
rangemustache Target sheet and starting cell in A1 notation (e.g. "Sheet1!A2"). This defines the append region; the CSV rows are appended after existing data in that region.はい
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.