How to connect Google Sheets + Salesforce + Shopify
Zapier lets you send info between Google Sheets and Salesforce and Shopify automatically—no code required. With 6,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Salesforce + Shopify
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 Google Sheets, Salesforce, and Shopify. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
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.Welcome
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
Bottom-Up
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?
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 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.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.FileRequired
Title
Description
Salesforce Object
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.Welcome
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Salesforce ObjectRequired
Search ValueRequired
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
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 foundNew Customer
Triggers when a new customer is added to your Shopify account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAbandoned Cart Age (Hours)Required
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Draft Order
Triggers when a new draft order is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Paid Order
Triggers when an order is paid (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a new product is added to your Shopify store.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPayment Status
Order Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFirst NameRequired
Last NameRequired
Email AddressRequired
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Phone
Tags
Note
Accepts Marketing
Tax Exempt
Send E-Mail Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LocationRequired
ProductRequired
Product Variant Inventory IDRequired
Adjust Quantity By
Set Quantity To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Product TypeRequired
VendorRequired
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
First Name
Last Name
Email Address
Tags
Phone Number
Note
Tax Exempt
Accepts Marketing
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Product VariantRequired
Title
Price
Compare at Price
SKU
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.Product TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Email AddressRequired
First NameRequired
Last NameRequired
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Phone
Tags
Note
Accepts Marketing
Tax Exempt
Send E-Mail Invite
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProductRequired
TitleRequired
Exact Match
Price
Compare at Price
SKU
Inventory Policy
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
No 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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.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
Bottom-Up
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
Bottom-Up
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 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.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.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.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.Salesforce ObjectRequired
Search Results
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 appCustomer Account Enabled
Triggers when a customer account is enabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Cancelled Order
Triggers whenever a order is "cancelled" (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order
Triggers when a new purchase is made (only open orders) (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Order (Any Status)
Triggers when a new purchase is made (of any order status).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.BlogRequired
TitleRequired
Author NameRequired
ContentRequired
Featured Image URL
Excerpt/Summary
Tags
Is Published?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
Product Quantity
Product Title
Product Price
Weight in Grams
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - State/Province/Region
Shipping Address - Postal/Zip code
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - State/Province/Region
Billing Address - Postal/Zip code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
Product Quantity
Product Title
Product Price
Weight in Grams
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Shipping Address - First name
Shipping Address - Last name
Shipping Address - Company
Shipping Address - Phone
Shipping Address - Address
Shipping Address - Address con't
Shipping Address - City
Shipping Address - Country
Shipping Address - State/Province/Region
Shipping Address - Postal/Zip code
Billing Address - First name
Billing Address - Last name
Billing Address - Company
Billing Address - Phone
Billing Address - Address
Billing Address - Address con't
Billing Address - City
Billing Address - Country
Billing Address - State/Province/Region
Billing Address - Postal/Zip code
Send Receipt
Send Fulfillment Receipt
Location
Inventory Behaviour
Financial Status
Fulfillment Status
Source Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
TitleRequired
Price
Compare at Price
SKU
Inventory Policy
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProductRequired
Title
Product Type
Vendor
Product Description
Tags
Price
Images
SKU
Is Published?
Publish to Point of Sale
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Welcome
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appProductRequired
Product Variant TitleRequired
Exact Match
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitleRequired
Product TypeRequired
VendorRequired
Product Description
Tags
Published At
Price
Inventory Policy
Image URL
More Image URLs
SKU
Is Published?
Publish to Point of Sale
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
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 Google Sheets + Salesforce + Shopify Integrations Work
- Step 1: Authenticate Google Sheets, Salesforce, and Shopify.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.