How to Add Booking Details from TuCalendi to Google Sheets Using Pabbly Connect

Learn how to automate adding booking details from TuCalendi to Google Sheets with Pabbly Connect. Step-by-step tutorial for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for TuCalendi and Google Sheets Integration

To begin the integration process using Pabbly Connect, you first need to access your Pabbly Connect dashboard. This platform automates the transfer of booking details from TuCalendi to Google Sheets seamlessly. Start by signing up for a free account if you haven’t already.

Once logged in, create a new workflow. Click on ‘Create Workflow’ and name it something like ‘TuCalendi to Google Sheets’. This will set the stage for automating the process of adding booking details whenever a new booking is created in TuCalendi.

2. Configuring the Trigger for New Bookings in TuCalendi

In this step, you will set up the trigger to capture new bookings from TuCalendi using Pabbly Connect. In the trigger window, search for TuCalendi and select it as the app. Next, choose the trigger event as ‘Booking Created’. This tells Pabbly Connect to listen for new bookings.

• Select TuCalendi as the application.
• Choose the event ‘Booking Created’.
• Copy the provided webhook URL.

Now, go to your TuCalendi account, navigate to the calendar section, and choose the event you want to track. Click on ‘Webhook’ and add the copied URL. This connection allows Pabbly Connect to receive booking details whenever a new event is scheduled in TuCalendi.

3. Testing the Booking Trigger with Pabbly Connect

After setting up the trigger, it’s essential to test if it correctly captures booking details. Use Pabbly Connect to check for a webhook response. Create a test booking in TuCalendi for the event you previously set up.

For example, schedule a booking for an event named ‘Integration’ on a specific date and time. Once the booking is confirmed, Pabbly Connect will display the response with all the booking details. You should see the event name, booking date, and user information captured in the workflow.

• Ensure the booking details reflect accurately in Pabbly Connect.
• Check for any discrepancies in time zones.

Once confirmed, this indicates that your trigger setup is functioning correctly, paving the way for the next steps in the integration process.

4. Formatting Date and Time for Google Sheets

With the booking details successfully captured, the next step involves formatting the date and time to ensure it aligns with your requirements in Google Sheets. Use the Date Time Formatter feature within Pabbly Connect to adjust the time zone from UTC to Asia/Kolkata.

In the action window, select ‘Date Time Formatter’ and choose the action event ‘Format Date with Time Zone’. Map the date and time received from the trigger to this action. Specify the original format and the desired output format, along with the respective time zones.

Map the booking date and time from the trigger. Select the original format as per your data. Set the output time zone to Asia/Kolkata.

After configuring these settings, send a test request to ensure the formatting works correctly. This will prepare the data for the final step of adding it to Google Sheets.

5. Adding Booking Details to Google Sheets

The final step is to integrate Google Sheets with Pabbly Connect to add the formatted booking details. In the action window, select Google Sheets and choose the action event ‘Add New Row’. Connect your Google Sheets account by signing in and granting necessary permissions.

Once connected, select the spreadsheet and the specific sheet where you want the booking details to be recorded. Map the fields such as booking number, user name, email, mobile number, and formatted date and time into their respective columns.

Choose the correct spreadsheet from your Google Sheets account. Map all relevant booking details to their respective columns. Save and send a test request to verify the integration.

Upon successful testing, you will see the booking details appear as a new row in your designated Google Sheet. This confirms that your integration is working perfectly, allowing for automated record-keeping of bookings from TuCalendi.

Conclusion

In this tutorial, we explored how to automate the process of adding booking details from TuCalendi to Google Sheets using Pabbly Connect. By following these steps, you can efficiently manage your bookings and maintain accurate records.