Want to know a way to add Google Sheets row for cancelled YouCanBook.me bookings? If yes, then here in this blog we will integrate YouCanBook.me and Google Sheet using Pabbly Connect.
But let’s first put light on why there is a need for YouCanBook.me and Google Sheet integration. We all know that it is an online scheduling tool that removes all manual work of sending emails individually. But what if you want to create a spreadsheet of all the bookings including cancelled ones.
Believe us, it is a lot of work, filling every detail manually can drive us crazy. This is why we are recommending a business automation tool named Pabbly Connect.
Why Choose This Method Of Integration?
In contrast with other integration services-
- Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
- Create “Unlimited Workflows” and smoothly define multiple tasks for each action
- As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
- Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
- Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE
Pabbly Connect simplifies boring or recurring activity by creating seamless workflows. Plus, you don’t need any technical knowledge to use the application.
Within 5 minutes, Pabbly Connect is ready to rule, without any installation setup. It lets you obtain cancelled YouCanBook.me bookings and send the results to Google Sheets in real-time. Is this not fantastic?
Yeah, it is, plus the software is loaded with options like unlimited workflow, action, triggers, etc to smooth the whole data transfer process. Even in its free plan, it provides features such as path-routers, instant triggers, and many more.
Here, in this article, we will learn how to add Google Sheets row for cancelled YouCanBook.me bookings in real-time.
So, let’s headstart the process.
Step 1: Sign up to Pabbly Connect
Begin the process of connecting Google Sheet to YouCanBook.me by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Subsequently, either fill-up the details manually or sign up using Gmail credentials.
Try Pabbly Connect for FREE
Further, after logging into the account, click on the “Access Now” button as shown in the above image. Start the process of building a workflow for integration by clicking on the “Create New Workflow” button. Moreover, add the name of workflow which in our case is “YouCanBook.me to Google Sheet”. Nevertheless, you can always name the workflow according to your requirements. Next, after building a workflow, you have to choose the integration app to collect your YouCanBook.me cancelled entries. Pabbly Connect allows you to build unlimited workflows within minutes, click here to sign up for unlimited workflows for free. The following step is to select “YouCanBook.me” from the dropdown, then choose the “Cancelled Booking” option to add the data from the software into Google Sheets. The next step is to copy the webhook URL which is appearing on the dashboard. To save cancelled bookings from YouCanBook.me into Google Sheet, you need to paste the copied Webhook URL in the software. Hence to do that, just log in to your YouCanBook.Me account. Either create or new booking page or select an existing booking page. Then click on the “Edit” option. When you click on the”Edit” option, it will open up different options, just click on “Notifications”. Since we are making this workflow for cancelled booking, so we will pick “If Booking Cancelled” option. The next step is to tap on the “+” icon so that you can paste the copied URL. Now, you have to select the action type, as we are saving all the cancelled bookings in Google Sheet so we are going to choose “Webhook” option. Just paste the copied Webhook from Pabbly Connect in the URL section and select the HTTP method as “Post”. After making sure of this, hit The “Save Changes” button. Now go to live booking page and make dummy entry. After filling all the details hit the “Confirm Booking” button. Next, head back to booking section, all the entries will appear there. Then to cancel a booking, click on “Details” and select “Cancel”. But before hitting the “Cancel” option, make sure to click on “Capture Webhook Response” in the Pabbly Connect dashboard. As soon as you cancel the booking, the details will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option. To make this YouCanBook.me – Google Sheet integration work, you have to choose the action for your trigger. Next, click on the “+” icon then select “Google Sheet” and in the choose method option, select ” Add New Row”. Click on the “Connected with Google Sheet” button after making all the necessary modifications. In turn, the authentication window that you use to log in to your Google account would open. All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “YouCanBook.me Bookings”. Now, all you have to do is add the necessary field from drop-down such as for the name, select the name option, and for the email field select the email. Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the Cognito Forms and Google Sheet integration. Lastly, when you check the Google Sheets, the cancelled entry get auto-populated in a sheet. Now you know how to integrate Google Sheets with YouCanBook.me bookings. This is a single-time process, after this every time when a booking gets cancelled, it will get auto-populated in the sheet. That’s that! Here we have cleared all the air about the automation process. In this post, we learned how to add Google Sheets row for cancelled YouCanBook.me bookings in real-time. All you have to do is follow all the steps listed above and you can connect YouCanBook.Me to Google Sheets quickly. One can easily avoid monotonous work with the help of automation. And in those situations, software like Pabbly Connect is true salvation that allows unlimited premium applications. So, wait no longer. Go and get your access by signing up for a free account.Step 2: Access Pabbly Connect
Step 3: Workflow for YouCanBook.me to Google Sheet Integration
(a) Start with a New Workflow
(b) Name the Workflow
Step 4: Setting Trigger for YouCanBook.me to Google Sheet Integration
(a) Select Application you Want to Integrate
(b) Copy the Webhook URL
Step 5: Connecting YouCanBook.me to Pabbly Connect
(a) Select Your Booking Page
(b) Head to Notification Section
(c) Choose If Booking Cancelled Option
(d) Click on “+” Icon
(e) Select the “Webhook” Option
(f) Paste the Copied Webhook
(g) Make Dummy Booking
(h) Cancel Booking
Step 6: Test the Response in Pabbly Connect Dashboard
Step 7: Setting Action for YouCanBook.me & Google Sheet Integration
(a) Select Application you Want to Integrate
(b) Click the Connect Button
(c) Map Field Data
(d) Save and Send Test Request
Step 8: Check Response in Google Sheet
Conclusion –
You May Also Like To Read –
