> ## Documentation Index
> Fetch the complete documentation index at: https://basedash.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Drive

> Connect Google Drive to Basedash Warehouse, sync data automatically, and explore it with AI dashboards, chat, and scheduled insights.

The Google Drive connector syncs your Google Drive data into [Basedash Warehouse](https://basedash.com/docs/data-sources/warehouses/basedash-warehouse.md), where you can chart it, chat with it, and add it to dashboards like any other data source.

> [!NOTE]
>
> Only admins can add data sources. SaaS connectors run on Fivetran and are available on Basedash Cloud only, not on self-hosted deployments.

## Why use Google Drive for sheets

The Google Drive connector is the best way to work with several Google Sheets:

* Connects a whole folder of sheets at once.
* Syncs each file in the folder as its own table, so the folder becomes one schema.
* Doesn't need named ranges or reformatted tables.
* Suits datasets spread across several sheets, like survey waves or multi-sheet reports.

> [!NOTE]
>
> To connect a single sheet, you can use the [Google Sheets
> connector](https://basedash.com/docs/data-sources/connectors/google_sheets.md) instead.

## Common uses

* **Survey and research data:** separate sheets for each survey wave or demographic, with raw data and processed results in the same schema.
* **Financial and business reporting:** budget sheets for each department or time period, such as an annual budget with separate revenue, expense, and forecast sheets.
* **Project management:** tracking sheets for each team or project phase, such as separate sheets for tasks, resources, and milestones.
* **Data analysis:** a sheet for each experiment or data source, kept alongside the analysis results.

## Best practices

* Keep related sheets in a dedicated folder.
* Use consistent column names across sheets.
* Use folders to group related data.
* Only put sheets that belong to the same schema in the folder. Keep other files in separate folders to avoid syncing unneeded data and causing schema conflicts.

## Connect Google Drive

1. Go to the **Data** page and select **Add data source**.
2. Search for **Google Drive** and open it.
3. Select **Connect**.
4. In the Fivetran setup form that opens, sign in to Google Drive or enter the credentials it asks for, then finish the form. Choose the folder that contains your sheets to connect them all at once.
5. Basedash starts the first sync. When it finishes, the Google Drive tables appear on the **Data** page.

The first sync backfills historical data, so it can take longer than later syncs. If you close the setup form before finishing, the connector shows **Setup incomplete**. Open it from the **Data** page and select **Connect** to finish.

## Manage the sync

Open the connector from the **Data** page to see its status and synced tables. Admins can change these settings:

* **Enabled:** turn off to pause all syncs, and turn back on to resume.
* **Sync frequency:** how often Basedash checks Google Drive for new data, from every 15 minutes to every 24 hours. New connectors sync every hour.
* **Sync now:** starts a sync right away.
* **Synced tables:** choose which schemas, tables, and columns sync, and use **New data** to decide what happens when Google Drive adds new ones. Save your changes to apply them.
* **Access:** choose who can see this connector's tables. See [data source access control](https://basedash.com/docs/administration/data-source-access-control.md#connectors-in-basedash-warehouse).
* **Connection details:** select **Edit** to reopen the Fivetran setup form and update credentials or configuration.

To stop syncing and remove the connector, select **Delete connector**.

## Connector details

* **Fivetran status:** Generally available
* **Tables and sync behavior:** the [Fivetran Google Drive documentation](https://fivetran.com/docs/connectors/files/google-drive) lists the tables this connector syncs, any setup needed on the Google Drive side, and how it handles deleted records.

## FAQ

> [accordion] How often does Google Drive data sync?
>
> Every hour by default. Admins can change **Sync frequency** to anything from
> every 15 minutes to every 24 hours, or select **Sync now** to sync right
> away.

> [accordion] Can I pause syncing?
>
> Yes. Turn off **Enabled** in the connector's settings, and turn it back on
> to resume. Syncing also pauses if your organization's trial ends without a
> paid plan. Upgrade to resume it.

> [accordion] Where does my Google Drive data live?
>
> In Basedash Warehouse, a warehouse that Basedash manages for you. Each
> connector syncs into its own schema. You can also [view the warehouse
> credentials](https://basedash.com/docs/data-sources/warehouses/basedash-warehouse.md#accessing-your-warehouse-credentials)
> to query the data from other tools.

## Related

* [All connectors](https://basedash.com/docs/data-sources/connectors.md) - Browse connectors by category
* [Basedash Warehouse](https://basedash.com/docs/data-sources/warehouses/basedash-warehouse.md) - Where connector data is stored
* [Data source access control](https://basedash.com/docs/administration/data-source-access-control.md) - Control who can see each connector's tables


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.