How to connect BigCommerce + Google Sheets + Salesforce
Zapier lets you send info between BigCommerce and Google Sheets and Salesforce automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with BigCommerce + Google Sheets + Salesforce
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 BigCommerce, Google Sheets, and Salesforce. And don’t forget that you can add more apps and actions to create complex workflows.
Customer Created
Triggers when an new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Filter by Status ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shipment Created
Triggers when a new shipment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Address Updated
Triggers when a customer address is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order Status Updated
Triggers when an order status have changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
First NameRequired
Last NameRequired
Company
Phone
Registration IP Address
Notes
Tax Exempt Category
Customer Group ID
ID
Force Password Reset
New Password
Accepts Product Review Abandoned Cart Emails
Store Credit Amounts
Origin Channel ID
Channel IDs
Name
Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
TypeRequired
Sku
Description
WeightRequired
Width
Depth
Height
PriceRequired
Cost Price
Retail Price
Sale Price
Map Price
Tax Class Id
Product Tax Code
Categories
Brand Id
Inventory Level
Inventory Warning Level
Inventory Tracking
Fixed Cost Shipping Price
Is Free Shipping
Is Visible
Is Featured
Related Products
Warranty
Bin Picking Number
Layout File
Upc
Search Keywords
Availability Description
Availability
Gift Wrapping Options Type
Gift Wrapping Options List
Sort Order
Condition
Is Condition Shown
Order Quantity Minimum
Order Quantity Maximum
Page Title
Meta Keywords
Meta Description
View Count
Preorder Release Date
Preorder Message
Is Preorder Only
Is Price Hidden
Price Hidden Label
Url
Is Customized
Open Graph Type
Open Graph Title
Open Graph Description
Open Graph Use Meta Description
Open Graph Use Product Name
Open Graph Use Image
Gtin
Mpn
Reviews Rating Sum
Reviews Count
Total Sold
Custom Fields ID
Custom Fields NameRequired
Custom Fields ValueRequired
Bulk Pricing Rules ID
Bulk Pricing Rules Quantity Min
Bulk Pricing Rules Quantity Max
Bulk Pricing Rules Type
Bulk Pricing Rules Amount
Images Image File
Images Is Thumbnail?
Images Sort order
Images Description
Images Image URL
Images ID
Images Product ID
Images URL Zoom
Images URL Standard
Images URL thumbnail
Images URL Tiny
Images Date modified
Videos Title
Videos Description
Videos Sort order
Videos Type
Videos Video ID
Videos ID
Videos Product ID
Videos Length
Variants Cost Price
Variants Price
Variants Sale Price
Variants Retail Price
Variants Weight
Variants Width
Variants Height
Variants Depth
Variants Is free shipping?
Variants Fixed cost shipping price
Variants Purchasing disabled
Variants Purchasing disabled message
Variants UPC
Variants Inventory level
Variants Inventory warning level
Variants BIN Picking number
Variants Product ID
Variants SKU
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Company
ID
Customer Group
ActionThis is an event a Zap performs.SearchFind existing data in your appName
SKU
ID
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Company
Customer ID
First NameRequired
Last NameRequired
Address 1Required
Address 2
CityRequired
State Or ProvinceRequired
Postal CodeRequired
Country CodeRequired
Phone
Address Type
Customer IdRequired
Id
Country
Name
Value
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Contact
Triggers when a new Contact is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Lead
Triggers when a new Lead is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planSalesforce ObjectRequired
Record to LinkRequired
FileRequired
VisibilityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
AccountRequired
Warning
Opportunity
Create New Opportunity
Converted StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent ObjectRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Title
Description
Salesforce Object
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Note
Salesforce ObjectRequired
Is Private
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Record to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent ObjectRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Search Results
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
WHERE ClauseRequired
Order By
Order Direction
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
WHERE ClauseRequired
Order By
Order Direction
Limit
Use Assignment Rules
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
Customer Address Created
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Category ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Customer Updated
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter by Channel ID
Filter by Status ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.TitleRequired
Url
BodyRequired
Is Published
Meta Description
Meta Keywords
Author
Thumbnail Path
Tags
Published Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Company
Address 1Required
Address 2
CityRequired
State Or ProvinceRequired
Postal CodeRequired
Country CodeRequired
Phone
Address Type
Customer IdRequired
Id
Country
Name
Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Company
Customer ID
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
Company
ID
Customer Group
First NameRequired
Last NameRequired
Phone
Registration IP Address
Notes
Tax Exempt Category
Customer Group ID
Force Password Reset
New Password
Accepts Product Review Abandoned Cart Emails
Store Credit Amounts
Origin Channel ID
Channel IDs
Name
Value
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
SKU
ID
TypeRequired
Description
WeightRequired
Width
Depth
Height
PriceRequired
Cost Price
Retail Price
Sale Price
Map Price
Tax Class Id
Product Tax Code
Categories
Brand Id
Inventory Level
Inventory Warning Level
Inventory Tracking
Fixed Cost Shipping Price
Is Free Shipping
Is Visible
Is Featured
Related Products
Warranty
Bin Picking Number
Layout File
Upc
Search Keywords
Availability Description
Availability
Gift Wrapping Options Type
Gift Wrapping Options List
Sort Order
Condition
Is Condition Shown
Order Quantity Minimum
Order Quantity Maximum
Page Title
Meta Keywords
Meta Description
View Count
Preorder Release Date
Preorder Message
Is Preorder Only
Is Price Hidden
Price Hidden Label
Url
Is Customized
Open Graph Type
Open Graph Title
Open Graph Description
Open Graph Use Meta Description
Open Graph Use Product Name
Open Graph Use Image
Gtin
Mpn
Reviews Rating Sum
Reviews Count
Total Sold
Custom Fields ID
Custom Fields NameRequired
Custom Fields ValueRequired
Bulk Pricing Rules ID
Bulk Pricing Rules Quantity Min
Bulk Pricing Rules Quantity Max
Bulk Pricing Rules Type
Bulk Pricing Rules Amount
Images Image File
Images Is Thumbnail?
Images Sort order
Images Description
Images Image URL
Images ID
Images Product ID
Images URL Zoom
Images URL Standard
Images URL thumbnail
Images URL Tiny
Images Date modified
Videos Title
Videos Description
Videos Sort order
Videos Type
Videos Video ID
Videos ID
Videos Product ID
Videos Length
Variants Cost Price
Variants Price
Variants Sale Price
Variants Retail Price
Variants Weight
Variants Width
Variants Height
Variants Depth
Variants Is free shipping?
Variants Fixed cost shipping price
Variants Purchasing disabled
Variants Purchasing disabled message
Variants UPC
Variants Inventory level
Variants Inventory warning level
Variants BIN Picking number
Variants Product ID
Variants SKU
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Case Attachment
Triggers when a new Attachment is added to a case.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew 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
Salesforce ObjectRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCampaignRequired
ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
LeadRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
Salesforce ObjectRequired
Description
Is Private
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.Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Record to UpdateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Record to UpdateRequired
Use Assignment Rules
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Search ValueRequired
Second Field to Search By
Second Search Value
Search Operator
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
WHERE ClauseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSalesforce ObjectRequired
Search ValueRequired
Second Field to Search By
Second Search Value
Search Operator
Use Assignment Rules
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
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How BigCommerce + Google Sheets + Salesforce Integrations Work
- Step 1: Authenticate BigCommerce, Google Sheets, and Salesforce.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.