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...

New Calendar EventTriggers when a calendar event is 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
New BookingTriggers when a booking is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event CancelledTriggers when a calendar event is cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Calendar EventTriggers when a calendar event is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New ContactTriggers when a contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New InvoiceTriggers when an invoice is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New MemberTriggers when a member is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New PaymentTriggers when a payment is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated PaymentTriggers when a payment is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated UnitTriggers when a product is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated SiteTriggers when a site is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New TaskTriggers when a task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New WidgetTriggers when a widget is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Calendar EventRequired
- Status
- Title
- Notes
- Start date
- End date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- First name
- Last name
- Email
- Phone
- Language
- Company name
- Street
- Street2
- Zip
- City
- Province
- State
- Country
- Notes
- Sms opt in
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.- EmailRequired
- Name
- Language
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Calendar eventRequired
- LabelRequired
- Due at
- Schedule
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Email
- Phone
- Name
ActionThis is an event a Zap performs.SearchFind existing data in your app- Email
- Phone
- Name
- First name
- Last name
- Language
- Company name
- Street
- Street2
- Zip
- City
- Province
- State
- Country
- Notes
- Sms opt in
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- 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- 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
- Overwrite All Columns
- 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
- Spreadsheet NameRequired
- Search Type
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
- 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
Updated BookingTriggers when a booking is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Calendar Event ConfirmedTriggers when a calendar event is confirmed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated Calendar EventTriggers when a calendar event is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated ContactTriggers when a contact is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated InvoiceTriggers when an invoice is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated MemberTriggers when a member is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Payment PaidTriggers when a payment is paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New UnitTriggers when a product is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New SiteTriggers when a site is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Task CompletedTriggers when a task is completed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated TaskTriggers when a task is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
Updated WidgetTriggers when a widget is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Calendar eventRequired
- NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ContactRequired
- First name
- Last name
- Email
- Phone
- Language
- Company name
- Street
- Street2
- Zip
- City
- Province
- State
- Country
- Notes
- Sms opt in
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- UnitRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- MemberRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TaskRequired
- Label
- Due at
- Schedule
- Completed at
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Booking
- Product
- Start date
ActionThis is an event a Zap performs.SearchFind existing data in your app- Reference
- Booking
ActionThis is an event a Zap performs.SearchFind existing data 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
- 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
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data 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
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- 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- 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




