How to Create GoHighLevel Contact on OnceHub Booking & Add Details in Google Sheets Using Pabbly Connect

Learn how to use Pabbly Connect to automate the creation of GoHighLevel contacts from OnceHub bookings and add details to Google Sheets. Step-by-step guide included.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating OnceHub Booking with GoHighLevel and Google Sheets, you need to access Pabbly Connect. Begin by searching for ‘Pabbly Connect’ in your browser and open the landing page. If you’re a new user, click on ‘Sign up for free’ to get started with 100 free tasks each month.

If you are an existing user, simply click on ‘Sign In’. Once logged in, navigate to the dashboard where you will find various Pabbly applications. Click on ‘Pabbly Connect’ to begin creating your workflow.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow; enter a descriptive name like ‘Create GoHighLevel Contact on OnceHub Booking & Add Details in Google Sheets’.

• Select a folder for your workflow, such as ‘Automations’.
• Click on ‘Create’ to proceed to the workflow setup window.

This window is crucial as it allows you to set a trigger and actions. In this case, you will set OnceHub as the trigger application.

3. Setting Up the Trigger for OnceHub Booking

For the trigger application, select ‘OnceHub’ from the list. You will then need to choose the trigger event, which in this case is ‘Booking Scheduled’. Click on ‘Connect’ to proceed. using Pabbly Connect

Here, you may need to add a new connection by entering your OnceHub API key. To obtain this key, log in to your OnceHub account, navigate to the integration API section, and copy the API key provided.

• Paste the API key into Pabbly Connect and click ‘Save’.
• Provide a webhook name like ‘Free Consultation Bookings’.

Once the connection is established, you will need to perform a test booking to capture the response from OnceHub.

4. Adding Booking Details to Google Sheets

Once the trigger is set up, the next action is to add the booking details to Google Sheets. For this, select ‘Google Sheets’ as the action application. Choose the action event ‘Add New Row’ and click on ‘Connect’. using Pabbly Connect

After connecting, select the spreadsheet where you want to store the booking details. Make sure to choose the correct sheet within the spreadsheet, typically named ‘Sheet1’. You will then map the fields from the OnceHub response to the corresponding columns in Google Sheets.

Map fields such as client name, email, phone, and appointment date. Click ‘Save and Send Test Request’ to ensure the data is added successfully.

After this step, check your Google Sheets to confirm that the details have been added correctly.

5. Creating a GoHighLevel Contact

After adding the booking details to Google Sheets, the final step is to create a new contact in GoHighLevel. For this, select ‘Lead Connector V2’ as the action application and choose ‘Create or Update Contact’ as the action event.

Connect your GoHighLevel account by selecting the appropriate sub-account. Map the required fields such as name, email, and phone number from the OnceHub booking response. Finally, click ‘Save and Send Test Request’ to create the contact.

Ensure you map the full name since it may not be separated into first and last names. Check your GoHighLevel account to verify the new contact has been created.

By following these steps, you will have successfully integrated OnceHub Booking, Google Sheets, and GoHighLevel using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to create a seamless integration between OnceHub Booking, Google Sheets, and GoHighLevel. This process automates the addition of new contacts and booking details, streamlining your workflow effectively.