Google Sheets as a source

You can create a data pipeline that loads data from Google Sheets to a target.

Supported Account types

To provide connection information, you can enter credentials in AutoSync, Designer, or Classic Manager. Designer and Classic Manager offer multiple account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list includes only compatible account assets. AutoSync supports the following Designer and Classic Manager account types:

The Account type supported for Google Sheets is:

  • Spreadsheet OAuth2 Account

Known limitations

  • If Preserve datatypes is unchecked, all data from Google Sheets are extracted as strings.
  • When using Preserve datatypes, the values under each column must have the same datatype.
  • Selecting the Preserve datatypes checkbox may impact performance. The time data type cannot be preserved and will be converted to a fragment of the day. For example, 12 PM will be converted into 0.5.

Connection configuration

Google Sheet properties include the following:

  • Credential label: A unique, meaningful name such as Accounting-Google-Spreadsheet. If a configuration with the same name exists, AutoSync displays an Asset conflict error message.
  • Authorize: Authorizes Autosync with your Google Account. After you log in to your Google account, you will be asked to provide access permission. Access is required to make a connection.
  • Share: (Optional) Select a user group to share this configuration with. Environment admins (formerly Org admins) create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
  • Validate and Save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
  • Select spreadsheet: After configuring a destination, choose the spreadsheet to load.
  • Select tables to synchronize: Choose tables to synchronize. AutoSync populates the list from your Google Sheets account.
  • Select the checkbox to preserve the data types of your tables.