Google Sheets

Renta allows you to sync data from your Google Sheets directly to your data warehouse, automating the process of moving data from spreadsheets to your analytics stack.

Authentication

Renta supports two methods for authenticating with Google Sheets:

1. OAuth (Google Account).
   Best for individuals and small teams.
2. Service Account.
   Best for enterprise security and centralized access control.

Connect Google Sheets source

Follow these steps to add Google Sheets as a source in Renta. You can use either OAuth or Service Account authentication.

Go to the CatalogStep 1

Navigate to the Connections > Catalog section in the left sidebar.

Select Google SheetsStep 2

Find and select Google Sheets in the Sources list.

Choose Authorization MethodStep 3

Select your preferred authorization method:

1. Authenticate with Google Account.
   Redirects to Google for OAuth login.
2. GCP Service Account.
   Requires uploading a JSON key file (see steps below).

Service Account: Create KeyStep 4

If using a Service Account:

For a detailed step-by-step guide on creating a GCP Service Account, see our Google Sheets to Snowflake integration guide.

1. Ensure the Google Sheets API is enabled in your GCP project.
2. In Google Cloud Console, go to IAM & Admin > Service Accounts.
3. Create a new service account or select an existing one.
4. Go to the Keys tab, click Add Key > Create new key.
5. Select JSON and download the file.

Service Account: Share SheetStep 5

1. Open your Google Sheet.
2. Click Share.
3. Add the Service Account email as a Viewer.

Configure ConnectionStep 6

Fill in the connection details:

1. Source name.
   A display name for this connection in Renta.
2. Google Spreadsheet ID.
   Paste the full URL of your Google Sheet. Renta will extract the ID automatically.

Click Save to finish.

Pipeline configuration

When creating a pipeline with Google Sheets source, you will need to configure the following settings:

1. Select Worksheet.
   Choose the specific sheet (tab) to sync.
2. Header row number.
   Specify the row number containing column headers (default: 1). Only English text is supported for column names. Renta automatically normalizes headers by removing spaces, special characters, and converting to lowercase to meet destination table requirements.
3. Worksheet columns.
   Select which columns to sync from your sheet. This is a required field. To add new columns after pipeline creation, update this setting and select the new columns explicitly.

Sync scheduling

Sync strategy

The following table describes the synchronization strategies used by Renta for Google Sheets:

Data types and limitations

1. Data Types.
   All data is loaded as text (string type). Renta does not enforce type validation, so columns can contain mixed data types (text, numbers, dates).
2. Empty Rows.
   Empty rows are automatically skipped.
3. Schema Changes: Adding Columns.
   If you add new columns to your Google Sheet, they will not appear in the destination table unless you manually update the pipeline settings and select them in the Worksheet columns field.
4. Schema Changes: Removing Columns.
   If you remove a column from the Google Sheet, the corresponding column in the destination table will continue to exist but will receive empty values for all new syncs.