Configuration

To set up the Google Sheets source, provide the following configuration parameters:

KeyDescriptionSample Value
path_to_credentials_json_filePath to your Google service account credentials JSON file./path/to/service_account_credentials.json
spreadsheet_idThe unique identifier of a spreadsheet (found in the spreadsheet URL after /spreadsheets/d/).abcdefg123456
selected_sheet_namesA 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: