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. Here, we recommend using service account credentials.
To get API credentials using a GCP service account, follow these steps:
In a YAML file, the config
section contains 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: