Ecwid by Lightspeed + Google Sheets
Create new Google Sheets rows for new Ecwid by Lightspeed orders
Efficiently manage your Ecwid by Lightspeed orders with this workflow. As soon as a new order is placed in your Ecwid by Lightspeed store, relevant data will be updated in your Google Sheets at the top row. This dynamic process not only makes order tracking effortless but also gives you an immediate view of your sales data, eliminating manual updates and data entry. Enjoy a more streamlined approach to order management and improve your efficiency.
Efficiently manage your Ecwid by Lightspeed orders with this workflow. As soon as a new order is placed in your Ecwid by Lightspeed store, relevant data will be updated in your Google Sheets at the top row. This dynamic process not only makes order tracking effortless but also gives you an immediate view of your sales data, eliminating manual updates and data entry. Enjoy a more streamlined approach to order management and improve your efficiency.
- When this happens...
New OrderTriggered when a new invoice is placed (with line item support).
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet Row at TopCreates a new spreadsheet row at the top of a spreadsheet (after the header row).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Abandoned Cart
Triggered when a customer leaves an online store without making a purchase.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPayment Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPayment Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPayment Status
Fulfillment Status
Try ItTriggerThis is the start of your ZapPollingZapier 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 foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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
Row(s)Required
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)Required
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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.Stop on errorRequired
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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
Customer Email
Agreed to receive email marketing
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
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
- Add new products from Ecwid by Lightspeed to Google Sheets rows
- 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
- 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
- Create new Ecwid by Lightspeed customers from new or updated rows in Google Sheets team drive
- Update Google Sheets rows with new orders from Ecwid by Lightspeed
- Create multiple rows in Google Sheets for new orders in Ecwid by Lightspeed
- Create spreadsheet columns in Google Sheets for new shipping orders in Ecwid by Lightspeed
Related Zap Templates
- Save new Ecwid orders to Google Sheets rows
- Add new products from Ecwid by Lightspeed to Google Sheets rows
- Create Google Sheets spreadsheet rows from new Ecwid orders
- 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
- Create multiple rows 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 Sheets rows 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 new Ecwid by Lightspeed customers from new or updated rows in Google Sheets team drive
- Create spreadsheet columns in Google Sheets for new shipping orders in Ecwid by Lightspeed
- Create Google Sheet rows for new orders in Ecwid
- Create Google Sheet row(s) for new paid orders in Ecwid
- 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
- Update Google Sheets rows with new orders from Ecwid by Lightspeed