In this blog, we are going to show you the step by step procedure to save the newly added GetResponse contacts to Google Sheets rows automatically. As we sometimes need to collect the subscriber’s data for further marketing usage.
We are going to integrate GetResponse with Google Sheets using Pabbly Connect to automatically save the contacts in spreadsheet rows. Pabbly Connect lets you connect two or more services to shares data in real-time as well as take specific actions on them such as send automated emails, record them in spreadsheets, forward it to other partner services etc without hard coding.
We’ll set up a trigger on the GetResponse new contact inserted and its respective action for saving the contact details on Google Sheets rows.
Moreover, Pabbly Connect also allows you to set up instant triggers, routers, filters as well as formatters to design unlimited workflows. Besides, it also provides many advanced features like multi-step calls, integration with unlimited premium apps etc. All in all, you can make use of any of these and many more features to automate your tasks.
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
It allows you to design as well as automate the workflow to add the recently added contacts on GetResponse to Google Sheets rows in just a minute interval. So, save your time and automate your tasks, access all Pabbly Connect features without any restriction even in the free plan.
Now, let’s dig in the step by step procedure to integrate GetResponse to Google Sheets and automatically save the newly added contacts within sheets rows.
Step 1: Sign up to Pabbly Connect
Visit the official website of Pabbly Connect & then hit the ‘Sign-Up Free‘ button. Next, on the registration page signup using an existing Google account or manually fill in the form to get into the system.
Step 2: Access Pabbly Connect
After signing up successfully, click the ‘Access Now’ button of the software ‘Connect’ Pabbly application.
Step 3: Workflow for GetResponse with Google Sheets Integration
(a) Start with a New Workflow
Start with creating a workflow to save new GetResponse contacts to Google Sheets as rows and to do this strike the ‘Create New Workflow’ button.
(b) Name the Workflow
Now, name the workflow as per your need (for instance: GetResponse to Google Sheets etc) and push the ‘Save’ button.
Step 4: Setting Trigger for GetResponse – Google Sheets Integration
To automatically add new GetResponse contacts to Google Sheets as rows whenever a new contact is added, you’ll need to set-up a trigger on ‘New Contact’ event and its respective action to add the contact details in your Google Sheets as rows.
(a) Select Application you want to integrate
When you hit the save button to create a workflow, a trigger window will open next.
You’ll need to select the ‘GetResponse’ option from the ‘Choose App’ field drop-down options.
(b) Copy the Webhook URL
Select the method in here to be ‘New Callback’ & copy the ‘Webhook URL’ by clicking the ‘Copy’ button on this page.
Up to this point, we are half-way done with the GetResponse to Google Sheets integration’s trigger. And now, we’ll need to paste this URL on our GetResponse settings to get the trigger working.
Step 5: Connecting GetResponse to Pabbly Connect
To connect your GetResponse account and Pabbly Connect. First, sign-in into your GetResponse account.
(a) Go to Your GetResponse Menu
After signing in to your GetResponse account, click the ‘Menu’ button to create a booking page.
Select the ‘Integration & API’ option from the menu options.
(b) Click on Callback
Click on the ‘Callback’ option from the top horizontal integration & API menu.
(c) Paste Webhook URL
Now, tick the ‘Subscribes’ options and then paste the copied webhook URL in the ‘Which URL to use to post notifications?’ field.
Step 6: Test the Trigger Response in Pabbly Connect Dashboard
As we can see, we are done setting up the trigger to save new GetResponse contacts to Google Sheets as rows. So now, let’s just test the trigger by making a test booking on GetResponse.
(a) Capture Webhook Response
To test the trigger, first, hit the ‘Capture Webhook Response’ button on the Pabbly Connect trigger window.
(b) Fill the GetResponse Form
Fill the details in the response form and then submit the page.
(c) Check Trigger API’s Response
Check the captured trigger response in the Pabbly Connect trigger window. You can see all the data fed in the Getresponse form in the trigger response.
Step 7: Setting Action for GetResponse – Google Sheets Integration
As we can see the response that we got of the GetResponse trigger contain all the newly added contact details. Now, we will simply forward this captures data to Google Sheet rows.
(a) Create Google Sheets
To save the recently added contact within a Google Sheet first, create a spreadsheet within your Google Account.
And also name the columns.
(b) Select Application You Want to Integrate
Click the plus button next to your GetResponse trigger window.
And in the action window that opens next, choose the ‘Google Sheets’ app from the ‘Choose App’ field’s drop-down menu.
(b) Connect with Google Sheets
Select the method in here as ‘Add New Row’ and then click the ‘Connect with Google Sheets’ button.
(c) Authorize Google Account
In the next window that slides in from the right click on the ‘Connect’ button. And then complete the authorization by allowing the connection between your Google account and Pabbly Connect.
(d) Choose the Spreadsheet & Sheet Within
Pick the sheet that you’ve created for this purpose as well as the sheet within for the exact location.
(e) Map Values
Next, you’ll need to map the trigger API response values that you got from GetResponse with the Google Sheets columns.
(f) Save & Send Test Request
After mapping all the necessary fields, click on the ‘Save & Send Test Request’ button.
Step 8: Check the Action’s Response
(a) Check the Action API’s Response
You can check the response of your API in the action window.
(b) Check the Contact Entry in Google Sheets
Also, you can check the entry of a new done in your connected Google Sheets account.
Step 9: Save the Workflow
(a) Save the Action API’s Response
Save the action API’s response by hitting the ‘Save’ button at the bottom of the action API’s response.
(b) Save the Workflow
As we can see the workflow is working perfectly. So, simply save the webhook by clicking the save button in the trigger window.
Well, this is all about ‘How to save new GetResponse contacts to Google Sheets as rows’. Consequently, after completing the step by step procedure, you will end up saving the GetResponse contacts on Google Sheets rows. More importantly, this process is very simple & you don’t need any coding knowledge to follow the steps.
Now, you cal also try Pabbly Connect for FREE.
For further questions, comment below.