Integrate Google Forms with SendMails Using Pabbly Connect: A Step-by-Step Guide

Learn how to automate adding subscribers in SendMails from Google Forms submissions using Pabbly Connect. Follow our detailed tutorial for seamless integration. 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 Automation

To begin automating the process of adding subscribers to SendMails from Google Forms submissions, first, access Pabbly Connect. This platform allows seamless integration between various applications, including Google Forms and SendMails.

After signing up, log into your Pabbly Connect dashboard. Here, you will create a new workflow that connects your Google Form to SendMails. This process allows you to automate the subscriber addition whenever a new form response is received.

2. Creating a Workflow in Pabbly Connect

To create a workflow in Pabbly Connect, click on the ‘Create Workflow’ button. Name your workflow something descriptive, such as ‘Google Forms to SendMails’. Select a folder in your Pabbly account to store this workflow.

Once the workflow is created, you will see two main sections: the trigger and action windows. The trigger window is where you will set up Google Forms to send data to Pabbly Connect, and the action window will be used to add subscribers to SendMails.

• Click on ‘Create Workflow’.
• Name your workflow.
• Select a folder for your workflow.

This setup ensures that your Google Forms submissions will trigger the addition of new subscribers in SendMails via Pabbly Connect whenever a new response is captured.

3. Setting Up Google Forms Trigger in Pabbly Connect

In the trigger window of Pabbly Connect, select Google Forms as the app. Choose the trigger event as ‘New Response Received’. This will allow Pabbly Connect to capture responses from your Google Form.

After selecting the trigger event, Pabbly Connect will provide you with a webhook URL. This URL needs to be added to your Google Forms settings to complete the connection. To do this, navigate to your Google Form, go to the responses tab, and link it to a new Google Sheet.

• Select Google Forms in the trigger app.
• Choose ‘New Response Received’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

By linking this webhook URL to your Google Form, you ensure that every new submission is sent to Pabbly Connect, allowing the automation to function correctly.

4. Configuring Google Sheets for Pabbly Connect

Next, you need to configure Google Sheets to receive responses from Google Forms. After linking your Google Form to a new spreadsheet, install the Pabbly Connect Webhooks add-on from the Google Workspace Marketplace.

Once installed, refresh your Google Sheet, and go to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, you will enter the webhook URL you copied earlier, select the sheet, and specify the trigger column. The trigger column is the last column where data entries will be added.

Install the Pabbly Connect Webhooks add-on. Go to Initial Setup and enter the webhook URL. Specify the trigger column in your Google Sheet.

This configuration ensures that whenever a new form submission occurs, the data is sent to Pabbly Connect for processing, completing the integration setup.

5. Adding Subscribers in SendMails via Pabbly Connect

After setting up the trigger, the next step is to add subscribers in SendMails. In the action window of Pabbly Connect, select SendMails as the action app, and choose ‘Add New Subscriber’ as the action event.

Connect your SendMails account by entering your username and API token. You can find the API token in your SendMails account under the API section. After connecting, specify the list ID where you want to add the subscriber, along with the first name, last name, and email address, which you will map from the trigger response.

Select SendMails in the action app. Choose ‘Add New Subscriber’ as the action event. Map the subscriber details from the trigger response.

Once everything is set up, click ‘Save and Send Test Request’. If the setup is correct, you will receive a positive response indicating that the subscriber was successfully added to SendMails, completing the automation process using Pabbly Connect.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate adding subscribers in SendMails from Google Forms submissions. By following these steps, you can streamline your subscriber management process effectively.