Prepare Your Google Sheets Connection (Beta)

To connect Google Sheets as a data source, gather the required information and perform these actions in the Google Sheets source system. Complete these steps before configuring the connection in Data Cloud.

1. Make sure you’re using a Google account that has access to the Google Sheet you want to connect to Data Cloud.
2. Copy the full URL of the Google Sheet you want to connect to Data Cloud.
3. Make sure that the Google account used for authentication has at least Viewer access to the spreadsheet.
4. To make sure your Google Sheet is ingested correctly, format the spreadsheet using these guidelines:
   • Organize your data in a single worksheet with a single header row.
   • Ensure each column has a unique, descriptive name.
   • Remove empty rows and columns.
   • Confirm that the data doesn't contain merged cells or unsupported formulas.

1. If your organization restricts API access, ask your Google Workspace admin to turn on the Google Sheets API for your account. For most users, API access is enabled by default.