> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://docs.mammoth.io/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# Google Sheets connector

> Connect Mammoth to Google Sheets with a Google sign-in, choose a spreadsheet and tab, and import it as a dataset that refreshes manually or on a schedule.

The Google Sheets connector imports data from a Google Sheets spreadsheet into Mammoth as a dataset. Authenticate with your Google account using OAuth, then choose the spreadsheet and the tab to import.

## Before you start

You need:

- A Google account with access to the spreadsheet
- The spreadsheet you want to import (you can pick it from a list or paste its link)

## Step 1: Select the Google Sheets connector

1. In Mammoth, go to **Data Library** and click **+ New Dataset**
2. Select **Connectors**
3. Search for **Google Sheets**
4. Click the **Google Sheets** tile

## Step 2: Connect a Google account

Mammoth shows an **Existing Connections** screen listing any Google accounts you've already authenticated.

![Google Sheets Existing Connections list showing one Google account and the Sign in with Google button](https://docs.mammoth.io/api/v1/images/20260723_061811_Screenshot2026-05-211436201-1.jpg)

- To reuse a previously connected account, select it from the list.
- To connect a new account, click **Sign in with Google**.

Clicking **Sign in with Google** starts the OAuth flow:

![Google authorization page asking to allow Mammoth Analytics to see and download Google Drive files, with Cancel and Allow](https://docs.mammoth.io/api/v1/images/20260723_061841_Screenshot2026-05-211433061.jpg)

Mammoth sends you to Google's authorization page in the same browser tab. Sign in with the Google account that has access to the spreadsheet, then click **Allow**. Mammoth asks for read-only access to view and download your Google Drive files and see your email address. You're redirected back to Mammoth automatically. Click **Back** to return to the connector selection screen at any point.

## Step 3: Select your spreadsheet and tab

Mammoth shows **Connect a Google Sheet** with your Google account and a **Connected** badge.

![Older Google Sheets New Dataset form with Google Sheets URL, Exact Sheet name, text-type checkbox, and Submit button](https://docs.mammoth.io/api/v1/images/20260723_061855_Screenshot2026-05-211436201.jpg)

1. In **Spreadsheet**, open **Select a spreadsheet…**, search with **Search spreadsheets**, and pick your spreadsheet. To use a link instead, click **Paste a link instead** and paste a Google Sheets link. Click **Use picker instead** to go back to the list.
2. In **Tab**, choose the tab to import. Mammoth selects the first tab by default.
3. Click **Continue**.

## Step 4: Review how Mammoth reads the tab

Mammoth checks the structure of the tab and shows a **Mammoth interpretation** step.

- **Tab is a clean table:** Mammoth reports that the first row is the header and how many columns and rows it detected. Click **Looks right**.
- **Tab needs reshaping:** Mammoth shows **Source Data** and **Result**. Describe how the header should be read in the box (for example, name the columns, or use a row as the header), run it, and check the result. Click **Looks right** when it is correct, or click **Import as is** to import the tab exactly as it is, without reshaping.

If Mammoth can't read the structure of a tab, it shows "Could not read the structure of this tab. Please try again."

## Step 5: Save the Google Sheets dataset

1. Enter a **Dataset name** (the tab name is filled in for you).
2. Choose how the dataset refreshes: **Manual** (refresh from the sheet whenever you choose) or **On a schedule**. Scheduled refresh depends on your plan; if it isn't available, Mammoth shows "Upgrade your plan to set up automatic dataset refresh."
3. Choose an **Update method**: **Replace** swaps in the latest data each refresh, and **Combine** adds new data alongside what's already there.
4. Click **Create Dataset**.

If a later refresh brings back something different from what you saved, Mammoth pauses the update and asks you; your data is never changed silently.

## Import multiple Google Sheets tabs

To import multiple tabs from the same spreadsheet, create a separate dataset for each tab. Use the same connection and choose a different **Tab** each time.

## Keep Google Sheets data up to date

Choose **On a schedule** when you save the dataset, or set up a **Dataset Refresh** automation later. When a refresh runs, Mammoth reads the current content of the sheet—any changes made in Google Sheets since the last refresh will appear in your Mammoth dataset.

## Troubleshoot Google Sheets imports

### Columns are not what you expected

- Check the header on the **Mammoth interpretation** step. Describe how the header should be read, or use **Import as is**
- If Mammoth shows "No tabs found in this spreadsheet", the spreadsheet has no readable tabs; check the spreadsheet in Google Sheets

### Access denied

- The Google account you authorized must have at least **Viewer** access on the spreadsheet
- If Mammoth shows "That doesn't look like a valid Google Sheets link", check the link you pasted

---
Source: https://docs.mammoth.io/learn/connectors/google-sheets-connector.md · Updated: 2026-10-13