Skip to main content
Guide to Connect Spreadsheets:
  1. Connect your Google or Microsoft account to Go Fig
  2. Use the file picker to select your spreadsheet
  3. Select the tabs to import, set a Collection name, and configure sync frequency

​
Overview

Connect online spreadsheets to Go Fig for live-synced data without manual uploads. Changes in your spreadsheet sync automatically, so you connect once and forget the CSV exports. Supported Platforms:
  • Google Sheets - synced from Google Drive
  • Excel Online - synced from Microsoft OneDrive/SharePoint

​
Connecting a Spreadsheet

1

Connect your account

On your Connectors page, click Add data source and select Google Sheets & Excel Online, the first card in the gallery. One card covers both platforms. If you haven’t connected the underlying account yet, authorize Go Fig to access your Google Drive (for Sheets) or OneDrive/SharePoint (for Excel).
The Connect a new data source modal with the Google Sheets and Excel Online connector tile highlighted.
2

Select your file

Use the file picker to browse and select your spreadsheet. You can select from a connected Google Drive or OneDrive account, or paste a spreadsheet URL directly.
The Connect Google Sheets and Excel Online screen with a field to paste a Google Sheets, OneDrive, or SharePoint URL.
3

Select tabs to import

Choose which tabs (or sheets) to import. When you import multiple tabs from one file, each table name combines the file name and the tab name.

​
Managing Spreadsheet Connections

To change which tabs Go Fig syncs, open the collection where your table lives, preview the table, and click Connector Settings. Select or deselect tabs, then click Save to resync immediately.

​
Best Practices

Use a clean data format: Keep one header row, avoid merged cells, and use consistent column types. Think “database table” rather than “formatted report.” In Excel, formatting your data as a Table (Insert → Table) helps with structure and automatic range expansion.
Keep calculated values simple: Go Fig imports values, not formulas. Put complex formulas in a separate tab and reference the results in your data table for faster, cleaner syncs.
Review before changing schema: Before adding or removing columns, check which flows and dashboards use that data to avoid breaking changes.