QuickBooks Online + Salesforce + SQL Server Integrations
QuickBooks Online + Salesforce + SQL Server Integrations
Zapier lets you send info between QuickBooks Online and Salesforce and SQL Server automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with QuickBooks Online + Salesforce + SQL Server
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with QuickBooks Online, Salesforce, and SQL Server. And don’t forget that you can add more apps and actions to create complex workflows.
New Account
Triggered when you add a new account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggered when you add a new customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Expense
Triggers when a new expense is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggered when you add a new invoice (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Payment
Triggered when a payment is received (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggered when a new sales receipt is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Vendor
Triggered when a new vendor is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planVendorRequired
Terms
Transaction Date
Due Date
Bill Number
Department
Currency
Only available if multicurrency is enabled.
Global Tax Calculation
Description
AmountRequired
Billable?
If a line item is billable, please use the Customer field to specify which customer.
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
AccountRequired
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
Send Later?
Billing Address
Credit Memo Date
Defaults to today's date if not specified.
Credit Memo Number
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
AmountRequired
Service Date
Product/Service
Description
Quantity
Rate
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed On Credit Memo
Memo
Apply Tax After Discount?
US versions of QuickBooks only.
Discount Value
Discount Percent
Sales Tax Rate
Shipping Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Select a specific customer.
Number
Max of 21 characters. If empty, Quickbooks will generate one by incrementing the last number, but only if you have custom transaction numbers disabled. number automatically. Max of 21 characters.
Line AmountRequired
Should not include tax.
Line Description
Line Item/Product
Line Item Quantity
Line Item Tax Code
Line Item Service Date
Format: YYYY-MM-DD
Rate
When using this field, the Rate * Quantity must be equal to the line amount
Expiration Date
Message displayed on estimate
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Shipping Address
If the customer you enter in the "Customer" field has a default shipping address, that address will be used if this field is left blank.
Shipping amount
Bill Email
Email address where estimate is sent. Separate emails with commas for multiple addresses
Send later
If set to true, the Bill Email field should also be provided
Discount Value
Discount values must be positive (e.g.
10for a 10 value discount)Discount Percent
Discount values must be positive (e.g.
10for a 10% discount)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
NameRequired
Description On Sales Forms
Sales Price/Rate
Description On Purchase Forms
Cost
SKU
Category
Is Taxable?
Only applicable to US companies.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
If not set, the customer's primary email will be used.
Cc
Bcc
Send Later?
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Shipping Address
If the customer you enter in the "Customer" field has a default shipping address, that address will be used if this field is left blank.
Terms
Invoice Date
Defaults to today's date if not specified.
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
If empty, no Invoice number is added. Max of 21 characters or put AUTO_GENERATE to let QuickBooks increment this automatically.
Service Date
Product/Service
Description
Quantity
Rate
Should not include tax.
AmountRequired
Should not include tax.
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Apply Tax After Discount?
Discount Value
Discount values must be positive (e.g.
.10for a 10% discount)Discount Percent
Shipping Tax
Shipping
Deposit
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Department
Only available if your preferences allow tracking of department.
Location
Only available for France locales.
Currency
Only available if multicurrency is enabled. Defaults to your home currency if left blank.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Total AmountRequired
Unapplied Amount
The amount that has not been applied to pay amounts owed for sales transactions.
Transaction Date
Payment Method
Payment Reference Number
Deposit To Account
A.K.A. Income Account
Line Amount
Should not include tax.
Memo
Line Linked Invoice
Only choose an invoice if this payment is linked to one.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Refund FromRequired
Customer
Email
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Refund Receipt Date
Defaults to today's date if not specified.
Refund Receipt Number
Transaction Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Payment Method
Check Number
Print Later?
Product/ServiceRequired
AmountRequired
Service Date
Description
Quantity
Rate
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed On Refund Receipt
Memo
Apply Tax After Discount?
US versions of QuickBooks only.
Discount Value
Discount Percent
Sales Tax Rate
Shipping
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales ReceiptRequired
Email
Send to an explicit email address instead of the receipt billing one, and updates the one on the sales receipt to this.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Company
Email
Title
First name
Middle name
Last name
Suffix
Display name as
Must be unique for every customer.
Phone
Mobile
Fax
Other
Website
Print On Check As
Notes
Billing Address - Street
Billing Address - City/Town
Billing Address - State/Province
Billing Address - ZIP code
Billing Address - Country
Shipping Address - Street
Shipping Address - City/Town
Shipping Address - State/Province
Shipping Address - ZIP code
Shipping Address - Country
Exemption Details
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
PhoneRequired
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Enter the vendor's display name exactly as it appears in QuickBooks Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFull NameRequired
Enter the vendor's display name exactly as it appears in QuickBooks Online.
PhoneRequired
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSalesforce ObjectsRequired
Pick which type of object you want to watch for new items of (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
Pick which type of object you want to watch for updated records of (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)
Record to LinkRequired
FileRequired
The Content Document ID of a file that has been uploaded to a library in Salesforce CRM Content or Salesforce Files
VisibilityRequired
Specifies whether this file is available to all users, internal users, or shared users.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Salesforce ObjectRequired
Pick the type of object you want to attach the file to (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).
Description
Is Private
Defaults to false if left blank.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Title
Description
Salesforce Object
Pick the type of object if you want to attach the file to (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Record to UpdateRequired
Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)
Record to UpdateRequired
Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Salesforce are located here https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_list.htm
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Pick which type of object you want to search for. You can only search for multiple records which are all the same object type.
Search Results
Select the format of search results to be returned. If multiple search values are provided, the choice will be applied to each search value.
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)
Search ValueRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTable/ViewRequired
We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
Order By
Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like
date_createdor your autoincrementid. Column names that contain a space must be enclosed within brackets[ ].Dedupe Key
We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Table
Triggered when you add a new table.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TableRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
New Bill
Triggers when a new bill is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Estimate
Triggered when you add a new estimate.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggered when you add a new invoice.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggered when a new sales receipt is added (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Purchase Order
Triggers when a new purchase order is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggered when an existing customer is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planVendorRequired
Specifies the vendor for this bill.
Bill Number
Line Item
Line Description
AmountRequired
Amount of the line item.
Qty
Quantity of the line item.
Unit Price
Unit Price of the line item.
Line Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
AP Account
Customer
Specifies the customer associated with the bill.
Due Date
Transaction Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Specifies the vendor for this bill.
Terms
Transaction Date
Due Date
Bill Number
Department
Global Tax Calculation
Product/Service
Description
Qty
Rate
AmountRequired
Billable?
If a line item is billable, please use the Customer field to specify which customer.
Customer
Line Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Display Name
If not set, Full Name will be used here.
Title
First Name
Last Name
Company
Email
Phone
Mobile
Fax
Website
GST Registration Type
GSTIN
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
Address Country
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State Code
Shipping Address Zip Code
Shipping Address Country
Notes
Currency
Only available if multicurrency is enabled.
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Choose a Parent Customer if you're creating a Job/sub-customer.
Bill with Parent?
If no, this customer will be billed.
Preferred Payment Method
Preferred Delivery Method
Terms
Customer Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payee TypeRequired
Is the payee a Vendor, Customer, or Employee?
Payment TypeRequired
Bank/Credit AccountRequired
Payment Date
Defaults to today's date if not specified.
Payment Method
Reference Number
Will be used as check number if payment type is check.
Print Later?
Only applicable if payment type is check.
Account
Description
Amount
You must enter an amount here or in the "Amount" field under "Item Details."
Billable Status
Tax Code
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Product/Service
Description
Quantity
Rate
Amount
You must enter an amount here or in the "Amount" field under "Account Details."
Billable Status
Tax Code
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Journal Date
Defaults to today's date if not specified.
Journal Number
AccountRequired
Debit AmountRequired
Total amount of "Debits" line items must equal the total amount of "Credits" line items.
Description
Customer Name
Vendor Name
Employee Name
Department
Only available if your preferences allow tracking of department.
Class
AccountRequired
Credit AmountRequired
Total amount of "Credits" line items must equal the total amount of "Debits" line items.
Description
Customer Name
Vendor Name
Employee Name
Department
Only available if your preferences allow tracking of department.
Class
Memo
Currency
Only available if multicurrency is enabled. Defaults to your home currency if left blank.
Exchange Rate
Only available if multicurrency is enabled.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer
Select a specific customer, or, use the below field to look up a customer on demand.
Find Customer by Name/Email
If you just have access to the customer's name or email, use this.
Email
Send Later?
Note
Message
Line AmountRequired
Should not include tax.
Service Date
Line Description
Product/Service
Line Item Quantity
Line Item Unit Price
Should not include tax.
Line Item Tax Code
Line Item Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Transaction Date
Total Discount
Will be added as a Discount Line item. The company preference Sales Form Entry | Discounts must be enabled.
Payment Method
Payment Reference Number
Deposit To Account
A.K.A. Income Account
Sales Receipt Number
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
Address Country
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State Code
Shipping Address Zip Code
Shipping Address Country
Currency
Only available if multicurrency is enabled.
Exchange Rate
The number of home currency units it takes to equal one unit of currency specified above. Only available if multicurrency is enabled.
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Shipping Tax
Shipping Cost
Department
Only available if your preferences allow tracking of department.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Purchase Order Status
Mailing Address
Address to which the payment should be sent.
Shipping Address
Address to which the vendor shipped or will ship goods associated with purchase.
Purchase Order Date
Ship Via
Purchase Order Number
Account
Description
Amount
You must enter an amount here or in the "Amount" field under "Item Details."
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Product/Service
Description
Quantity
Rate
Amount
You must enter an amount here or in the "Amount" field under "Account Details."
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Your Message to Vendor
Memo
For internal use. Will not appear on purchase order to vendor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
EmailRequired
Send to an explicit email address instead of the invoice billing one, and updates the one on the invoice to this.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Activity TypeRequired
Is this for an Employee or Vendor?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
Customer
Email
Cc
Bcc
Send Later?
Billing Address
Shipping Address
Terms
Invoice Date
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
Service Date
Product/Service
Description
Quantity
Rate
Should not include tax.
Amount
Should not include tax.
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Apply Tax After Discount?
Discount Value
Discount values must be positive (e.g.
.10for a 10% discount)Discount Percent
Shipping Tax
Shipping
Deposit
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Department
Only available if your preferences allow tracking of department.
Location
Only available for France locales.
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Quickbooks are located here https://developer.intuit.com/app/developer/qbo/docs/develop
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search FieldRequired
Search ValueRequired
Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.
Full NameRequired
Display Name
If not set, Full Name will be used here.
Title
First Name
Last Name
Company
Email
Phone
Mobile
Fax
Website
GST Registration Type
GSTIN
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
Address Country
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address State Code
Shipping Address Zip Code
Shipping Address Country
Notes
Currency
Only available if multicurrency is enabled.
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Choose a Parent Customer if you're creating a Job/sub-customer.
Bill with Parent?
If no, this customer will be billed.
Preferred Payment Method
Preferred Delivery Method
Terms
Customer Type
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Outbound Message
Triggers when a new outbound message is received in Salesforce.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Disclaimer
This trigger works on Salesforce objects with less than 104,000 records. If the "Field Updated to" is specified, the limit applies to only the records with the value specified. Check how many records you have in your account by following the steps under Viewing Storage Usage. You can also setup a Zap with the New Outbound Message trigger to workaround this limit.
Salesforce ObjectRequired
Pick which type of object you want to watch for changes on.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCampaignRequired
Select which campaign to add contact. If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.
ContactRequired
If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
Select which campaign to add lead. If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.
LeadRequired
If using the Search for this field, click "Refresh Fields" below to make sure all fields are available to you.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Contact
Creates a new contact in Salesforce.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Lead
Creates a new lead in Salesforce.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Pick which type of object you want to create (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead to UpdateRequired
Search for or select the lead you'd like to update. Use Custom Value to select a lead from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Pick which type of object you want to update (Note: we do our best to support all objects, but due to their complex nature, some may not work flawlessly)
Record to UpdateRequired
Search for or select the record you'd like to update. Use Custom Value to select a record from a previous step. If using the Search, click "Refresh Fields" below to update the available input fields.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Pick which type of object you want to search for.
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Pick which type of object you want to search for.
WHERE ClauseRequired
Enter a SOQL WHERE clause. See our help docs for Tips and Examples.
ActionThis is an event a Zap performs.SearchFind existing data in your appQueryRequired
Query results must have a unique
idfield so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTable/ViewRequired
Primary KeyRequired
Usually something auto-incremented like
id. Must be unique. Column names that contain a space must be enclosed within brackets[ ].Order ByRequired
Usually something like
date_updatedorlast_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.Trigger Column
Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planTableRequired
ID ColumnRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.QueryRequired
You should include desired ordering and limiting (usually to 1 record) in the query.
This query must run in less than ~30 seconds.
ActionThis is an event a Zap performs.SearchFind existing data in your app
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How to connect QuickBooks Online + Salesforce + SQL Server
- Step 1: Authenticate QuickBooks Online, Salesforce, and SQL Server.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About QuickBooks Online
Related categories
Similar apps
Xero
Accounting
FreeAgent
Accounting
Wave
Accounting
About Salesforce
Related categories
About SQL Server
Related categories
Similar apps
MySQL
Databases
PostgreSQL
Databases
Firebase / Firestore
DatabasesGet started for free
You can't add more hours to the day. Zapier is the next best thing.