How to Add OnceHub Booking Details in Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate OnceHub booking details into Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for efficient automation. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start this process, we will access Pabbly Connect to automate the integration between OnceHub and Google Sheets. First, open your web browser and search for Pabbly Connect.

Once on the landing page, you will find options to sign in or sign up. If you’re a new user, click on ‘Sign Up for Free’ to get started. Existing users can directly sign in to access the dashboard. After logging in, locate and click on the ‘Access Now’ button for Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a workflow that connects OnceHub with Google Sheets. Click on the ‘Create Workflow’ button, which will prompt you to name your workflow. using Pabbly Connect

• Name your workflow as ‘Add OnceHub Booking Details in Google Sheets’.
• Select the folder for this workflow, such as ‘Automations’.

After naming your workflow, click on the ‘Create’ button. You will be directed to the workflow window where you can set up the trigger and action for your automation.

3. Setting Up the Trigger with OnceHub

In this step, we will configure the trigger for our workflow using OnceHub. Click on the ‘Select App’ field and search for OnceHub, then select it as the trigger application. using Pabbly Connect

For the trigger event, choose ‘Booking Scheduled’. Click on the ‘Connect’ button to establish a connection. If you haven’t connected your OnceHub account before, you’ll need to add a new connection using your API key.

• Log into your OnceHub account to retrieve your API key.
• Paste the API key into Pabbly Connect and click ‘Save’.

After saving, you will need to create a test booking in OnceHub to trigger the workflow and confirm that the connection is successful.

4. Setting Up the Action to Google Sheets

Once the trigger is set up, the next step is to configure the action that sends data to Google Sheets. Search for Google Sheets in the action app selection and select it. using Pabbly Connect

For the action event, choose ‘Add New Row’ and click on ‘Connect’. If you haven’t connected your Google Sheets account before, you will need to sign in with your Google account and grant permissions to Pabbly Connect.

Select the spreadsheet you want to use, such as ‘Event’. Choose the specific sheet, like ‘Sheet1’, for the data entry.

Next, map the data fields from the OnceHub booking details to the corresponding columns in Google Sheets. This mapping ensures that each new booking will automatically populate the correct fields in your spreadsheet.

5. Finalizing the Workflow and Testing

After mapping the fields, save your settings and send a test request to verify that the data is correctly sent to Google Sheets. If successful, you will see the booking details reflected in your spreadsheet.

To test the workflow, create another booking in OnceHub and check if the details appear in Google Sheets as expected. This confirms that the integration is functioning correctly.

In summary, the workflow involves:

Trigger: OnceHub (Booking Scheduled) Action: Google Sheets (Add New Row)

By following these steps, you can effectively automate the process of adding OnceHub booking details into Google Sheets using Pabbly Connect.

Conclusion

This tutorial demonstrated how to integrate OnceHub booking details into Google Sheets using Pabbly Connect. By automating this process, you can efficiently manage your bookings and keep your records updated seamlessly.