Google Sheets is a cloud-based spreadsheet application offered by Google as part of its Google Workspace suite.
Service account credentials are better suited for server-to-server interactions. Therefore, we recommend using service account credentials.
To get API credentials using a GCP service account, follow these steps:
The config
section in a YAML file includes the following properties:
Connectorname: GoogleSheets
project_id: Project ID
client_email: Client Email
private_key: Private Key
spreadsheet_url_or_id: Spreadsheet URL or ID
Range_names: Ranges of the names
spreadsheet_identifier: `spreadsheet_identifier = "https://docs.google.com/spreadsheets/d/1VTtCiYgxjAwcIw7UM1_BSaxC3rzIpr0HwXZwd2OlPD4/edit?usp=sharing"`
version: 1
encrypt_credentials: false
plugins:
extractors:
- name: Google Sheets
connectorname: Google Sheets
config:
project_id:
client_email:
private_key:
properties:
spreadsheet_url_or_id:
# range_names value should be range_names: "range_name1", "range_name2"
range_names: