Send data to Google Sheets

Create a Google Sheets data output, choose its tables and columns, and keep it synchronized with Control.

A Google Sheets connector sends prepared data from Control to a spreadsheet for analysis, reporting, or financial models. Each connector can populate several tabs from different source tables and keep them updated automatically, manually, or on a schedule.

Before you begin

• Connect and sync at least one data source in Control. The connector can only use output tables and columns that are available in your workspace.
• Create or open the destination Google Sheet and make sure you can share it with an editor.
• Decide which datasets belong in the spreadsheet and which columns its readers need.
• Confirm that you have permission to create and edit data outputs in Control. View-only users can inspect existing connectors but cannot change them.

Connect the spreadsheet

1. Open .
2. Choose Add data output.
3. On General, enter a name that your team will recognize.
4. Copy the service-account email shown under Grant editor access.
5. In Google Sheets, choose Share, add that email, and grant Editor access.
6. Copy the full spreadsheet URL from the browser and paste it into Google Sheets URL.
7. Choose Validate and wait for the access check to succeed.

The service-account email is specific to your Control workspace. Share the sheet with the address displayed in the connector instead of reusing an address from another workspace or an example.

Configure output tabs

1. Open Tabs and choose Add sheet tab.
2. Select the Source table. The list contains the data models enabled for your workspace.
3. Enter a unique Tab name for the destination spreadsheet.
4. Select at least one column.
5. Drag selected columns into the order in which they should appear.
6. Configure column filters or one sort column when the output should contain a narrower or ordered result.
7. Choose Preview to check the data before creating the connector.
8. Repeat these steps for each additional output tab.

Under Advanced settings, choose whether the synchronized table includes a header row. New tabs use Google Connected Sheets.

Save the connector before using Configure with AI. When the feature is available for your workspace, you can ask Control to configure a new or selected tab and then review the proposed table, columns, filters, and sorting.

Choose a sync schedule

Open Schedule and choose how Control updates the spreadsheet:

Mode	Behavior
Automatic	Syncs after new prepared data becomes available in Control.
Manual	Syncs only when a user chooses Sync now on the connector.
Scheduled	Syncs every 10 minutes, hourly, or daily at the selected time in UTC.

Choose Create after the General, Tabs, and Schedule steps are complete.

Run and verify the first sync

1. Find the connector under .
2. If you selected Manual, choose Sync now. Automatic and scheduled connectors run when their trigger occurs.
3. Wait for the connector to finish syncing.
4. Open the destination spreadsheet and confirm that every configured tab exists, the columns are in the intended order, and the expected rows are present.
5. Open and expand the run to verify each tab.

History shows the connector, start time, trigger, overall status, synchronized-tab count, triggering user or system, and duration. A run can be Syncing, Synced, or Errored. Expanded tab details can also identify missing access or a changed source schema.

Understand the generated tabs

New connectors use Google Connected Sheets. For each configured output, Control can create:

• the tab name you configured, which contains the connected table; and
• a backing data-source tab whose name ends in _bq.

Leave the backing tab and its connection unchanged. Build formulas, pivots, charts, and presentation views outside the synchronized table so refreshes do not conflict with manually maintained content.

Connected output tables return up to 100,000 rows. Use filters to reduce a larger result or use Parquet exports for warehouse-scale delivery.

Changing the selected columns of a previously synchronized tab clears its existing output and re-syncs it with the new schema. Review formulas and other references before confirming Clear and re-sync.

Troubleshooting

Problem	Resolution
Validation fails	Confirm that you pasted a Google Sheets URL and shared that exact spreadsheet with the displayed service-account email as Editor. Then choose Validate again.
No source tables are available	Connect and successfully sync a source system first. If the required data model is still missing, ask your Control administrator or Control support whether it is enabled for the workspace.
A run shows No Access	Restore Editor access for the service-account email, then run the connector again.
A tab shows Schema Changed	Edit the tab, select columns that still exist in the source table, save, and confirm the clear-and-re-sync warning.
Output contains unexpected rows	Review the selected source table, filters, and sort configuration. Use Preview to verify the result before the next sync.
Output stops at 100,000 rows	Add filters to reduce the result or use a Parquet export for the full dataset.

If a problem continues, contact Control support with the connector name, run start time, affected tab, and displayed status. Do not include spreadsheet contents, service-account credentials, access tokens, or provider secrets.

Next steps

• Review how financial data flows through Control to understand which prepared data appears in outputs.
• Use Parquet exports when the destination is a warehouse or the dataset is too large for Google Sheets.