Skip to main content
The Google Drive connector syncs your Google Drive data into Basedash Warehouse, where you can chart it, chat with it, and add it to dashboards like any other data source.
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.
To connect a single sheet, you can use the Google Sheets connector 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.
  • 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 lists the tables this connector syncs, any setup needed on the Google Drive side, and how it handles deleted records.

​
FAQ

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.
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.
In Basedash Warehouse, a warehouse that Basedash manages for you. Each connector syncs into its own schema. You can also view the warehouse credentials to query the data from other tools.