Google Sheets
Source — Vendo imports data from Google Sheets, letting you bring spreadsheet-based datasets into your analytics pipeline alongside 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 | Auto-detected (string, number, date, boolean) |
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
- In the Vendo app, navigate to Sources > Google Sheets
- Click Connect and authorize with your Google account via OAuth
- Select the spreadsheet and sheets to import
- Configure sync schedule (e.g., daily, hourly)
- Save — Vendo will run the initial import
Verify Setup
- Confirm the Google Sheets integration status is active in Vendo
- Check that a corresponding table appears in your BigQuery dataset
- Verify row counts match between the sheet and the imported table
Last updated on