Keep Bookingmood guest details current from new inquiry rows
New inquiry details can reach the right Bookingmood record without copying them by hand.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Update Booking Details
Tool to update existing booking detail records. use when modifying guest-filled form fields for bookings matching specific filters.
Why this helps
Copying guest information between a spreadsheet and a booking record creates extra context switching and makes details easy to miss.
- Reduce repeated entry when new inquiry rows arrive.
- Ask Notis to identify the matching booking before updating details.
- Keep the workflow centered on the spreadsheet where inquiries are collected.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Bookingmood once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3Tell Notis to use each new inquiry row to find the matching Bookingmood booking and update its guest-filled details.
- 4Choose New Rows in Google Sheet as the trigger, then select where run reports go.
- 5Test with one real inquiry row and confirm the intended booking details changed.
Questions about this workflow
What starts this automation?
A new row detected in the Google Sheet you select.
Does it create a booking?
No. This workflow uses Bookingmood's Update Booking Details action to update existing booking detail records matching the information Notis can identify.
What if the row does not identify a booking clearly?
Include a reliable matching clue in the row and tell Notis how to use it. Test with a real example before relying on the workflow.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Bookingmood. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Bookingmood actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Booking Widget
Tool to create a new booking widget. use after preparing widget parameters.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Booking Details
Tool to delete booking details matching given filters. use after confirming which booking detail records to remove.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
List Organizations
Tool to list organizations. use when you need to retrieve all organizations accessible by the current api key.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
List Booking Widgets
Tool to list booking widgets. use when you need to fetch available widget configurations.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Deprecated: Search availability
Deprecated: replaced by search availability.py
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Update Booking Details
Tool to update existing booking detail records. use when modifying guest-filled form fields for bookings matching specific filters.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Connect any two apps with Notis in the middle.
Google Sheets and Bookingmood, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Bookingmood.