Description
The Write To GoogleSheets component allows you to output data to Google Spreadsheets. To use this component, you need to obtain a Google account and perform preliminary setu
Input payload (cv.Payload) accepts input as an array of JSON arrays or an array of JSON Objects. Otherwise, it converts to string and outputs as a 1-row, 1-column spreadsheet.
| Input Payload | Example |
|---|---|
| JSON Array Payload Example | [[123, "abc", "xxx"], [456, "def", "yyy"], [789, "hij", "zzz"]] |
| JSON Object Payload Example | [{"field1": 123, "field2":"abc", "field3":"xxx"}, {"field1": 456, "field2":"def", "field3":"yyy"}, {"field1": 789, "field2":"hij", "field3":"zzz"}] |
Component Properties
| Property Name | Description |
|---|---|
| Specification Method | Specify how to output data to spreadsheet. Choose "Folder Path", "Folder ID", or "File ID" |
| Folder Path | Specify folder path in Google Drive. If not specified, My Drive (root) is targeted |
| Folder ID | Specify folder ID in Google Drive. If not specified, My Drive (root) is targeted |
| Drive File Name | Specify the file name of Google Spreadsheet on Google Drive. Creates new if existing file doesn't exist |
| File ID | Specify specific file ID on Google Drive |
| Sheet Name | Specify sheet name to output data. If not specified, first sheet is targeted |
| Data Insert Mode | Specify how to insert data from "RAW Data" or "User Input (Formulas & Formatting)" |
| Write Mode | Specify whether to create New File, Overwrite cells, or Append rows |
| Output Header | Select whether to output header when outputting data |
| Output Field Order | When input payload is JSON Object, list field names to output in desired order, separated by commas |
| Start Column | Specify the first column to output |
| Start Row | Specify the first row to output |
| OAuth2 Client ID | Specify OAuth 2.0 Client ID from GCP |
| OAuth2 Client Secret | Specify Client Secret from GCP |
| OAuth2 Redirect URL | Specify Redirect URL from GCP |
| OAuth2 Access Token | Obtain by pressing the Get Token button. Can also update by pressing the Update Token button |
Component Variables
| Component Variable | Description |
|---|---|
| cv.FileID | File ID |
| cv.FolderID | Parent folder ID of file saved to Google Drive |
| cv.DriveFilename | Destination file name in Google Drive |