Skip to main content

Google Sheets

info

Import your data from any source directly into your Google Sheets file.

Source Setup Guide​

Step 1​

Click banner in the Edit Destination form to the left.

Step 2​

Follow the authentication flow (OAuth) on Google’s website to grant Extract the required permissions.

Step 3​

Confirm you can see your email and profile picture, and that the destination is Connected.

Connection Setup Guide​

Once you connected Google Sheets to a source, you will also need to configure:

  • Spreadsheet Link - Create a new spreadsheet and paste its URL.
  • Connection Pull Schedule - Determines how frequently data is extracted from the source.
  • Schema Migration Policy - Controls how Extract will handle schema changes from the source.

Additional Information​

info

  • Handling Multiple Streams

    • Multiple streams are written to separate tabs within the same spreadsheet.

  • Row Limit Handling

    • When the row limit is reached (or any other cell limitation), the connection will fail. Best practice is to create a new connection (for example, pointing to a new spreadsheet).

  • Field Type Support

    • Column names are inferred from the first row (headers).
    • Types are inferred from the sheet’s formatting and sample values:
      • DATE and DATE_TIME formatted columns are represented as strings with a date/date-time format when the format can be parsed.
      • If a date/date-time format cannot be parsed, the column will be treated as a plain string.
      • NUMBER formatted columns are represented as numbers.
      • All other columns default to string.
    • Manual modifications to values or formatting may lead to inconsistencies.

  • Impact of Spreadsheet Modifications

    • If you delete a column, alter the spreadsheet structure, or remove primary keys, the connection may fail.

  • Supported Load Modes

    • Full Refresh: Append/Replace
    • Incremental Load: Append