Are you wondering if there is a way to add Acuity Scheduling appointments to Google Sheets rows automatically? If yes, then worry no more as today we have brought to you the best solution to all the automation-related problems called Pabbly Connect.
Pabbly Connect is an incredible integration and automation service, which allows you to integrate two or more applications to automate all the projects. You just have to do the integration once and then everything will be automatically managed by 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
In today’s blog, we will be integrating Acuity Scheduling with Google Sheets via Pabbly Connect. After this integration, whenever there will be any new appointments in your Acuity Scheduling account, the data will be updated in your Google Sheets automatically.
Aside from this integration, the software also offers many other useful features:
- Create unlimited workflows without any restrictions
- Unlimited premium apps
- Set unlimited triggers, unlimited actions to those triggers
- Path routers
and the remarkable part is that you can access all the features even with the free plan.
Consequently, without taking any more of your time, let’s get started with the blog about how to add Acuity Scheduling appointments to Google Sheets rows.
Step 1: Sign up to Pabbly Connect
We will begin the process to add Acuity Scheduling appointments to Google Sheets rows by visiting the website of Pabbly Connect and then click on the ‘Sign-Up Free‘ button. On the registration page, either signup using an existing Gmail account or manually fill out the form.
Try Pabbly Connect for FREE
Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect. Start with creating a workflow for your project by clicking on the ‘Create Workflow’ button. Now, you need to name the workflow just like in the above-shown image. I named the workflow as “Google Sheets to Acuity”, you can obviously name the workflow as per your requirements and needs. After naming your workflow, you have to select the application you want to integrate. Through Pabbly Connect, you can combine unlimited applications, create your free account now. Now, you have to select the application that you want to integrate. In this case, we are choosing “Acuity Scheduling” for integration. After selecting the application select “New Appointment” in the choose method section. After selecting the application, now you have to click on the “Connect with Acuity Scheduling” button just like in the above-shown image to take further the integration process. To connect Acuity Scheduling with Pabbly Connect, you have to authorize your Acuity Scheduling account, for that, you need to log in to your Acuity Scheduling account. When you click on the “Connect” button, a window will slide in from the right, here you have to again click on the “Connect” button and then choose the account through which we want to log into Acuity Scheduling. Now after authorizing your Acuity Scheduling account, we will click on the “Save and Send a Test Request” button in Pabbly Connect to check if the integration was successful or not. To check if the integration is capturing data or not, we will book a sample appointment. Select the date and time for your appointment according to your needs. Fill up all the required details and hit the “Schedule Appointment” button. But before that, click on the “Capture Webhook Response” button in the Pabbly Connect dashboard. As soon as you click on the “Schedule Appointment” in Acuity Scheduling and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option. In this step, we will be adding two actions for your trigger to complete this integration process. The first action of Acuity Scheduling to get the booker’s info from the appointment ID and the second action of Google Sheets to update the appointment info. Now in this step, click on the + button below and choose “Acuity Scheduling” and in the method section select “Get a Single Appointment by ID”. After choosing the application click on the “Connect” button to move forward. Here, you have to again authorize your Acuity Scheduling account by clicking “Connect” button and loging-in. Next after authorizing your account, you have to add the appointment ID, which you can copy from the trigger section and then click on the “Save & Send Test Request” button. Here, you can see, we have obtained the booker’s info like name, email, etc from the appointment ID. Save the API response and move forward. Now in this step, click on the + button below and choose “Google Sheets” and in the method section select “Add New Row”. After choosing the application click on the “Connect” button to move forward. To connect Google Sheets with Pabbly Connect, you need to authorize your Google account through which you want to choose the sheet to connect. When you click on the “Connect” button, a window will slide in from the right, here you have to again click on the “Connect” button and then choose the Google account through which we want to integrate. Once you are connected with your Google account, now you have to add all the field’s data that you want in your Google Sheet like sheet name, email id, etc. Map up all the fields quickly. Once you are done mapping up all fields click on the “Send Test Request” button. Here, you can see the integration was successful and the info from the Acuity Scheduling has been added to the Google Sheet automatically. Now in a similar way, whenever there will be any new appointments in your Acuity Scheduling account, the info will be automatically added to the Google Sheets. Alright, now that you have learned how to add Acuity Scheduling appointments to Google Sheets rows, now you can easily integrate any applications and automate your projects. Once you start working with Pabbly Connect, there is no going back. You can create unlimited workflows, integrate unlimited applications, work with so many premium apps, and you get all this for free. Therefore stop thinking and signup for your free account today. In case of any queries or suggestions, please drop your comments below.Step 2: Access Pabbly Connect
Step 3 : Workflow for Acuity Scheduling with Google Sheets Integrations
(a) Create New Workflow
(b) Name the Workflow
Step 4 : Setting Triggers for Acuity Scheduling with Google Sheets Integrations
(a) Select Application you want to Integrate
(b) Click Connect Button
Step 5 : Connecting Acuity Scheduling to Pabbly Connect
(a) Authorize Application
(b) Send Test Request
Step 6 : Book an Appointment
(a) Select Time Slot
(b) Fill up the Details
Step 7 : Test the Submission in Pabbly Connect Dashboard
Step 8 : Setting Action for Acuity Scheduling with Google Sheets Integrations
(a) Select Application you want to Integrate
(b) Click on Connect Button
(c) Authorize Application
(d) Add Appointment ID
(e) Save the API Response
(f) Select Application you want to Integrate
(g) Click on Connect Button
Step 9 : Connecting Google Sheets to Pabbly Connect
(a) Click the Connect Button
(b) Map the Fields
(c) Send a Test Request
Step 10 : Check Response in Google Sheet
Conclusion –
You May Also Like to Read –