Google BigQuery + Sage Intacct

Create new Sage Intacct contacts from new rows in Google BigQuery

Simplify your data management with this efficient workflow. As soon as a new row is formulated in Google BigQuery, this automation assists in creating a corresponding row in Sage Intacct. This seamless transfer eliminates the need for manual data entry, saving your business time and enhancing accurate data synchronization. Ideal for businesses aiming to optimize their data monitoring methods.

When this happens...
TriggerPolling
automatically do this!
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

- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write

- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

- Status
Trigger
Polling
Try It
- State
Trigger
Polling
Try It
- State
Trigger
Polling
Try It
- Status
Trigger
Polling
Try It
- Suggested Contact NameRequired
- Print AsRequired
- 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 DateRequired
- Due DateRequired
- 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
- CustomerRequired
- Customer - Delivery Options
- Payment Term
- Tax Solution Key
- Invoice Summary
- Transaction AmountRequired
- GL AccountRequired
- 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
- VendorRequired
- Transaction dateRequired
- Date
- Rate
- Type ID
- Payment term
- Shipping method
- Attachment
- Tax solution
- Source document
- Primary contact
- Ship to contact
- Bill to contact
- Deliver to contact
- ItemRequired
- UnitRequired
- QuantityRequired
- Unit priceRequired
- Line description
- Line memo
- Location
- Warehouse
- Department
- Project
- Task
- Class
- Customer
- Employee
- Subtotals
- History records
Action
Write
- CustomerRequired
- 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 invoiceRequired
- 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 IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
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
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
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 DateRequired
- Created DateRequired
- Vendor
- Transaction AmountRequired
- GL AccountRequired
- Total Transaction Amount
- Memo
- Location
- Department
Action
Write
- NameRequired
- 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
- BillRequired
- 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
- InvoiceRequired
- 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 more

Related categories

About Sage Intacct

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

Related categories

Accounting

Related Zap Templates

Create contacts in Sage Intacct from new rows in Google BigQuery

Create new Sage Intacct contacts from new Google BigQuery rows

Google BigQuery + Sage Intacct

Create new Sage Intacct contacts from new rows in Google BigQuery

Query Job Completed (With Row Data)

New Job Completed

Create Row

Delete Rows

Run a Query

API Request (Beta)

Get Rows for Job Completed

New Contact

New Invoice

New Sales Invoice

New Vendor

Create Contact

Create Invoice

Create Vendor Invoice

Update Customer

Update Vendor Invoice

Find Customer

Find Vendor

New Row

Updated Row

Create Rows

Import Data

Update Row(s)

Find One Row

Find or Create Record

New Customer

New Payment Received (Accounts Receivable)

New Vendor Invoice

Create Bill

Create Customer

Create or Update Project Resource

Update Bill

Update Invoice

Find Bill

Find Invoice

Find Invoices

About Google BigQuery

Related categories

About Sage Intacct

Related categories

Related Zap Templates

Related Zap Templates