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

Google BigQuery + Sage Intacct

Create new Google BigQuery rows for every new Sage Intacct invoice

Streamline your financial data processing by connecting Sage Intacct and Google BigQuery. With this setup, whenever a new invoice comes in Sage Intacct, a corresponding row is created in Google BigQuery. This link offers a seamless way to enrich your database, maintain seamless records, and provide a broader view over your financial operations. Boost your data analytics capabilities by integrating these two powerful platforms.

When this happens...
New InvoiceTriggers when a new invoice is created.
TriggerPolling
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
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 Sage Intacct and Google BigQuery

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

- 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
  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
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
- 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

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 new Sage Intacct contacts from new rows in Google BigQuery

Create new Sage Intacct contacts from new Google BigQuery rows