Google Sheets + Lightspeed Retail POS (X-Series)
Save new Lightspeed Retail POS (X-Series) sales to Google Sheets rows
How great would it be to never copy and paste order info into a spreadsheet again? Use this Zapier integration and find out! It automatically copies each new Lightspeed Retail POS (X-Series) sale into a rows in a specified Google Sheets spreadsheet.
How great would it be to never copy and paste order info into a spreadsheet again? Use this Zapier integration and find out! It automatically copies each new Lightspeed Retail POS (X-Series) sale into a rows in a specified Google Sheets spreadsheet.
- When this happens...
New SaleTriggers when a new sale is created (with line item support).
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
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 Awaiting Dispatch Sale
Triggers when a sale is awaiting shipping (with line item support). Typically a sale received from e-commerce.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Customer
Triggers when a customer is added.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Received Consignment
Triggers when a consignment is received.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Customer
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Outlet
Triggers when an outlet is created or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Register Closure
Triggers when a register is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StatusRequired
User IDRequired
Source
Source ID
Register ID
Customer ID
Sale Date
Note
Short Code
Invoice Number
Account Transaction ID
ID
Product IDRequired
Register ID
Sequence
QuantityRequired
PriceRequired
Cost
TaxRequired
Tax IDRequired
ID
Register ID
Payment Type ID
Payment Date
Amount
Register Sale Attributes
Type
Tax ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SKU
Supplier ID
Brand ID
Tag ID
Product Type ID
Variant Parent ID
Exclude Values
Exclude: Supplier ID
Exclude: Brand ID
Exclude: Tag ID
Exclude: Product Type ID
Exclude: Variant Parent ID
Order By
Order Direction
Page Size
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Code
Email
First Name
Last Name
Company Name
Mobile
Phone
Find Deleted
Order By
Order Direction
Page Size
First NameRequired
Last NameRequired
Customer Code
Customer Group ID
Enable Loyalty
Email
Note
Gender
Date of Birth
Company Name
Do Not Email
Phone
Mobile
Fax
Twitter
Website
Physical Address 1
Physical Address 2
Physical Suburb
Physical City
Physical Postcode
Physical State
Physical Country ID
Postal Address 1
Postal Address 2
Postal Suburb
Postal City
Postal Postcode
Postal State
Postal Country ID
Custom Field 1
Custom Field 2
Custom Field 3
Custom Field 4
On Account 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 foundStatus
Date From
Date To
Invoice Number
Customer ID
User ID
Outlet ID
Order By
Order Direction
Page Size
StatusRequired
User IDRequired
Source
Source ID
Register ID
Customer ID
Sale Date
Note
Short Code
Invoice Number
Account Transaction ID
ID
Product IDRequired
Register ID
Sequence
QuantityRequired
PriceRequired
Cost
TaxRequired
Tax IDRequired
ID
Register ID
Payment Type ID
Payment Date
Amount
Register Sale Attributes
Type
Tax 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 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
New Awaiting Pickup Sale
Triggers when a sale is awaiting pickup (with line item support). Typically a sale received from e-commerce.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Register Closure
Triggers when a register is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Voided Sale
Triggers when a sale is cancelled (with line item support).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Sent Consignment
Triggers when a consignment is sent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Inventory
Triggers when a product’s inventory is updated. If a product does not use inventory tracking, this trigger won’t fire.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New or Updated Product
Triggers when a product is created or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.First NameRequired
Last NameRequired
Customer Code
Customer Group ID
Enable Loyalty
Email
Note
Gender
Date of Birth
Company Name
Do Not Email
Phone
Mobile
Fax
Twitter
Website
Physical Address 1
Physical Address 2
Physical Suburb
Physical City
Physical Postcode
Physical State
Physical Country ID
Postal Address 1
Postal Address 2
Postal Suburb
Postal City
Postal Postcode
Postal State
Postal Country ID
Custom Field 1
Custom Field 2
Custom Field 3
Custom Field 4
On Account Limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Handle
SKU
Type
Code
Source
Source ID
Source Variant ID
Active
Price Including Tax
Price Excluding Tax
Supply Price
Supply ID
Supplier Code
Supplier ID
Price
Code
Product Type ID
Product Category ID
Brand ID
Tag IDs
Attributes: Key
Attributes: Value
Type
Location
Current Amount
Outlet ID
Reorder Amount
Reorder Point
Account Code Sale
Account Code Purchase
Loyalty Amount
Weight
Weight Unit
Length
Width
Height
Dimensions Unit
Current Amount
Outlet ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Code
Email
First Name
Last Name
Company Name
Mobile
Phone
Find Deleted
Order By
Order Direction
Page Size
ActionThis is an event a Zap performs.SearchFind existing data in your appStatus
Date From
Date To
Invoice Number
Customer ID
User ID
Outlet ID
Order By
Order Direction
Page Size
ActionThis is an event a Zap performs.SearchFind existing data in your appSKU
Supplier ID
Brand ID
Tag ID
Product Type ID
Variant Parent ID
Exclude Values
Exclude: Supplier ID
Exclude: Brand ID
Exclude: Tag ID
Exclude: Product Type ID
Exclude: Variant Parent ID
Order By
Order Direction
Page Size
NameRequired
Description
Handle
SKU
Type
Code
Source
Source ID
Source Variant ID
Active
Price Including Tax
Price Excluding Tax
Supply Price
Supply ID
Supplier Code
Supplier ID
Price
Code
Product Type ID
Product Category ID
Brand ID
Tag IDs
Attributes: Key
Attributes: Value
Type
Location
Current Amount
Outlet ID
Reorder Amount
Reorder Point
Account Code Sale
Account Code Purchase
Loyalty Amount
Weight
Weight Unit
Length
Width
Height
Dimensions Unit
Current Amount
Outlet 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
About Google Sheets
Related categories
About Lightspeed Retail POS (X-Series)
Related categories
Related Zap Templates
- Create spreadsheets in Google Sheets from new sent consignments in Lightspeed Retail POS (X-Series)
- Create spreadsheet rows in Google Sheets for new customers from Lightspeed Retail POS (X-Series)
- Manage new awaiting dispatch sales in Lightspeed Retail POS (X-Series) by creating multiple spreadsheet rows in Google Sheets