Google Sheets
Import spreadsheet data from Google Sheets into Vendo for analytics and cross-channel reporting.
Last reviewed September 15, 2026
Source: Vendo imports data from Google Sheets. You can bring spreadsheet-based datasets into your analytics pipeline with your other sources.
What Vendo Syncs
Vendo reads rows from your connected Google Sheets and imports them into BigQuery for unified reporting.
Supported Data
| Data | Description |
|---|---|
| Sheet Rows | All rows from selected sheets, mapped to BigQuery columns |
| Multiple Sheets | Import from multiple sheets within a single spreadsheet |
| Headers | First row is used as column headers |
| Data Types | All columns are imported as text (STRING) |
| Empty Rows | Vendo skips rows that have no values |
| Added Columns | _row_number, _sheet_title, job_id and extracted_at |
Sync Behavior
| Behavior | Description |
|---|---|
| Full Refresh | Each sync replaces the previous dataset |
| Scheduled Sync | Runs on a configurable schedule |
| Multiple Spreadsheets | Connect multiple Google Sheets per account |
Platform Details
| Setting | Value |
|---|---|
| Auth Method | OAuth 2.0 (Google Account) |
| API | Google Sheets API v4 |
| Sync Method | Server-side scheduled import |
| Destination | BigQuery table per sheet |
Common Use Cases
- Offline revenue data: Import offline sales or CRM exports for blended reporting
- Custom mapping tables: Maintain UTM-to-campaign mappings or product categorizations
- Budget tracking: Bring in ad budget plans for spend-vs-budget analysis
- Manual data entry: Supplement automated pipelines with manually curated data
Setup
Caution: Self-serve setup cannot select a spreadsheet at this time. If the source has no spreadsheet, the sync fails. Contact the Vendo team to set the spreadsheet for your source.
- In Vendo, go to Data → Integrations → Sources and add a Google Sheets source.
- Click Connect Google Sheets.
- Authorize with your Google account (OAuth).
- Select the spreadsheet and sheets to import.
- Set the sync schedule (for example, daily or hourly).
- Save the source. Vendo then runs the initial import.
Verify Setup
- Confirm that the Google Sheets source status is active in Vendo.
- Check that a corresponding table appears in your BigQuery dataset.
- Verify that the row counts in the sheet and the imported table match.
Last updated on