Bookingmood + Google Sheets
Log new Bookingmood events in Google Sheets rows
Once this template is active, each new event created in Bookingmood will be logged in a chosen Google Sheets spreadsheet.
Once this template is active, each new event created in Bookingmood will be logged in a chosen Google Sheets spreadsheet.
- When this happens...
Calendar Event CreatedTriggers when a calendar event was created.
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
Booking Created
Triggers when a booking was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Cancelled
Triggers when a calendar event was cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Created
Triggers when a calendar event was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Task Completed
Triggers when a calendar event task was completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Task Updated
Triggers when a calendar event task was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Updated
Triggers when a contact was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Updated
Triggers when an invoice was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Updated
Triggers when a member was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Paid
Triggers when a payment was paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Created
Triggers when a product was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Site Created
Triggers when a site was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Widget Created
Triggers when a widget was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Name
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Currency
Display currency
Exchange rate
Method
Confirmed at
Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Notes
Type
Title
Status
Origin
Booking
Start date
End date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Calendar event
Completed at
Label
Due at
Schedule
Assignee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact
Booking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Coupon
Product
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Rent PeriodRequired
TimezoneRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Name
Ical url
Last synced
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reference
Booking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Line item
Tax
Amount
Percentage
Type
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Accumulator
Element
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member
Product
Permission
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Min duration
Max duration
Color
Min advance
Max advance
Cooldown time
Product
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Occupancy group
Min
Max
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Service
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Type
Label
Description
Parent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Discount percentageRequired
Service
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Service
Tax
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
Parent
Site page
Label
Url
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Percentage
Label
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Widget
Product
Url
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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 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
Booking Updated
Triggers when a booking was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Confirmed
Triggers when a calendar event was confirmed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Updated
Triggers when a calendar event was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Calendar Event Task Created
Triggers when a calendar event task was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Created
Triggers when a contact was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Created
Triggers when an invoice was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Member Created
Triggers when a member was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Created
Triggers when a payment was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Updated
Triggers when a payment was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Updated
Triggers when a product was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Site Updated
Triggers when a site was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Widget Updated
Triggers when a widget was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Attribute
Order
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Value
Booking
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Calendar event
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Avatar
Email
Phone
Language
First name
Last name
Street
Street2
Zip
City
Province
State
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Code
Description
Quota
Discount PercentageRequired
Scope
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Coupon
Service
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Trigger
Subject
Body
Include booking details
Include booking link
Include ical data
Include product image
Point around which to send the emailRequired
OffsetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Booking
Amount
Quantity
Item type
Fee type
Invoice
Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Description
Order
Type
Name singular
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Amount
Currency
Booking
Due at
Invoice
Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Option
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Email template
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Reply to address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product
Anchor point around which to schedule the taskRequired
OffsetRequired
Label
Assignee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Service
AmountRequired
Anchor point around which to schedule the depositRequired
OffsetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Service
AmountRequired
Anchor point around which to schedule the depositRequired
OffsetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
Product
Featured
Slug
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site
Status
Slug
Content
Title
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title
Type
Locale
Show bookingmood branding
Stay expanded
Font
Show tentative as
Show past
Redirect url
Currency
Date visibility
Initial date
Interaction
Autocomplete date selection
Settings
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
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 Bookingmood
Related categories
