Skip to main content

Google Sheet Data Source

Source Setup Guide​

  1. Log in to your Google account to connect a Google Sheet to Extract.
  2. Paste your Google Sheet URL into the designated input field.
  3. Click "Save."

Connection Setup Guide​

Once you conneted Google Sheet to a destination, you will also need to configure:

  • Connection Pull Schedule: Determines how frequently data is extracted from the source.
  • Backfill (Days): Specifies the duration for which historical data will be retrieved during each connection run.
  • Destination specific settings: different settings such as "Dataset Name" or "Target Schema" (depanding on your destination)
  • Schema Migration Policy: Controls how Extract will handle schema changes from the sourcee source.

Google Sheet Data Source FAQ​

Q: How is the data in the sheets converted into data streams?

A: Extract will treat each sheet as an individual data stream and populate each column as a field. For example, if the Google Sheet contains two sheets named "stats" and "metadata," Extract will automatically create two streams based on the columns present in each sheet.

Q: What are the supported data types?

A: all data types will be treated as "string" in the destination schema.

Q: What happens if I edit a sheet / add a new sheet?

A: Once the Google Sheet has been shared and saved as the source, Extract will expect the schema to remain unchanged. Modifying the schema (such as adding or deleting sheets or columns) will cause the connection to fail. If you need to change the schema, we recommend re-creating the source with the updated Google Sheet.