How to Add Subscribers in SendMails from Google Forms Submission Using Pabbly Connect

Learn to automate adding subscribers in SendMails from Google Forms submissions using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

In this section, we will learn how to set up Pabbly Connect to automate adding subscribers in SendMails from Google Forms submissions. First, access your Pabbly Connect dashboard by signing up for a free account if you haven’t already. Once logged in, click on the ‘Create Workflow’ button to start.

Give your workflow a name, such as ‘Google Forms to SendMails’. Select the appropriate folder in your Pabbly Connect account to save this workflow. After creating the workflow, you will see two windows: the trigger window and the action window, which are essential for setting up the automation.

2. Connecting Google Forms to Pabbly Connect

To connect Google Forms to Pabbly Connect, we need to set up the trigger. In the trigger window, search for ‘Google Forms’ and select it. From the dropdown, choose the trigger event as ‘New Response Received’. This step is crucial as it allows Pabbly Connect to capture responses from your Google Forms.

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

Next, go to your Google Form, click on the ‘Responses’ tab, and link it to a new Google Sheet. This step is necessary because the responses will be stored in Google Sheets, which Pabbly Connect will monitor. After linking, open the Google Sheet, go to ‘Extensions’, then ‘Add-ons’, and click on ‘Get Add-ons’ to install the Pabbly Connect Webhooks add-on.

3. Configuring Google Sheets for Pabbly Connect

After installing the Pabbly Connect Webhooks add-on, refresh your Google Sheet. Then, go to ‘Extensions’, hover over Pabbly Connect Webhooks, and click on ‘Initial Setup’. In the setup box, select the sheet linked to your form responses, paste the webhook URL, and specify the trigger column.

The trigger column is the last column in your Google Sheet where new data will be entered. Once configured, click ‘Submit’. You should see a confirmation message indicating successful setup. Finally, enable the ‘Send on Event’ option in the Pabbly Connect Webhooks menu to ensure that new form submissions trigger data sending to Pabbly Connect.

4. Adding Subscribers in SendMails Using Pabbly Connect

Now that we have connected Google Forms and Google Sheets to Pabbly Connect, we can proceed to add subscribers in SendMails. In the action window of your Pabbly Connect workflow, search for ‘SendMails’ and select it. Choose the action event as ‘Add New Subscriber’.

Next, connect your SendMails account by entering your username and API token. To find your API token, log into your SendMails account, navigate to the API section, and copy the token. After connecting, specify the list UID where the new subscriber will be added, which can be found in the URL of your subscriber list.

• Enter the username and API token for your SendMails account.
• Specify the list UID where the subscriber will be added.
• Map the subscriber’s first name, last name, and email from the trigger step.

After mapping the details, click on ‘Save and Send Test Request’. If successful, you will receive a confirmation that the subscriber was added to SendMails. This indicates that your Pabbly Connect automation is functioning correctly.

5. Testing the Automation Workflow

To ensure that your Pabbly Connect automation is working, perform a test by submitting a new response through your Google Form. After submission, check your Google Sheet to confirm that the response has been recorded. Then, verify in SendMails that the subscriber has been added.

For example, enter a new user’s details and submit the form. Refresh your subscriber list in SendMails, and you should see the new subscriber listed. This real-time testing confirms that the integration between Google Forms and SendMails via Pabbly Connect is operational.

By following these steps, you can successfully automate the process of adding subscribers in SendMails from Google Forms submissions using Pabbly Connect. This integration not only saves time but also enhances your email marketing efforts.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate adding subscribers in SendMails from Google Forms submissions. By following the steps outlined, you can streamline your workflow and efficiently manage your email lists.