Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Google BigQuery with Xero - no code necessary. See how you can get setup in minutes.
100%
Help
Google BigQuery
Google BigQuery
1. Choose trigger event
Xero
Xero
2. Choose action
1. Select the event
Setup
Test
Google BigQuery
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "Query Job Completed (With Row Data)" from Google BigQuery.
Add your action
An action happens after the trigger—such as "Add Items to Existing Sales Invoice" in Xero.
You’re connected!
Zapier seamlessly connects Google BigQuery and Xero, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Create a new record or update an existing record in your app.
Organization
Required
Credit Note ID
Required
Invoice ID
Required
Amount
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
From Account
Required
To Account
Required
Amount
Required
Date
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Code
Required
Name
Required
Type
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Type
Required
Contact
Required
Date
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Invoice ID
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Mark Item as a Sales Item?
Mark Item as a Purchase Item?
Item Name
Item Code
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact_name
Required
Email_address
Contact_account_number
Primary Person - First Name
Primary Person - Last Name
Phone - Country Code
Phone - Area Code
Phone Number
Fax - Country Code
Fax - Area Code
Fax - Number
Mobile - Country Code
Mobile - Area Code
Mobile - Number
Direct Dial - Country Code
Direct Dial - Area Code
Direct Dial - Number
Contact Address Type
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Contact_tax_number
Bank Account Number
Contact Number
Status
Date
Due_date
Currency
Url
Attachment
Branding_theme
Number
Reference
Sent_to_contact
Line_items_type
Item Code
Description
Quantity
Required
Unit Price
Discount %
Discount Amount
Account
Tax Rate
Tracking
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact
Required
Project Name
Required
Deadline for the project
Project Estimate
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact
Required
Repeated Invoice Schedule
Invoice Creation: Frequency Type
Required
Invoice Creation: Frequency (Period)
Required
Due Date Type: Payment Terms
Required
Set Due Dates (Days)
Required
Start Date:
Required
End Date
Status
Required
Currency
Branding_theme
Reference
Mark as approved for sending?
Email a copy to Sender?
Include PDF
Line Amount Types
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Purchase Order
Required
Contact
Update Method for Line Items
Date
Delivery_date
Line Amount Types
Purchase Order Number
Reference
Branding Theme
Currency
Status
Sent to Contact
Delivery Address
Attention To
Telephone
Delivery Instructions
Expected_arrival_date
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Organization
Required
Invoice_id
Required
Contact
Status
Date
Due_date
Expected_payment_date
Reference
Branding_theme
Url
Currency
Sent_to_contact
Attachments
Invoice_number
Line_amount_types
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Stop on error
Required
HTTP Method
Required
URL
Required
Query string parameters
Additional request headers
Body
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Search_by
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Invoice ID
Required
Include PDF File
Include Online Invoice URL
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Contact ID
Quote Number
Status
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search_by
Required
Include Online Invoice URL
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search_by
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search_by
Required
Mark Item as a Sales Item?
Mark Item as a Purchase Item?
Item Name
Item Code
Required
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
For AI agents & developers
Use Google BigQuery and Xero with AI agents and code
Beyond Zap workflows. Call Google BigQuery and Xero actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Google BigQuery and Xero actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Create Row
Add Items to Existing Sales Invoice
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Connect Google BigQuery and Xero to integrate crucial parts of your business
With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.
Automate your lead management and improve conversions
With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.
Create more impactful campaigns with automation
Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.
Provide world-class support with a little help from automation
Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.
Automate your way to actionable, up-to-date data
The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.
Resolve incidents faster with automation
Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.
Learn how to automate Google BigQuery on the Zapier blog
Learn how to automate Xero on the Zapier blog
Make work flow with AI
Level up your Google BigQuery to Xero integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Google BigQuery + Xero integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google BigQuery and Xero
What is the first step to integrate Google BigQuery with Xero?
The first step to integrate Google BigQuery with Xero is to connect both accounts through our platform. You will need your login credentials for both Google BigQuery and Xero. Once authenticated, you can start setting up triggers and actions that suit your workflow needs.
How do I set up triggers in Xero to send data to Google BigQuery?
To set up triggers in Xero, you will need to specify which events should initiate an action in Google BigQuery. This could include new invoices being finalized, updates to contacts, or changes in inventory levels. Once you've identified the trigger event in Xero, you'll map it to an appropriate action in Google BigQuery through our intuitive interface.
Can I pull data from Google BigQuery into Xero automatically?
Yes, you can set up actions where data from your BigQuery tables can be automatically pulled into Xero. This might require setting specific queries or using predefined datasets to ensure the data conforms with what needs to be updated or added in Xero.
Is it possible to update existing records in Xero using data from Google BigQuery?
Absolutely! You can configure actions where data updates in Google BigQuery trigger corresponding updates in existing records within Xero. Mapping fields correctly is crucial here so that the right details are amended based on your business logic and requirements.
What types of actions can be triggered in Google BigQuery by events occurring in Xero?
Various actions can occur such as inserting new rows of data corresponding to changes like new invoice creation or client additions within Xero. Custom SQL queries on datasets may also be triggered based on significant events detected from the Xero side.
Do I need coding skills to integrate Google BigQuery and Xero using this platform?
No coding skills are necessary for integrating these platforms through our service. Our easy-to-use interface allows users to set up integrations by selecting triggers and actions without needing any programming knowledge.
Are there any limitations on the type of data that can be exchanged between Google BigQuery and Xero?
While most transactional and record-based exchanges are supported, limitations might exist depending on specific field types or customizations within either platform's schema. It’s advisable to review any schema requirements beforehand when planning your workflow automation.
About Google BigQuery
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.
Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.
