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

# Import a Google Sheet into Mammoth and refresh it daily

> Connect Mammoth to Google Sheets with a Google sign-in, open a spreadsheet tab by list or link, and save it as a dataset that refreshes from the sheet.

The Google Sheets connector imports one spreadsheet tab into Mammoth as a dataset that can refresh from the sheet. You sign in with your Google account, then choose the spreadsheet and the tab. Open it from **Data Library** > **New dataset** > **Connectors** and search for **Google Sheets**. Project Admins create the connection; Project Editors can start datasets from a connection the project already has. Which connectors you can add depends on your plan.

## What you can bring in from Google Sheets

- One tab of a spreadsheet per dataset. Pick the spreadsheet from a list or paste its link.
- Only the columns you tick.

Unlike most file sources, a Google Sheets dataset can refresh. Each refresh reads the sheet's current content.

## Before you connect Google Sheets

You need a Google account with at least **Viewer** access on the spreadsheet.

Mammoth asks for read-only access to view and download your Google Drive files and see your email address.

## Connect a Google account to Mammoth

1. Go to the **Data Library**, click **New dataset**, and choose **Connectors**.
2. Search for **Google Sheets** and click its tile. The connector workspace opens with the **Chat** connecting Google Sheets.
3. In the chat's card, click **Sign in with Google**. Google's authorization page opens in a pop-up window, or in the same tab if your browser blocks pop-ups.
4. Sign in with the Google account that has access to the spreadsheet, then click **Allow**. You're returned to Mammoth.

If the project already has a Google sign-in, clicking the **Google Sheets** tile opens that sign-in's files instead of a new chat. You can also pick a saved connection under **Your connections** in the launcher. See [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/) for the shared steps.

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


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

## Open a spreadsheet and tab

1. In the left panel, find the spreadsheet under **Your spreadsheets**, or use **Filter, or paste a spreadsheet link**. To open a pasted link, click **Open this spreadsheet**.
2. The spreadsheet opens to its tabs. Click the tab you want to see its rows.
3. Tick the columns you want. They gather in **Your table**. To rename a column, click its name in **Your table**.
4. Click **Preview 100 rows** to check the result.

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


### Import several tabs from one spreadsheet

Create a separate dataset for each tab. Use the same connection and open a different tab each time.

## Save a Google Sheets tab as a dataset

1. Click **Save as dataset**.
2. Enter a **Dataset name** and pick the folder under **Save in**.
3. Under **Keep it up to date**, choose **Daily** or **Manual**.
4. Click **Save**.

### If Mammoth opens the Connect a Google Sheet screen

Mammoth still opens the older **Connect a Google Sheet** screen in some cases. There:

1. In **Spreadsheet**, open **Select a spreadsheet…** and pick your spreadsheet, or click **Paste a link instead**.
2. In **Tab**, choose the tab, then click **Continue**.
3. On the **Mammoth interpretation** step, click **Looks right** if the header and columns are correct. If the tab needs reshaping, describe how to read the header and check the **Result**, or click **Import as is**.
4. Enter a **Dataset name**, choose **Manual** or **On a schedule**, and click **Create Dataset**.

## Refresh a Google Sheets dataset

Choosing **Daily** creates a [Dataset Refresh](https://mammoth.io/docs/learn/automate/refresh-a-dataset/) automation that you can reschedule later. When a refresh runs, Mammoth reads the sheet's current content, so changes made in Google Sheets since the last refresh appear in your dataset.

After the dataset is saved, its **Update method** offers **Replace all data** or **Add to existing data**. Google Sheets refreshes don't use a key column.

## Troubleshoot Google Sheets imports

| Symptom | Likely cause | Fix |
| --- | --- | --- |
| Columns aren't what you expected | Extra or badly named columns | Untick the columns you don't need, or rename a column in **Your table** by clicking its name |
| "No tabs found in this spreadsheet" | The spreadsheet has no readable tabs | Check the spreadsheet in Google Sheets |
| Access denied | The authorized Google account can't see the sheet | Give that account at least **Viewer** access on the spreadsheet |
| "Couldn't open that spreadsheet. Check the link, and that this Google account can see it." | Wrong link, or no access | Check the link and the account's access |

## Related

- [Google Drive](https://mammoth.io/docs/learn/get-data-in/connectors/google-drive/): import CSV, Excel and other files from Drive.
- [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/): the shared connector workspace steps.
- [Refresh a dataset](https://mammoth.io/docs/learn/automate/refresh-a-dataset/): change when the dataset refreshes.
- [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/): reuse or remove this connection.
- [Import from a URL](https://mammoth.io/docs/learn/get-data-in/import-from-a-url/): bring in a file from a web link instead.

---
Source: https://mammoth.io/docs/learn/get-data-in/connectors/google-sheets.md · Updated: 2026-11-08