> 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 files from Google Drive into Mammoth

> Connect Mammoth to Google Drive with a Google sign-in, open a CSV, Excel, JSON or XML file, save it as a dataset, and collect new Drive files on a schedule.

The Google Drive connector opens a file from your Drive and saves it in Mammoth as a dataset. You sign in with your Google account, so there are no credentials to manage. Open it from **Data Library** > **New dataset** > **Connectors** and search for **Google Drive**. 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 Drive

Files of these types: `.txt`, `.csv`, `.tsv`, `.psv`, `.xls`, `.xlsx`, `.xlsm`, `.xml`, `.json`, `.jsonl`, `.ndjson`, `.zip`, `.bz2`, `.gz`, `.tar`, `.7z`.

A spreadsheet file opens to its tabs. For a Google Sheets spreadsheet, use the [Google Sheets connector](https://mammoth.io/docs/learn/get-data-in/connectors/google-sheets/), which can refresh daily.

## Before you connect Google Drive

You need a Google account with access to the Drive files you want to import.

Mammoth asks for read-only access: it can view and download your Google Drive files and see your email address. It can't change anything in your Drive.

## Connect Google Drive to Mammoth

1. Go to the **Data Library**, click **New dataset**, and choose **Connectors**.
2. Search for **Google Drive** and click its tile. The connector workspace opens with the **Chat** connecting Google Drive.
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. Pick your Google account, then click **Allow**. A connection made from the chat can read all of your Drive.

When you add Google Drive from **Data → Connections** instead, Mammoth asks you to pick files and folders (**Select Google Drive Files & Folders**). Choose them in Google's file picker, click **Select**, then click **Connect**. A folder includes all files and subfolders within it.

If the project already has a Google sign-in, clicking the **Google Drive** 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 authorization page asking to allow Mammoth Analytics to see and download Google Drive files, with Cancel and Allow](https://mammoth.io/docs/images/20260723_061415_auth_access_drive1.webp)

![Google Drive file picker titled Select files and folders to connect to Mammoth, with folders, files, and Select button](https://mammoth.io/docs/images/20260723_061504_select_folder_file_ui_drive1.webp)

![Connect Google Drive dialog listing a selected CSV file and a folder, with Add more and Connect buttons](https://mammoth.io/docs/images/20260723_061547_file_selected_ui_drive1.webp)

## Open a Google Drive file and pick columns

1. In the left panel, browse your Drive folders and click a file to open it. A spreadsheet opens to its tabs.
2. Tick the columns you want. They gather in **Your table**.
3. If a file can't open in the panel yet, ask the agent in the **Chat** to import it.

![Google Drive New Dataset dialog with a file checklist, supported file types, Exact Sheet name, and Create new dataset](https://mammoth.io/docs/images/20260723_061603_extract_file_folder_ui_drive1.webp)


## Save a Google Drive file as a dataset

1. Click **Save as dataset**.
2. Enter a **Dataset name** and pick the folder under **Save in**.
3. Click **Save**.

A dataset from a Drive file is saved once. Mammoth shows **Saved once. Scheduled refresh for files is coming.** A [Dataset Refresh](https://mammoth.io/docs/learn/automate/refresh-a-dataset/) automation can't re-read Google Drive files.

## Bring in new Google Drive files on a schedule

To keep adding files as they land in a Drive folder, use two automations:

1. A **File Collection** automation collects new files from the Drive folder into Mammoth on a schedule. See [What you can automate](https://mammoth.io/docs/learn/automate/).
2. A [Data Consolidation](https://mammoth.io/docs/learn/automate/consolidate/) automation adds the collected files to your dataset.

## Troubleshoot Google Drive connections

| Symptom | Likely cause | Fix |
| --- | --- | --- |
| You aren't returned to Mammoth | You denied access or closed the tab during sign-in | Start the connection again; Mammoth returns you after you click **Allow** |
| A message says the Google Drive picker failed to load | The picker didn't load in the page | Refresh the page and try again |
| "Session expired. Please reconnect Google Drive." | The Google sign-in expired | Sign in with Google again |
| "No files found." | The selected items contain no supported file types | Select a different file or folder, and check the file types listed above |

## Related

- [Google Sheets](https://mammoth.io/docs/learn/get-data-in/connectors/google-sheets/): import a spreadsheet tab that refreshes daily.
- [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/): the shared connector workspace steps.
- [Combine incoming data](https://mammoth.io/docs/learn/automate/consolidate/): add collected files to one dataset.
- [Upload files](https://mammoth.io/docs/learn/get-data-in/upload-files/): bring in a file from your computer instead.
- [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/): reuse or remove this connection.

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