Google Sheets + Loyverse
Create or update Loyverse customers from new rows in Google Sheets
Manage your customer information efficiently with this workflow. When a new row is added to your Google Sheets, the corresponding customer details will be created or updated in Loyverse. This automation streamlines the process, ensuring that each piece of data from your spreadsheet directly populates in Loyverse, saving time and reducing potential errors. Keep your customer records organized and up-to-date with ease.
Manage your customer information efficiently with this workflow. When a new row is added to your Google Sheets, the corresponding customer details will be created or updated in Loyverse. This automation streamlines the process, ensuring that each piece of data from your spreadsheet directly populates in Loyverse, saving time and reducing potential errors. Keep your customer records organized and up-to-date with ease.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of 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
Dont 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 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
Dont 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 foundInventory 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
About Google Sheets
Related categories
About Loyverse
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
- Add new shifts created in Loyverse to Google Sheets rows
- Update Google Sheets rows with updated Loyverse inventory data
- Create or update Loyverse customers with new or updated rows in Google Sheets
- Manage updated Loyverse customers by creating multiple rows in Google Sheets
- Update Google Sheets spreadsheets when receipts update in Loyverse
- Create multiple rows in Google Sheets for new shifts created in Loyverse
- Manage updated Loyverse items by creating spreadsheet rows in Google Sheets
- Create spreadsheet rows in Google Sheets for updated inventory in Loyverse
- Create or update Loyverse categories from new or updated rows in Google Sheets
- Create spreadsheet columns in Google Sheets from updated inventories in Loyverse
- Update Google Sheets rows each time Loyverse receipts get updated
- Update Google Sheets rows when items update in Loyverse
- Update Google Sheets rows with each Loyverse customer update
- Create new Google Sheets rows from newly created shifts in Loyverse
Related Zap Templates
- Update Google Sheets rows when new Loyverse receipts are created
- Add new shifts created in Loyverse to Google Sheets rows
- Manage updated Loyverse customers by creating multiple rows in Google Sheets
- Manage updated Loyverse items by creating spreadsheet rows in Google Sheets
- Create spreadsheet columns in Google Sheets from updated inventories in Loyverse
- Update Google Sheets rows with new Loyverse receipts updates
- Update Google Sheets rows with updated Loyverse inventory data
- Update Google Sheets spreadsheets when receipts update in Loyverse
- Create spreadsheet rows in Google Sheets for updated inventory in Loyverse
- Update Google Sheets rows each time Loyverse receipts get updated
- Create Google Sheets rows for updated Loyverse receipts
- Create or update Loyverse customers with new or updated rows in Google Sheets
- Create multiple rows in Google Sheets for new shifts created in Loyverse
- Create or update Loyverse categories from new or updated rows in Google Sheets
- Update Google Sheets rows when items update in Loyverse