Microsoft Excel + Google BigQuery

Update rows in Google BigQuery whenever rows are updated in Microsoft Excel

Easily keep your datasets refreshed and accurate with this workflow. When changes are made to any row in your Microsoft Excel document, the corresponding row will be instantaneously updated in your Google BigQuery. This seamless link keeps your analytics and insights up-to-date, saving you precious time in data management.

When this happens...
Updated Row
Triggers when a row is added or updated in a worksheet.
TriggerScheduled
automatically do this!
Update Row(s)
Triggers when an existing row is updated in a table in BigQuery.
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

What does this mean?

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

- 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
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- 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

- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- 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.

Related categories

Similar apps

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn more

Related categories

Related Zap Templates

Add Microsoft Excel rows when new Google BigQuery jobs end

Create Google BigQuery rows from new Microsoft Excel rows

Microsoft Excel + Google BigQuery

Update rows in Google BigQuery whenever rows are updated in Microsoft Excel

New Row

Storage Source

Folder

New Worksheet

Storage Source

Folder

Add Row

Storage Source

Folder

Add Row to Table

Storage Source

Folder

Update Row

Storage Source

Folder

Find Row(s)

Storage Source

Folder

Query Job Completed (With Row Data)

Dataset

Table

New Job Completed

Create Row

Delete Rows

Run a Query

Location

API Request (Beta)

Query String Parameters

Headers

Additional Request Headers

Body

Find Row(s)

Sort By Column

Sort Direction

Find or Create Record

Sort By Column

Sort Direction

New Row in Table

Storage Source

Folder

Updated Row

Storage Source

Folder

Trigger Column

Add Row(s)

Storage Source

Folder

Create Spreadsheet

Storage Source

Folder

Column Headers

Zap Step Id

Find Row

Storage Source

Folder

Find or Create Row

Storage Source

Folder

New Row

Updated Row

IS Operator

Create Rows

Import Data

Skip Invalid Rows

Ignore Unknown Values

Update Row(s)

Find One Row