API Connectors

users-love-us medal soc2
Send your Google Sheets data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Google Sheets Connector Reference

8 dimensions
Fields

The Google Sheets connector allows you to pull data from any Google Sheet document. The fields below are the default fields. As soon as you connect your own Google Sheet on onboard.windsor.ai the first row of the sheets you connect will be added to the field list.

The Google Sheets connector exposes 8 fields (0 metrics, 8 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Google Sheets Fields

Google Sheets Account fields

The Account report of the Google Sheets connector includes 3 fields.

IDTypeNameDescription
account_idTEXTAccount IDThe Account ID
sheet_indexTEXTSheet IndexSheet Index
spreadsheet_idTEXTSheet IDSpreadsheet ID

Google Sheets other fields

The Google Sheets connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
data_fetched_atTIMESTAMPData fetched atUTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date