Microsoft Excel + Google BigQuery

Add Microsoft Excel rows when new Google BigQuery jobs end

Google and Microsoft apps power your data management, but they don't get along together without tedious workarounds. This integration saves you from that by automatically adding a new row to the end of a Microsoft Excel worksheet as soon as a query job completes in Google BigQuery. Bridge your apps for fast and worry-free organizing.

Google and Microsoft apps power your data management, but they don't get along together without tedious workarounds. This integration saves you from that by automatically adding a new row to the end of a Microsoft Excel worksheet as soon as a query job completes in Google BigQuery. Bridge your apps for fast and worry-free organizing.

  1. When this happens...
    Google BigQueryGoogle BigQuery
    Query Job Completed (With Row Data)

    Triggers when a query job has completed processing successfully.

    TriggerScheduled
  2. automatically do this!
    Microsoft ExcelMicrosoft Excel
    Add Row

    Adds a new row to the end of a worksheet.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • 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

    • 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
excel logo
excel logo

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

  • Microsoft
  • Spreadsheets

Similar apps

OneDrive integrationsOneDrive integrations

OneDrive

File Management & Storage, Microsoft
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip integrations

Quip

Documents
google-bigquery logo
google-bigquery logo

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

  • Databases
  • Google