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

You can connect Google Sheets in two ways: from the Sources page if you’re already using AstroBee, or during the onboarding process if you’re a new user.
1

Choose Connect Sources

On the Import Data screen, click the Connect Sources card.
Onboarding screen with Connect Sources option
2

Select Google Sheets

Click Connect next to Google Sheets in the list of available connectors.
Available connectors including Google Sheets
3

Start connection

A “Configure Connector” modal appears showing “Google Sheets Not Connected”. Click the orange Add Google Sheet button to begin setup.
Configure Google Sheets modal
4

Authorize with Fivetran

AstroBee uses Fivetran to securely connect to Google Sheets. Review the security information and click Continue.
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
5

Choose authentication method

Select your preferred authentication method:
Google Sheets authentication options
  • Authorize with User account (recommended): Access all spreadsheets your Google account can access
  • Authorize Service Account: Higher security option for specific spreadsheets only
Click Authorize to authenticate with Google.Follow the Fivetran Google Sheets setup guide for detailed configuration steps.
6

Configure sheet and test

After authentication succeeds, enter your sheet details:
Google Sheets configuration with sheet URL and named range
  • Sheet URL: Paste the full URL of your Google Sheet
  • Named Range: Select or enter the named range to sync
Click Save & Test to verify the connection.
7

Save configuration

Back in AstroBee, the “Configure Connector” modal shows your connection status as “Scheduled to start”.
Google Sheets connection configured
You can click + Add Another to connect additional sheets, or click Continue to proceed.
8

Data layer building

A modal appears showing “Your data layer is building”. AstroBee is unifying, deduplicating, and resolving entities across your data.
Data layer building modal
This may take 10 minutes to a couple of hours. Feel free to close this and come back later.
9

Data syncing

The Sources page shows your sync progress. Your data source is syncing and the data layer will be generated automatically once syncing completes.
Google Sheets syncing progress
It’s safe to close this window and continue working. You can connect other data sources while you wait.
10

Connection complete

Your Google Sheets connection now appears under MY SOURCES on the Sources page. You’ll see the sync status while data loads.
Google Sheets connection completed

​
What happens next

After connecting your Google Sheet, AstroBee automatically generates a data layer from your synced data. Once complete, you can start querying your spreadsheet using natural language.
You can also edit your data layer to customize entities, add properties, or create relationships.

​
Syncing data

Google Sheets connections sync automatically when first connected. After the initial sync completes, you can trigger manual syncs to refresh your data. To sync your latest spreadsheet data:
  1. Navigate to the Sources page
  2. Find your Google Sheets connection under MY SOURCES
  3. Click the sync button
AstroBee will pull the latest data from your sheet.

​
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 data layer is using the correct source tables
Issue: Sync completed but data layer shows an error or never finishes building.Solution:
  • Check that your sheet contains actual data (not empty)
  • Verify the named range includes column headers
  • Try refreshing the page to see updated status
  • If the error persists, try disconnecting and reconnecting Google Sheets
  • Contact support at support@astrobee.ai with the error message if the issue continues

​
Next steps

Create a Data Layer

Transform your spreadsheet data into a queryable business model

Ask Questions

Start analyzing your Google Sheets data with natural language