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.