Sources
Google Sheets
Configuration
To set up the Google Sheets source, provide the following configuration parameters:
| Key | Description | Sample Value |
|---|---|---|
path_to_credentials_json_file | Path to your Google service account credentials JSON file. | /path/to/service_account_credentials.json |
spreadsheet_id | The unique identifier of a spreadsheet (found in the spreadsheet URL after /spreadsheets/d/). | abcdefg123456 |
selected_sheet_names | A list of sheet names to filter and extract. | ["sheet1", "sheet2"] |
Prerequisites
- Enable the Google Sheets API.
- Share your spreadsheet with the service account:
- Open the spreadsheet.
- Click Share.
- Add the service account’s email with Editor or Viewer permission.
Sheet Requirements
Each sheet must meet the following requirements:
- Sheet is not empty.
- The first row must contain column names (no duplicate column names).
- The following rows must contain only valid cell values:
- No errorType or formulaType cells.