Google Sheets - Mage AI

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.