Ecwid by Lightspeed + Google Sheets
Create new Ecwid by Lightspeed customers from new or updated rows in Google Sheets team drive
Keep your customer information updated with this seamless workflow. Whenever there's a new or updated row in your Google Sheets on Team Drive, it will immediately create a new customer in your Ecwid by Lightspeed. This efficient process saves time, ensures accuracy, and provides a simplified way to manage your customer data.
Keep your customer information updated with this seamless workflow. Whenever there's a new or updated row in your Google Sheets on Team Drive, it will immediately create a new customer in your Ecwid by Lightspeed. This efficient process saves time, ensures accuracy, and provides a simplified way to manage your customer data.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create CustomerCreates a new customer.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
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.Info
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
Background Color
Text Color
Bold
Italic
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
Overwrite existing worksheet with the same title
Headers
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s) to DeleteRequired
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.HTTP MethodRequired
URLRequired
Query String Parameters
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 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
About Ecwid by Lightspeed
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Save new Ecwid orders to Google Sheets rows
- Add line items from new Ecwid paid orders to Google Sheets as multiple rows
- Create Google Sheet rows for new orders in Ecwid
- Create Google Sheets rows for new paid orders in Ecwid
- Create Google Sheet row(s) for new paid orders in Ecwid
- Create Google Sheets spreadsheet rows from new Ecwid orders
- Add new products from Ecwid by Lightspeed to Google Sheets rows
- Create columns in Google Sheets for new Ecwid by Lightspeed orders
- Update Ecwid by Lightspeed products from new or updated Google Sheets rows
- Create products in Ecwid by Lightspeed from new or updated Google Sheets rows
- Update Ecwid by Lightspeed products when new or updated Google Sheets spreadsheet rows are detected
- Add new Ecwid by Lightspeed products to Google Sheets rows for easy updates
- Add new Ecwid by Lightspeed orders to Google Sheets spreadsheets as rows
- Add new Ecwid by Lightspeed pickup orders to Google Sheets rows automatically
- Add new Ecwid by Lightspeed customers to a Google Sheets spreadsheet as rows
- Create spreadsheets in Google Sheets for new products in Ecwid by Lightspeed
- Add new Ecwid by Lightspeed shipping orders to Google Sheets rows
- Add new Ecwid by Lightspeed products to Google Sheets as multiple rows
- Copy new Ecwid by Lightspeed orders to Google Sheets worksheets instantly
- Create multiple spreadsheet rows in Google Sheets for new abandoned carts in Ecwid by Lightspeed
- Track new abandoned carts in Ecwid by Lightspeed by creating rows in Google Sheets
- Update Google Sheets rows with new orders from Ecwid by Lightspeed
- Create multiple rows in Google Sheets for new pickup orders from Ecwid by Lightspeed
- Track new abandoned carts in Ecwid by Lightspeed with custom actions in Google Sheets
- Create new Ecwid by Lightspeed products from new Google Sheets rows
- Create worksheets in Google Sheets for new paid orders in Ecwid by Lightspeed
- Manage new orders in Ecwid by Lightspeed by initiating custom actions in Google Sheets
- Create worksheets in Google Sheets for new orders in Ecwid by Lightspeed
- Create new Ecwid by Lightspeed orders from new Google Sheets rows
- Copy worksheets in Google Sheets for new paid orders in Ecwid by Lightspeed
- Clear spreadsheet rows in Google Sheets when new orders are placed in Ecwid by Lightspeed
- Create new Ecwid by Lightspeed orders from new or updated Google Sheets rows
- Create multiple rows in Google Sheets for new customers from Ecwid by Lightspeed
- Create worksheets in Google Sheets for new orders in Ecwid by Lightspeed
Related Zap Templates
- Save new Ecwid orders to Google Sheets rows
- Create Google Sheets rows for new paid orders in Ecwid
- Add new products from Ecwid by Lightspeed to Google Sheets rows
- Create products in Ecwid by Lightspeed from new or updated Google Sheets rows
- Add new Ecwid by Lightspeed orders to Google Sheets spreadsheets as rows
- Create spreadsheets in Google Sheets for new products in Ecwid by Lightspeed
- Copy new Ecwid by Lightspeed orders to Google Sheets worksheets instantly
- Update Google Sheets rows with new orders from Ecwid by Lightspeed
- Create new Ecwid by Lightspeed products from new Google Sheets rows
- Create worksheets in Google Sheets for new orders in Ecwid by Lightspeed
- Clear spreadsheet rows in Google Sheets when new orders are placed in Ecwid by Lightspeed
- Create worksheets in Google Sheets for new orders in Ecwid by Lightspeed
- Add line items from new Ecwid paid orders to Google Sheets as multiple rows
- Create Google Sheet row(s) for new paid orders in Ecwid
- Create columns in Google Sheets for new Ecwid by Lightspeed orders
- Update Ecwid by Lightspeed products when new or updated Google Sheets spreadsheet rows are detected
- Add new Ecwid by Lightspeed pickup orders to Google Sheets rows automatically
- Add new Ecwid by Lightspeed shipping orders to Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new abandoned carts in Ecwid by Lightspeed
- Create multiple rows in Google Sheets for new pickup orders from Ecwid by Lightspeed
- Create worksheets in Google Sheets for new paid orders in Ecwid by Lightspeed
- Create new Ecwid by Lightspeed orders from new Google Sheets rows
- Create new Ecwid by Lightspeed orders from new or updated Google Sheets rows
- Create Google Sheet rows for new orders in Ecwid
- Create Google Sheets spreadsheet rows from new Ecwid orders
- Update Ecwid by Lightspeed products from new or updated Google Sheets rows
- Add new Ecwid by Lightspeed products to Google Sheets rows for easy updates
- Add new Ecwid by Lightspeed customers to a Google Sheets spreadsheet as rows
- Add new Ecwid by Lightspeed products to Google Sheets as multiple rows
- Track new abandoned carts in Ecwid by Lightspeed by creating rows in Google Sheets
- Track new abandoned carts in Ecwid by Lightspeed with custom actions in Google Sheets
- Manage new orders in Ecwid by Lightspeed by initiating custom actions in Google Sheets
- Copy worksheets in Google Sheets for new paid orders in Ecwid by Lightspeed
- Create multiple rows in Google Sheets for new customers from Ecwid by Lightspeed