Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Add TidyCal Booking Details to Google Sheets Automatically

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Tidycal with Google Sheets, you first need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect website. If you already have an account, simply log in. New users can sign up for a free account to get started.

Once logged in, you will be taken to the Pabbly Connect dashboard. Here, you can create a new workflow that connects your Tidycal bookings to Google Sheets. This setup allows for automatic data entry, eliminating the need for manual entry and reducing errors.

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘Create Workflow’ button to initiate the process. You will be prompted to choose a workflow builder. Select the Quick Builder for a streamlined experience.

Click on the ‘Create Workflow’ button.
Select ‘Quick Builder’ as your workflow option.

Next, input your request into the AI flow builder. For example, type “New bookings as data in Google Sheets”. This will set up the trigger for when a new booking is made in Tidycal, automatically adding a new row in Google Sheets.

3. Connecting Tidycal to Pabbly Connect

To connect Tidycal, click on the ‘Connect’ option within the workflow. You will need to authorize your Tidycal account by clicking on the ‘Connect with Tidycal’ button. This step is essential for Pabbly Connect to access your Tidycal data.

After clicking the authorization button, you will be prompted to grant permissions. Once authorized, select the response format as “Simple”. Then, click on the ‘Save and Send Test Request’ button to capture the last booking created in Tidycal.

4. Formatting Data for Google Sheets

After capturing the booking details, you may need to format the date and time. Use the “Date Time Formatter by Pabbly Connect” for this purpose. Select the action step and choose “Format Date with Time Zone”.

Select the date you want to edit from the previous response.
Map the data dynamically to ensure it updates automatically.

Set the time zone to your local time zone (e.g., Asia/Kolkata). Once configured, click on ‘Save and Send Test Request’ to confirm that the formatting works correctly.

5. Adding Booking Details to Google Sheets

Now it’s time to connect your Google Sheets. Click on ‘Connect’ and select ‘Add New Connection’. Choose the ‘Sign in with Google’ option to link your Google account.

Once connected, select the spreadsheet where you want to store the booking details. Map the relevant fields such as name, email, phone number, and booking date to their corresponding columns in Google Sheets.

Map each field to ensure accurate data entry.
Click on ‘Save and Send Test Request’ to finalize the setup.

After completing this step, you will see that your booking details are now automatically recorded in Google Sheets whenever a new booking is made in Tidycal. This seamless integration demonstrates the power of Pabbly Connect.

Conclusion

By following this tutorial, you can easily integrate Tidycal with Google Sheets using Pabbly Connect. This automation saves time and reduces errors, ensuring that your booking details are always accurately recorded.