Read Google Sheet to Dataset Activity
The Read Google Sheet to Dataset activity imports data from a specified Google Sheet file into a new dataset. This activity streamlines the process of integrating external spreadsheet data directly into your automation workflows for further processing.
| Field | Description | Requirement |
|---|---|---|
| Google Sheet Name | The reference name of the Google Sheet that has already been opened or created. This is selected from a dropdown list. | Required |
| New Dataset Name | The reference name for the dataset that will be created by this activity. | Required |
| Sheet Name | A specific page or tab name within the spreadsheet. If left blank, the activity defaults to the first sheet. | Optional |
| Range | The cell range to read, for example: A1:C2. | Optional |
| Has Header | Indicates whether the first row of the specified range contains column headings. | Optional |
| Include Formatted Text | If selected, values are calculated and formatted in the response according to the cell's format. | Optional |
Action Types & Examples
Dataset Creation
- Format:
string - Example Result:
newDS
Implementation Examples
Field Setup - Google Sheet Name: ${newGoogleSheet} - New Dataset Name: newDS - Sheet Name: Sheet1 - Range: A1:D100 - Has Header: true - Include Formatted Text: false
Execution Parameters - googleSheetName: "${newGoogleSheet}" - newDatasetName: "newDS" - sheetName: "Sheet1" - range: "A1:D100" - hasHeader: true - includeFormattedText: false
Technical Notes
This activity requires a previously established connection to a Google Sheet. The output is a new dataset named as specified, containing the imported data. If 'Sheet Name' is not provided, the activity processes the first sheet by default. The 'Has Header' and 'Include Formatted Text' options influence how data is parsed and presented within the resulting dataset.