Google Sheets + Shopify + Ecwid by Lightspeed Integrations
How to connect Google Sheets + Shopify + Ecwid by Lightspeed
Zapier lets you send info between Google Sheets and Shopify and Ecwid by Lightspeed automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Shopify + Ecwid by Lightspeed
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, Shopify, and Ecwid by Lightspeed. 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.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 foundBlogRequired
Blog Entry Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
Customer Account Enabled
Triggers when a customer account is enabled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Abandoned 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 Order
Triggers when an order is created (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Product
Triggers when a product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Tag Added to Customer
Triggers when a new tag is added to a customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Product
Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CustomerRequired
TagsRequired
Overwrite existing tags?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
External Id
A note about the company
Company Contact
Contact Email
Contact First Name
Contact Last Name
Contact Phone
Contact Title
Contact Locale
Location
Billing same as shipping address?
Company Shipping Address
Shipping Address Line 1
Shipping Address Line 2
Shipping Address City
Shipping Address Country Code
Shipping First Name
Shipping Last Name
Shipping Address Phone
Shipping Address Recipient
Shipping Address Zip
Shipping Address Zone Code
Location External ID
Location Locale
Location Name
Location Note
Location Phone
Tax Registration Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email AddressRequired
Customer Phone
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Address Phone
Tags
Note
Accepts Marketing
Tax Exempt
Tax Exemptions
Send E-Mail Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Fulfillment Order IDRequired
Notify Customer
Address Line 1
Address Line 2
City
Country Code
Province Code
Zip Code
Tracking Company
Tracking Number
Tracking URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Product
Product Variant
SKU
Product Quantity
Product Title
Product Price
Weight in Grams
Price
Rate
Title
Note
Discount - Type
Discount - Amount
Discount - Code
Additional Details
Tags
Buyer Accepts Marketing?
Shipping Address Instructions
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 - Country Code
Shipping Address - State/Province/Region
Shipping Address - State/Province/Region Code
Shipping Address - Postal/Zip code
Billing Address Instructions
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 - Country Code
Billing Address - State/Province/Region
Billing Address - State/Province/Region Code
Billing Address - Postal/Zip code
Send Receipt
Send Fulfillment Receipt
Location
Inventory Behaviour
Financial Status
Fulfillment Status
Code
Title
Price
Discounted Price
Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Channel IDRequired
Publish Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrderRequired
Amount
Currency
Type
Parent Transaction
Warning
Gateway
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order IDRequired
Email
Notes
Phone
Buyer Accepts Marketing?
Remove Customer from Order?
Tags
Additional Details
Shipping Address - Line 1
Shipping Address - Line 2
Shipping Address - City
Shipping Address - Company
Shipping Address - Country
Shipping Address - First Name
Shipping Address - Last Name
Shipping Address - Latitude
Shipping Address - Longitude
Shipping Address - Name
Shipping Address - Phone
Shipping Address - Province
Shipping Address - Province Code
Shipping Address - ZIP
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Title
Product Type
Vendor
Product Status
Product Description
Tags
Category
Collections to Join
Collections to Leave
Handle
Redirect Handle?
Alt Text
Media Content Type
Original Source
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 appOrder IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrder IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitlesRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant TitlesRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProductRequired
Product Variant TitleRequired
Exact MatchRequired
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
New Abandoned Cart
Triggered when a customer leaves an online store without making a purchase.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPayment Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPayment Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPayment Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCoupon NameRequired
Coupon CodeRequired
Discount
Discount Type
Status
Launch Date
Expiration Date
Total Limit
Uses Limit
applicationLimit
Order Count
repeatCustomerOnly
catalogLimitProducts
catalogLimitCategories
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
PriceRequired
SKU Number
Description
Quantity
Weight
Enabled
Unlimited
Compare To Price
Is Shipping Required
Warning Limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Link on your imageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Keywords
Order Number
Vendor Order Number
Email
Customer ID
Payment Status
Fulfillment Status
Accept Marketing
Referer ID
Product ID
Coupon Code
Total From
Total To
Created From
Created To
Updated From
Updated To
Payment Method
Shipping Method
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
Customer's Name
Customer's EmailRequired
Group ID
Minimum number of order a customer placed
Maximum number of order a customer placed
Accept Marketing
Created From
Created To
Updated From
Updated To
Customer's Password
Customer group ID
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 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 Blog
Triggers when a new blog is added to your Shopify store.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew 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 planNew Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
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 Refund
Triggers when a refund or partial refund occurs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when a customer's information is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Order
Triggers when an order is updated (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Order IDRequired
Type of Line Item to AddRequired
Reason for Edit
Notify the Customer?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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.Product IDRequired
Add New Image - File
Add New Image - Alt Text
Choose Existing Image
Price
Compare-at Price
Charge Tax On This Variant?
Cost Per Item
SKU (Stock Keeping Unit)
Barcode (ISBN, UPC, GTIN, etc.)
Track Quantity?
Continue Selling When Out of Stock?
This Is a Physical Product
Weight
Weight Unit
Country/Region of Origin
Harmonized System (HS) code
Position
Requires Components
Tax 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 Instructions
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 Instructions
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.Adjust or Set quantity?Required
The name of quantities to be changedRequired
The reason for the quantity changesRequired
LocationRequired
Product
Product VariantRequired
Quantity to Set or Adjust
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Product Type
Vendor
Product Status
Product Description
Tags
Collection ID
Handle
Note
First Product Option
Values for First Product Option
Second Product Option
Values for Second Product Option
Third Product Option
Values for Third Product Option
Category
Alt Text
Media Content Type
Original Source
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
TagsRequired
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
Company Name
Default Address
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Tags
Phone Number
Note
Tax Exempt
Tax Exemptions
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.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.Query - Name
Query - Confirmation Number
Query - Email
Query - Customer ID
Query - Location ID
Query - SKU
Query - Order ID
Sort Key
Reverse?
Raw Query
ActionThis is an event a Zap performs.SearchFind existing data in your appOwner ResourceRequired
Owner IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appIdsRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Variant SKURequired
ActionThis is an event a Zap performs.SearchFind existing data in your appName
Email AddressRequired
First Name
Last Name
Customer Phone
Company Name
Street Address
Street Address Line 2
City
State
State/Province Code
Country
Zip Code
Address Phone
Tags
Note
Accepts Marketing
Tax Exempt
Tax Exemptions
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 MatchRequired
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 foundCustomer Email
Agreed to receive email marketing
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Paid Order
Triggered when a new paid order is placed (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Product
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustomer's EmailRequired
Customer's Password
Customer group ID
Customer's Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Payment StatusRequired
Fulfilment StatusRequired
Product NameRequired
Product PriceRequired
Product QuantityRequired
Product SKU
Product Weight
Payment Method
Total
Tax
Order Comments
Shipping Rate
Shipping Person Name
Shipping Method Name
Shipping Person Company Name
Shipping Person Street
Shipping Person City
Shipping Person Country Code
Shipping Person Postal Code
Shipping Person State Code
Shipping Person Phone
Billing Person Name
Billing Person Company Name
Billing Person Street
Billing Person City
Billing Person Country Code
Billing Person Postal Code
Billing Person State Code
Billing Person Phone
Subtotal
Payment Module
customerTaxExempt
customerTaxId
customerTaxIdValid
reversedTaxApplied
IP Address
Coupon Discount
Referer Url
Volume Discount
Customer ID
Hidden
Membership Based Discount
Total And Membership Based Discount
Discount
Global Referer
Create Date
Customer Group
Tracking Number
Payment Message
External Transaction ID
Affiliate ID
Private Admin Notes
Pickup Time
Accept Marketing
Disable All Customer Notifications
External Fulfillment
External Order ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
SKU
Name
Quantity
Unlimited
Price
Compare To Price
Weight
Enabled
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Keyword
Name
Email
Group ID
Minimum number of order a customer placed
Maximum number of order a customer placed
Accept Marketing
Created From
Created To
Updated From
Updated To
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
SKU
Product ID
Enabled
ActionThis is an event a Zap performs.SearchFind existing data in your appKeyword
SKU Number
Product ID
Enabled
TitleRequired
PriceRequired
Description
Quantity
Weight
Unlimited
Compare To Price
Is Shipping Required
Warning Limit
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 Google Sheets + Shopify + Ecwid by Lightspeed Integrations Work
- Step 1: Authenticate Google Sheets, Shopify, and Ecwid by Lightspeed.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 Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Shopify
Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.
Related categories
About Ecwid by Lightspeed
Ecwid by Lightspeed is a cloud online store builder which lets you instantly launch an online store on any website, Facebook page, or multiple sites simultaneously.
Related categories
Other Google Sheets + Shopify Integrations
- activecampaign
- airtable
- trello
- schedule
- looping
- salesforce
- google-contacts
- clickfunnels
- asana
- xero
- sms
- klaviyo
- keap-max-classic
- stripe
- hubspot
- flodesk
- facebook-offline-conversions
- facebook-custom-audiences
- manychat
- typeform
- twilio
- sendinblue
- quickbooks
- pipedrive
- kajabi
- google-calendar
- getresponse
- thinkific
- tactful-ucx
- square
- shipstation
- onfleet
- keap
- google-forms
- zendesk
- zapier-chrome-extension
- wordsmith
- webflow
- thrivecart
- storage
- sql-server
- patreon
- mysql
- leadpages
- leadconnector
- gravity-forms
- google-drive
- google-docs
- google-chat
- facebook-lead-ads
- copper
- zoom
- zoho-sign
- zoho-mail
- zoho-desk
- zoho-crm
- youtube
- woocommerce
- wodify
- wave
- untappd
- trustpilot
- touchsms
- tookan
- surveymonkey
- superphone
- squarespace
- sparkpost
- smtp
- smsadvertio
- smartsheet
- shippo
- recharge
- reamaze
- pushover
- proof-factor
- powr-form-builder
- postalytics
- popupsmart
- paypal
- ontraport
- neoncrm
- mondaycom
- monday
- moloni
- microsoft-teams
- microsoft-outlook
- messenger-platinum-mobile-wallet
- mdstools
- mailjet
- magento
- lob
- kartra
- kafkai
- judgeme
- jotform
- intercom
- help-scout
- handwrytten
- google-tasks
- google-analytics
- freshdesk
- facebook-pages
- facebook-lead-ads-beta
- facebook-conversions
- email-parser
- dropbox
- drip
- docusign
- docparser
- detrack
- delighted
- dear-inventory
- clickup
- clearbit
- bombbombcom
- bitly
- bigmarker
- bigcommerce
- beaconstac
- autopilot
- apify
- alegra
- 90-day-sales