Ecwid by Lightspeed + Google Sheets

Add new Ecwid by Lightspeed orders to Google Sheets spreadsheets as rows

Stay on top of your Ecwid by Lightspeed orders by automatically adding them to Google Sheets. With this automation, each time a new order is placed in your Ecwid by Lightspeed store, a new row will be created in your specified Google Sheets. Manage and analyze your sales data with ease, ensuring you always have the latest information at your fingertips.

When this happens...
New Order
Triggered when a new invoice is placed (with line item support).
TriggerScheduled
automatically do this!
Create Spreadsheet
Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Abandoned Cart
Triggered when a customer leaves an online store without making a purchase.
Trigger
Scheduled
Try It
- Payment Status
- Fulfillment Status
Trigger
Scheduled
Try It
- Payment Status
- Fulfillment Status
Trigger
Scheduled
Try It
- Payment Status
- Fulfillment Status
Trigger
Scheduled
Try It
- Coupon NameRequired
- Coupon CodeRequired
- Discount
- Discount Type
- Status
- Launch Date
- Expiration Date
- Total Limit
- Uses Limit
- applicationLimit
- Order Count
- repeatCustomerOnly
- catalogLimitProducts
- catalogLimitCategories
Action
Write

- TitleRequired
- PriceRequired
- SKU Number
- Description
- Quantity
- Weight
- Enabled
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Write
- Product IDRequired
- Link on your imageRequired
Action
Write

- 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
Action
Search
- Keyword
- 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
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

- Customer Email
- Agreed to receive email marketing
Trigger
Scheduled
Try It
New Paid Order
Triggered when a new paid order is placed (with line item support).
Trigger
Scheduled
Try It
New Product
Triggers when a new product is created.
Trigger
Scheduled
Try It
- Customer's EmailRequired
- Customer's Password
- Customer group ID
- Customer's Name
Action
Write
- 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
Action
Write
- Product IDRequired
- SKU
- Name
- Quantity
- Unlimited
- Price
- Compare To Price
- Weight
- Enabled
- Description
Action
Write
- 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
Action
Search
- Keyword
- SKU
- Product ID
- Enabled
Action
Search
- Keyword
- SKU Number
- Product ID
- Enabled
- TitleRequired
- PriceRequired
- Description
- Quantity
- Weight
- Unlimited
- Compare To Price
- Is Shipping Required
- Warning Limit
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

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.

Learn more

Related categories

eCommerce

Similar apps

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Ecwid by Lightspeed + Google Sheets

Add new Ecwid by Lightspeed orders to Google Sheets spreadsheets as rows

New Abandoned Cart

New Order

Payment Status

Fulfillment Status

New Pickup Order

Payment Status

Fulfillment Status

New Shipping Order

Payment Status

Fulfillment Status

Create Discount Coupon

Discount

Discount Type

Status

Launch Date

Expiration Date

Total Limit

Uses Limit

applicationLimit

Order Count

repeatCustomerOnly

catalogLimitProducts

catalogLimitCategories

Create Product

SKU Number

Description

Quantity

Weight

Enabled

Unlimited

Compare To Price

Is Shipping Required

Warning Limit

Upload Main Image

Find Order

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

Find or Create Customer

Keyword

Customer's Name

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

New Spreadsheet Row (Team Drive)

Drive

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

Trigger Column

Create Spreadsheet Column

Drive

Index

Create Multiple Spreadsheet Rows