Watch Step By Step Video Tutorial Below
1. Introduction to the Integration
This integration connects You Can Book Me with Google Sheets. You Can Book Me is a scheduling tool, while Google Sheets is an online spreadsheet application.
When a booking is cancelled in You Can Book Me, this integration automatically records the details in Google Sheets. This seamless data transfer is essential for efficient management.
2. Setting Up Pabbly Connect
To start, visit the Pabbly Connect website and sign in to your account. If you don’t have an account, you can create one quickly.
Once logged in, click on “Connect” and select “Create Workflow” to initiate the integration process. Name your workflow something descriptive, like “You Can Book Me to Google Sheets”.
3. Configuring the Trigger
In the trigger window, change the app from Webhook to You Can Book Me. For the trigger event, select “Cancelled Booking” to capture data when bookings are cancelled.
Next, go to You Can Book Me and access the notifications settings. Here, set up a webhook to send data to Pabbly Connect whenever a booking is cancelled.
4. Capturing Data from You Can Book Me
After configuring the webhook, return to Pabbly Connect and click on “Capture Webhook Response”. This action prepares the system to receive data.
Now, cancel a booking in You Can Book Me to test the setup. As the booking is cancelled, you should see the data captured in Pabbly Connect reflecting the customer’s details.
5. Syncing Data to Google Sheets
To sync the captured data to Google Sheets, click on the plus button in Pabbly Connect to add an action. Choose Google Sheets as your app and select the “Add New Row” method.
Map the data fields from You Can Book Me to the corresponding columns in Google Sheets. This step ensures that information like name and email are recorded correctly in adjacent rows.
Conclusion
This integration allows you to automatically capture cancelled bookings from You Can Book Me into Google Sheets using Pabbly Connect, enhancing your data management efficiency.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!
- Know more about Pabbly Connect – Automate workflows effortlessly!