Ecwid by Lightspeed + Google Sheets
Add line items from new Ecwid paid orders to Google Sheets as multiple rows
Send your new paid orders from your eCommerce tool to a spreadsheet, where you can sort and analyze them. Use this Zap to automatically send line items from new paid Ecwid orders to Google Sheets--without squeezing the line items into a single, messy spreadsheet row. Instead, this Zap will create multiple Google Sheets rows, one for each line item. That way, you can get to work analyzing your data without manually editing your spreadsheet.
Send your new paid orders from your eCommerce tool to a spreadsheet, where you can sort and analyze them. Use this Zap to automatically send line items from new paid Ecwid orders to Google Sheets--without squeezing the line items into a single, messy spreadsheet row. Instead, this Zap will create multiple Google Sheets rows, one for each line item. That way, you can get to work analyzing your data without manually editing your spreadsheet.
- When this happens...
New Paid OrderTriggered when a new paid order is placed (with line item support).
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
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 foundDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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 foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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
- 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
- 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
- Create new Google Sheets rows for new Ecwid by Lightspeed orders
- Create new Google Sheets rows at top for new paid orders in Ecwid by Lightspeed
Related Zap Templates
- Save new Ecwid orders to Google Sheets 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 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 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
- Update Google Sheets rows with new orders from Ecwid by Lightspeed
- Create new Google Sheets rows for new Ecwid by Lightspeed orders
- 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
- Create multiple rows in Google Sheets for new orders in Ecwid by Lightspeed
- Create new Google Sheets rows at top for new paid orders in Ecwid by Lightspeed