Skip to main content
Connect your Google Sheets to AstroBee. Each sheet becomes a queryable source that you can analyze using natural language.
Experimental feature: Google Sheets connector is currently in beta. We’re actively improving sync reliability and adding more features.

​
Prerequisites

  • A Google account with access to the spreadsheet you want to sync
  • Read/Write access to the Google Sheet you want to connect

​
Connecting Google Sheets

1

Navigate to Sources

From the Sources page, click on “Google Sheets” in the Available Sources section
Sources page showing Google Sheets connector
2

Start connection

Click “Add Google Sheet” to begin the setup process
Configure Google Sheets interface
3

Authorize with Fivetran

AstroBee uses Fivetran to securely connect to Google Sheets. Click “Continue” to proceed
Fivetran authorization screen
Fivetran ensures:
  • Secure: Data transfer is encrypted end-to-end and your credentials are never exposed
  • Private: Your data passes through without permanent storage
4

Configure authentication and select your sheet

Choose your authentication method and specify which sheet to sync. The setup guide on the right provides detailed instructions from Fivetran.
Google Sheets authentication and configuration
Authentication options:
  • User OAuth (recommended): Authorize access to all spreadsheets your Google account can access
  • Service Account: Higher security option for specific spreadsheets only
Follow the Fivetran Google Sheets setup guide for detailed configuration steps, including:
  • How to select a range in your spreadsheet
  • Authentication best practices
  • Troubleshooting connection issues
After configuring, click “Authorize” to authenticate with Google
5

Test and save connection

Once authorized, enter your sheet URL and named range. Click “Save & Test” to verify the connection
Successful authentication with sheet configuration
6

Save your configuration

Back in AstroBee, your data is being synced from Google Sheets. This typically takes 10 seconds to 10 minutes depending on your data volume. Once synced, your configured sheet will appear. Click “Save” to complete the setup
Save Google Sheets connection in AstroBee
7

Connection complete

Your Google Sheet is now connected and appears in “My Sources”
Google Sheets connection completed

​
What happens next

After connecting your Google Sheet, you can create an ontology to start querying your data. Click “Create Ontology” to let AstroBee analyze your spreadsheet structure and generate a business model for natural language queries.

​
Syncing data

Google Sheets connections use manual sync - you control when data is refreshed. To sync your latest spreadsheet data:
  1. Navigate to the Sources page
  2. Find your Google Sheets connection
  3. Click the “Sync now” button
AstroBee will pull the latest data from your sheet.

​
Managing connections

​
Adding more sheets

Google Sheets is a one-to-one connector - each connection syncs exactly one sheet. To add more sheets:
  1. Click “Add Google Sheet” again
  2. Follow the same connection process
  3. Configure a different sheet URL
Each sheet becomes a separate data source in AstroBee.

​
Deleting a connection

To remove a Google Sheets connection:
  1. Navigate to the connection settings
  2. Click the “Remove connection” button
Deleting a connection removes the synced data from your warehouse. Any ontologies using this data will no longer work.

​
Troubleshooting

For additional help, see Fivetran’s Google Sheets troubleshooting guide.
Issue: Unable to authorize access to Google Sheets.Solution:
  • Ensure your Google account has access to the spreadsheet
  • Check that you’re signed in to the correct Google account
  • Try re-authorizing from the beginning
  • Verify your organization allows third-party access to Google Sheets
Issue: The spreadsheet URL you entered isn’t valid.Solution:
  • Copy the full URL from your browser’s address bar while viewing the sheet
  • Ensure the URL follows the format: https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/...
  • Verify the sheet isn’t deleted or moved
  • Check that the sheet is shared with your Google account
Issue: The named range you specified doesn’t exist in the sheet.Solution:
  • Open your Google Sheet and verify the named range exists
  • Check the spelling of the named range
  • Create the named range in Google Sheets if it doesn’t exist
  • Ensure the range contains data
Issue: Manual sync appears stuck or is taking longer than expected.Solution:
  • Large spreadsheets (thousands of rows) may take several minutes to sync
  • Check your internet connection
  • Avoid making changes to the sheet during sync
  • If stuck for more than 10 minutes, contact support at support@astrobee.ai
Issue: Synced data doesn’t reflect recent changes to your sheet.Solution:
  • Verify the sync completed successfully (check for sync status)
  • Ensure you’re looking at the correct named range
  • Try triggering a manual sync again
  • Check that your ontology is using the correct source tables

​
Next steps

Create an Ontology

Transform your spreadsheet data into a queryable business model

Ask Questions

Start analyzing your Google Sheets data with natural language
⌘I