---
schema_version: "1"
id: 360d872fd319173d59ab60dea5249bdc17873c70bdcd496fd36bab6e3fc4ed52
title: Prepare Your Google Sheets Connection (Beta)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-int/guides/googlesheet/c360-a-googlesheet-prerequisites.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-googlesheet-prerequisites.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c958df313b454026cd98da7a548ba7a7f4b0f0ed61069b703768a724c3da4190
products:
  - Data 360 Integration Guide
  - Data 360 Developer Documentation
---
# 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 360.

## Gather Info and Prep Data in Google Sheets

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.

## Authorize Access to Google Sheets

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.

## Next Step

- [Create External Credentials for Google Sheets (Beta)](https://developer.salesforce.com/docs/data/data-cloud-int/guide/c360-a-googlesheet-cred.md)