Google Sheets + Loyverse + Looping by Zapier
Add new shifts created in Loyverse to Google Sheets rows
Store and manage shift data effortlessly. This integration automatically adds a new shift created in Loyverse to a row in a specified Google Sheets spreadsheet for efficient analysis.
Store and manage shift data effortlessly. This integration automatically adds a new shift created in Loyverse to a row in a specified Google Sheets spreadsheet for efficient analysis.
- When this happens...
Shifts CreateTriggers when a shift is created and synced to the Back Office.
TriggerInstantThis event starts a Zap instantly. - automatically do this...Get List of Receipts
Get list of receipts
ActionSearchFind existing data in your app - then do this...
Create Loop From Line ItemsCreates a new Loop from line item(s). This is an advanced action!
ActionWriteCreate a new record or update an existing record in your app. - then do this...Get Single Customer
Get Single Customer
ActionSearchFind existing data in your app - then 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
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 appHelp Warning
Loop iteration counter start
Loop iteration counter end
Loop iteration counter increment amount
Maximum number of Loop iterations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
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 appHelp Warning
Values to LoopRequired
Trim Whitespace
Loop iteration counter start
Maximum number of Loop iterations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Help Warning
Values to LoopRequired
Text Delimiter
Trim Whitespace
Loop iteration counter start
Maximum number of Loop iterations
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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 found
About Google Sheets
Related categories
About Loyverse
Related categories
