Skip to content
Docs
Open Mammoth
Learn › Get data in › Connectors: open the docs menu

Import a Google Sheet into Mammoth and refresh it daily

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 for the shared steps.

Google Sheets Existing Connections list showing one Google account and the Sign in with Google button Google authorization page asking to allow Mammoth Analytics to see and download Google Drive files, with Cancel and Allow

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

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 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

SymptomLikely causeFix
Columns aren't what you expectedExtra or badly named columnsUntick 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 tabsCheck the spreadsheet in Google Sheets
Access deniedThe authorized Google account can't see the sheetGive 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 accessCheck the link and the account's access
Was this page helpful?

Something wrong? support@mammoth.io