Refound your company for the AI era at ZapConnect 2026. Save your spot →

Google BigQuery + Sage Intacct

Create new Sage Intacct contacts from new Google BigQuery rows

Streamline your database management with this simple workflow. Whenever a new row is added in Google BigQuery, a corresponding contact is immediately created in the Sage Intacct app. This efficient process saves you from manual data entry, offering a seamless way to maintain records across both platforms. Improve your productivity and ensure consistency with this automation.

When this happens...
New RowTriggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
TriggerPolling
automatically do this!
Create ContactCreates a new contact.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Google BigQuery and Sage Intacct

Discover other triggers and actions you can use with Google BigQuery and Sage Intacct

- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write

- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

- Status
Trigger
Polling
Try It
- State
Trigger
Polling
Try It
- State
Trigger
Polling
Try It
- Status
Trigger
Polling
Try It
- Suggested Contact Name
  Required
- Print As
  Required
- Last Name
- First Name
- Middle Name
- Prefix
- Company Name
- Primary Email Address
- Secondary Email Address
- Primary Phone
- Secondary Phone
- Mobile Phone
- Pager
- Fax
- Address Line 1
- Address Line 2
- Address Line 3
- City
- State or Territory
- ZIP or Postal Code
- Country
- ISO Country Code
- Primary URL
- Secondary URL
- Status
- Discount
- Is Taxable?
- Tax ID
- Show in Contact List
Action
Write
- Invoice Date
  Required
- Due Date
  Required
- Action
- Invoice Number
- Reference Number
- Description
- Document ID
- Base Currency
- Transaction Currency
- Exchange Rate - Date
- Exchange Rate - Rate
- Exchange Rate - Type ID
- Customer Message - Choose Existing Message
- Customer Message - Custom Message
- Contacts - Pay To
- Contacts - Return To
- Contacts - Return To - Tax ID
- Contacts - Return To - Tax Group
- Billback Template
- Attachment
- Customer
  Required
- Customer - Delivery Options
- Payment Term
- Tax Solution Key
- Invoice Summary
- Transaction Amount
  Required
- GL Account
  Required
- Override Offset GL Account
- Memo
- Allocation
- Account Label
- Location
- Department
- Employee
- Project
- Customer
- Vendor
- Item
- Warehouse
- Class
- Task
- Cost Type
- Asset
- Contract
- Affiliate Entity
Action
Write
- Document type
- Vendor
  Required
- Transaction date
  Required
- Date
- Rate
- Type ID
- Payment term
- Shipping method
- Attachment
- Tax solution
- Source document
- Primary contact
- Ship to contact
- Bill to contact
- Deliver to contact
- Item
  Required
- Unit
  Required
- Quantity
  Required
- Unit price
  Required
- Line description
- Line memo
- Location
- Warehouse
- Department
- Project
- Task
- Class
- Customer
- Employee
- Subtotals
- History records
Action
Write
- Customer
  Required
- Name
- Sales Representative
- Customer Type
- Territory
- Parent Customer
- Shipping Method
- Payment Term
- Account Group
- Price List
- Price Schedule
- Override Offset GL Account
Action
Write
- Document type
- Vendor invoice
  Required
- Vendor
- Transaction date
- Date
- Rate
- Type ID
- Payment term
- Shipping method
- Attachment
- Tax solution
- Source document
- Primary contact
- Ship to contact
- Bill to contact
- Deliver to contact
- Item
- Unit
- Quantity
- Unit price
- Line description
- Line memo
- Location
- Warehouse
- Department
- Project
- Task
- Class
- Customer
- Employee
- Subtotals
- History records
Action
Write
Find Customer
Finds a customer based on search criteria.
Action
Search
Find Vendor
Finds a vendor based on a search criteria.
Action
Search

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write
- Status
Trigger
Polling
Try It
New Payment Received (Accounts Receivable)
Triggers when a new AR payment is added.
Trigger
Polling
Try It
- Document type
- State
Trigger
Polling
Try It
- Due Date
  Required
- Created Date
  Required
- Vendor
- Transaction Amount
  Required
- GL Account
  Required
- Total Transaction Amount
- Memo
- Location
- Department
Action
Write
- Name
  Required
- Sales Representative
- Customer Type
- Territory
- Parent
- Shipping Method
- Term
- Account Group
- Price List
- Price Schedule
- Override Offset GL Account
Action
Write
- Project resource
- Project
- Employee
- Item
- Labor rate
- Expense rate
- AP and purchasing rate
Action
Write
- Bill
  Required
- Vendor
- Payment term
- Tax solution
- Attachment
- Bill summary
- Location
- Bill back template
- Fully paid date
- Pay to contact
- Return to contact
- Base currency
- Transaction currency
- Exchange rate date
- Exchange rate
- Exchange rate type
Action
Write
- Invoice
  Required
- Invoice Date
- Due Date
- Action
- Invoice Number
- Reference Number
- Description
- Document ID
- Base Currency
- Transaction Currency
- Exchange Rate - Date
- Exchange Rate - Rate
- Exchange Rate - Type ID
- Customer Message - Choose Existing Message
- Customer Message - Custom Message
- Contacts - Pay To
- Contacts - Return To
- Contacts - Return To - Tax ID
- Contacts - Return To - Tax Group
- Billback Template
- Attachment
- Customer
- Customer - Delivery Options
- Payment Term
- Tax Solution Key
- Invoice Summary
- Line Item Key
- Transaction Amount
- GL Account
- Override Offset GL Account
- Memo
- Allocation
- Account Label
- Location
- Department
- Employee
- Project
- Customer
- Vendor
- Item
- Warehouse
- Class
- Task
- Cost Type
- Asset
- Contract
- Affiliate Entity
Action
Write
Find Bill
Finds a bill based on a search criteria.
Action
Search
Find Invoice
Finds a invoice based on a search criteria.
Action
Search
Find Invoices
Finds invoices within a date range.
Action
Search

About Google BigQuery

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

Learn moreLearn moreHelpHelp

Related categories

Databases

Google

Premium

About Sage Intacct

Sage Intacct is a cloud-based financial management software that streamlines & automates accounting business processes, providing real-time financial insights.

HelpHelp

Related categories

Accounting

Premium

Related Zap Templates

Create contacts in Sage Intacct from new rows in Google BigQuery

Create new Sage Intacct contacts from new rows in Google BigQuery