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.
- When this happens...

Calendar Event CreatedTriggers when a calendar event was created.TriggerInstant - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Bookingmood and Google Sheets
Discover other triggers and actions you can use with Bookingmood and Google Sheets
Booking CreatedTriggers when a booking was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event CancelledTriggers when a calendar event was cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event CreatedTriggers when a calendar event was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event Task CompletedTriggers when a calendar event task was completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event Task UpdatedTriggers when a calendar event task was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Contact UpdatedTriggers when a contact was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Invoice UpdatedTriggers when an invoice was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Member UpdatedTriggers when a member was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Payment PaidTriggers when a payment was paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Product CreatedTriggers when a product was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Site CreatedTriggers when a site was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Widget CreatedTriggers 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.- 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 plan- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found
Booking UpdatedTriggers when a booking was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event ConfirmedTriggers when a calendar event was confirmed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event UpdatedTriggers when a calendar event was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event Task CreatedTriggers when a calendar event task was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Contact CreatedTriggers when a contact was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Invoice CreatedTriggers when an invoice was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Member CreatedTriggers when a member was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Payment CreatedTriggers when a payment was created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Payment UpdatedTriggers when a payment was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Product UpdatedTriggers when a product was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Site UpdatedTriggers when a site was updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Widget UpdatedTriggers 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.- 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 plan- Dont_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.- Api_docs_info
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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




