Microsoft Excel + Google BigQuery

Create Google BigQuery rows from new Microsoft Excel rows

Send data from Microsoft Excel to Google BigQuery with this automation. As soon as you set up this integration, new rows on your Microsoft Excel spreadsheet will trigger the creation of rows on a Google BigQuery table. You'll have a more efficient workflow for analyzing your data.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerScheduled
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- ProjectRequired
- Dataset
- Table
Trigger
Scheduled
Try It

- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Api Docs Info
- Apply standard error handling?Required
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Additional Request Headers
- Body
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
- LimitRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more