Google Sheets + Loyverse
Create or update Loyverse customers with new or updated rows in Google Sheets
This workflow activates whenever there's a new or updated row in your Google Sheets. It then swiftly creates or updates a single customer in the Loyverse platform. Great for those who need to manage customer info between Sheets and Loyverse, this automation ensures you never miss out on important customer updates, saving you time and boosting efficiency.
This workflow activates whenever there's a new or updated row in your Google Sheets. It then swiftly creates or updates a single customer in the Loyverse platform. Great for those who need to manage customer info between Sheets and Loyverse, this automation ensures you never miss out on important customer updates, saving you time and boosting efficiency.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create or Update Single CustomerCreates or Updates a Single 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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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 found
Inventory Update
Triggers when a stock updates.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Receipts Update
Triggers when a receipt gets created or updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Item ID
Item NameRequired
Reference ID
Category ID
Description
Track Stock
Sold by Weight
Primary Supplier ID
Tax ID
Form
Colors
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Receipt NumberRequired
Receipt Date
Source
Employee ID
Store ID
IDRequired
QuantityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer ID
NameRequired
Email
Phone Number
Address
City
Region
Postal Code
Country Code
Customer Code
Note
Total Points
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
NameRequired
Position
Stores
Modifier Options ID
Modifier Options NameRequired
PriceRequired
Modifier Options PositionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
NameRequired
Contact
Email
Phone Number
Website
Address 1
Address 2
City
Region
Postal Code
Country Code
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Discount IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.POS Device IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Supplier IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Variant IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Store ID
Show Deleted
ActionThis is an event a Zap performs.SearchFind existing data in your appCategories ID
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee IDs
Created At Minimum
Created At Maximum
Updated At Minimum
Updated At Maximum
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appModifier IDs
Created At Minimum
Created At Maximum
Updated At Minimum
Updated At Maximum
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appItem ID
Created At Min
Created At Max
Updated At Min
Updated At Max
limit [1...250]
cursor
Show Deleted
ActionThis is an event a Zap performs.SearchFind existing data in your appReceipt Number
Since Receipt Number
Before Receipt Number
Store Id
Order
Source
Update at min
Update At Max
Create At Min
Created At Max
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appCreated at Minimum
Created at Maximum
Updated at Minimum
Updated at Maximum
Show Deleted
Store ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSupplier IDs
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appstore
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appEmployee IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appModifier IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appReceipt NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStore IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTax IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
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
Headers
Overwrite existing worksheets
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
Text Bold
Text Italic
Text 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
Headers
Overwrite existing worksheets
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 Update
Triggers when a customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Items Update
Triggers when an item is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Shifts Create
Triggers when a shift is created and synced to the Back Office.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Store IDRequired
Receipt Date
Order
Customer ID
Source
Discounts ID
percentage
Money Amount
Scope
Variant ID
Quantity
Price
Cost
Payment ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category ID
NameRequired
Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
TypeRequired
NameRequired
Discount Amount
Discount Percent
Stores
Restricted Access
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
NameRequired
Store IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Type
NameRequired
RateRequired
Stores
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Modifier IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tax IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Variant IDRequired
Store IDRequired
Stock AfterRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.POS Device IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCreated at Minimum
Created at Maximum
Updated at Minimum
Updated at Maximum
ActionThis is an event a Zap performs.SearchFind existing data in your appStore IDs
Variant IDs
Update At Minimum
Updated At Maximum
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appemail
Created at Minimum
Created at Maximum
Updated at Minimum
Updated at Maximum
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appCreated at Minimum
Created at Maximum
Updated at Minimum
Updated at Maximum
Show Deleted
ActionThis is an event a Zap performs.SearchFind existing data in your appStore ID
Created at Minimum
Created at Maximum
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appCreated at Minimum
Created at Maximum
Updated at Minimum
Updated at Maximum
Show Deleted
ActionThis is an event a Zap performs.SearchFind existing data in your appVariant IDs
Item IDs
SKU
Created At Minimum
Created At Maximum
Updated At Minimum
Updated At Maximum
Limit
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appCategory IDRequired
Name
Color
Created At
Deleted At
ActionThis is an event a Zap performs.SearchFind existing data in your appDiscount IDRequired
Type
Name
Discount Amount
Discount Percent
Stores
Created At
Updated At
ActionThis is an event a Zap performs.SearchFind existing data in your appItem IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPayment Type IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appShift IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSupplier IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appVariant IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Loyverse
Free Point of Sale and Inventory Management Software. Turn your smartphone or tablet into a powerful POS. Manage sales, inventory and employees with ease.
Related categories
Related Zap Templates
- Update Google Sheets rows when new Loyverse receipts are created
- Update Google Sheets rows with new Loyverse receipts updates
- Create Google Sheets rows for updated Loyverse receipts
- Update Google Sheets rows with updated Loyverse inventory data
- Manage updated Loyverse customers by creating multiple rows in Google Sheets