Google Forms is an easy way to collect data and feedback from various stakeholders. Undoubtedly, it integrates seamlessly with other Google products like sheets, Gmail, etc. But, if you want to integrate Google Forms with Pabbly Email Marketing and you’re a beginner then don’t worry!

How to Integrate Google Forms & Pabbly Email Marketing

Here, we are recommending a tool called Pabbly Connect that integrates Google Forms with any email marketing software. Pabbly Connect automatically send data and email addresses to your subscriber’s list from a new or updated Google Forms without doing any manual efforts. Apart from this, it will directly send email addresses to Pabbly Email Marketing, MailChimp, ActiveCampaign, or another platform.

Basically, Pabbly Connect is an automation software that automates all your integrations without any manual efforts. It lets you create unlimited multi-step calls for connecting limitless applications in your workflows at a very affordable price. Apart from this, it is the only software that offers advanced features like instant triggers, formatters, filters, path routers, etc even with its basic plan without any restrictions.

Now, let’s take a look at how to integrate Google Forms with Pabbly Email Marketing using Pabbly Connect.

Just follow these easy and simple steps without using a single line of code and send info between Google Forms and Pabbly Email Marketing.

Step 1: Create New Google Forms

Create New Google Forms - Integrate Google Forms

First of all, create a simple form through Google Forms to collect lead data in Pabbly Email Marketing.

Step 2: Create New Spreadsheet to Capture Form Responses

Capture Responses - Google Forms

After creating the form click on the “Responses” option. Here you need to create a new spreadsheet to save all the responses to the Google Spreadsheet file. Just click on the spreadsheet icon, name the sheet, and your spreadsheet is ready to capture the form responses.

As soon as you click on the Spreadsheet icon, you will see that multiple columns are created in the sheet according to your form such as timestamp, your name, email address.

Step 3: Fill your Form to Get Test Data on Google Sheet

Test Data - Google Forms Submissions

Fill your form to get some test data through which you can do the testing and push that test data to Pabbly Email Marketing. Once you filled the form the entry will appear on the Google Spreadsheet.

(a) Go to the Add-ons Button of Sheet Menu Bar

Get Add-ons - Google Forms Submissions

In this step, click on the “Add-ons” button from the sheet menu bar and go to the “Get add-ons” option for installing the Pabbly Connect webhooks.

(b) Install Pabbly Connect Webhooks

Install Pabbly Connect Webhooks

Next, when you click on the “Get add-ons” button G Suite Marketplace window will appear on your screen. Momentarily, search for the Pabbly Connect Webhooks and install it on your Google sheet for integrating Google Forms and Pabbly Email Marketing.

(c) Go to Pabbly Connect Webhooks and Click on Initial Setup Option

Initial Setup - Pabbly Connect Webhook

After installing the Pabbly Connect Webhook you will see that it appears on the add-ons section. Now go to the “Initial Setup” option.

(d) Paste Webhook URL and Set Trigger Column

Webhook URL

A small pop-up window will open on the screen where you will need to paste the webhook URL, which you will find on the Pabbly Connect dashboard after creating the workflow.

Step 4: Sign-up to Pabbly Connect

Sign-up to Pabbly Connect

Now, to create your workflow, visit the Pabbly Connect website and Signup to your account. Either manually fill all the details or sign-up via your Google account.

Step 5: Access Pabbly Connect

Access Pabbly Connect - Integrate Google Forms & Pabbly Email Marketing

After completing the signup process, go to the “Connect” option and click on the “Access Now” button.

Step 6: Create a WorkFlow for Integrating Google Forms to Pabbly Email Marketing

(a) Create New Workflow

Create New Workflow - Pabbly Connect

Let’s begin the process of creating a workflow to integrate Google Forms to Pabbly Email Marketing by hitting the ‘Create New Workflow’ button.

(b) Name the Workflow

Name the Workflow

Following, named your workflow according to your project, which in our case is “Google Sheet Forms to Pabbly Email Marketing.”

(c) Setting Trigger

Setting Triggers - To Integrate Google Sheets

In this step, you need to choose the trigger app, i.e Google Sheets which you want to integrate with Pabbly Email Marketing. Additionally, copy the webhook URL which appears on the Pabbly Connect dashboard. Basically, a Webhook URL is a way to receive data from the application without any coding requirement.

Step 7: Go Back to the Google Sheet and Paste the Webhook URL

Send Test Data

Now go back to the Google spreadsheet, paste the Webhook URL, and click on the “Send Test” button. Here, you can see the name, date, and email address are posted to the Pabbly Connect.

Step 8: Capture Test Data

Capture Test Data

After sending the test data to your workflow, hit the “Capture Webhook Response” button, and capture the webhook response. All details of the form like email, name, and timestamp will come on the Pabbly Connect dashboard. Immediately, save all the responses by clicking on the “Save” button, and your Google spreadsheet is integrated with Pabbly Connect.

Step 9: Log-in to Pabbly Email Marketing Account for Developer API

(a)Click on the Integration Option from the Menu bar

Pabbly Email Marketing

Here, all you have to do is log-in to your Pabbly Email Marketing account and go to the “Integrations” option.

(b) Visit Developer API Option

Paste Bearer Token

Next, inside the developer API, you will find bearer token of your specific account. Just copy it and go back to the Pabbly Connect dashboard.

Step 10: Setting Action

(a) Choose Pabbly Email Marketing App

Choose Pabbly Email Marketing App - Setting Action

Here click on the “+” icon to add an action for your trigger. Choose “Pabbly Email Marketing” from the drop-down list, select the “Add subscriber” option as a method, and hit the “Connect with Pabbly Email Marketing” button.

(b) Paste the API key inside Pabbly Connect Dashboard & Save

Paste the API key

Afterward, paste the “Bearer Token”, which you have copied from the Pabbly Email Marketing account.

(c) Map the Data Modules with Google Forms

Map the Data Modules

In this step, select the relevant list name in which you want to add data which in our case is “Leads from Google Forms”. Also, you can select the default list for storing your subscriber’s list. Further, in the next step click on the three-line symbol and map the data that is coming from the Google Forms such as email with “Your Email Address” and name with “Your Name”. After, doing all the changes hit the “Save & Send Test Request” button.

(d) Save and Send Test Request

Save and Send Test Request

That’s it! Success message will appear on your screen it means your Google Forms are integrated with Pabbly Email Marketing.

Step 11: Check Submission in Pabbly Email Marketing Dashboard

Check Submission

Finally, visit the Pabbly Email Marketing dashboard and check the subscriber list. All the details of the subscriber will appear there automatically. With Pabbly Connect, you won’t have to spend time reading through each response before taking action. It will automatically get added to your subscriber list.

Wrapping Up

This was a step by step guide towards “How to Integrate Google Forms & Pabbly Email Marketing”. As per now, you can clearly see the advantages of using Pabbly Connect over the other automation tools. Also, the service has made it super easy to integrate your favorite apps and services without requiring any technical skills. Just follow the above steps and transfer the data between multiple application.

If you have any queries, do comment us below. We’ll get back to you as early as possible.

You May Also Like To Read: