Google sheets
Description
The Google Sheets activity allows you to retrieve structured data from a specific worksheet inside a selected Google Sheet file.
This activity is useful for reading tabular data, configurations, or external inputs from Google Sheets as part of a workflow. You can specify the file and sheet name to extract only the necessary content.
Use this activity to:
- Import tabular data from Google Sheets for processing
- Read dynamic configurations maintained by users
- Integrate sheet-based inputs into automated workflows
Use case:
A marketing team maintains campaign data in a Google Sheet. This activity reads the latest campaign metrics into the workflow and passes it toData Transforsfor analysis and reporting.
Input
Not Applicable
Output
| Output Type | Format | Description |
|---|---|---|
| Data | Table | Parsed data from the selected sheet |
Configuration Fields
| Field Name | Description |
|---|---|
| Connection | Select the Google Sheets connection to authenticate and access your files. |
| File Name | Choose the file from your connected account. (Single file selection only) |
| Sheet Name | (Optional) Specify the sheet to read from. Defaults to the first sheet. |
Sample Input
Not applicable
Sample Configuration
| Field | Value |
|---|---|
connection.id | google-sheets-connection |
fileName | Campaign_Metrics_Q2_2024 |
sheetName | April_Data |
Sample Output
| Campaign | Clicks | Impressions | Cost |
|---|---|---|---|
| A1 | 320 | 10,000 | $45.00 |
| B2 | 280 | 8,500 | $38.00 |
| C3 | 410 | 12,000 | $50.00 |