How to Add New Subscribers to Acumbamail from Google Sheets Using Pabbly Connect

Learn how to automate adding subscribers to Acumbamail directly from Google Sheets using Pabbly Connect in this step-by-step tutorial. 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. Setting Up Pabbly Connect for Google Sheets Integration

To start adding new subscribers to Acumbamail from Google Sheets, you need to first access Pabbly Connect. Sign up for a free account if you haven’t already, and log in to the dashboard. Here, you will create a new workflow by clicking on the ‘Create Workflow’ button.

Once you click on the button, you can name your workflow. For this integration, you might name it ‘Google Sheets to Acumbamail Automation’. After naming it, click on the ‘Create’ button to proceed. This sets up the framework for your automation.

2. Configuring the Trigger in Google Sheets

The next step is to configure the trigger for your workflow. In Pabbly Connect, select ‘Google Sheets’ as your trigger application. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This event will trigger the workflow whenever a new row is added to your Google Sheets.

After selecting the trigger, you will receive a webhook URL. This URL is crucial as it fetches data from Google Sheets into Pabbly Connect. Follow these steps to configure the webhook:

• Open your Google Sheets and click on ‘Extensions’.
• Select ‘Add-ons’ and then ‘Get Add-ons’.
• Search for ‘Pabbly Connect Webhooks’ and install it.
• After installation, refresh your spreadsheet.

After refreshing, navigate back to ‘Extensions’, find ‘Pabbly Connect Webhooks’, and click on ‘Initial Setup’. Here, paste the webhook URL you copied earlier and set your trigger column, which is the last column that will trigger the workflow.

3. Testing the Integration with Google Sheets

Now that you have set up the trigger in Pabbly Connect, it’s time to test the integration. Fill in the necessary details for a new subscriber in your Google Sheets. Once you enter the details, click on the ‘Send Test’ button in the Pabbly Connect Webhooks.

This action will send the test data from your Google Sheets to Pabbly Connect. If successful, you will see the test data reflected in your workflow. Make sure to submit this test data to confirm that the integration is working correctly.

4. Adding a Subscriber to Acumbamail

With the trigger now set up and tested, you can proceed to add the subscriber to Acumbamail. In your Pabbly Connect workflow, select ‘Acumbamail’ as the action application. Choose the action event ‘Add or Update Subscriber’. This will allow you to add the subscriber whose data you just sent from Google Sheets.

Next, you will need to connect your Acumbamail account by entering the API key. You can find the API key in your Acumbamail account settings. Once connected, select the list you want to add the subscriber to from the dropdown menu.

5. Finalizing the Automation

After configuring the Acumbamail settings in Pabbly Connect, ensure that you map the email address and other necessary fields from your Google Sheets data. Once everything is mapped correctly, click on ‘Save and Send Test Request’. This action will send the subscriber data to Acumbamail, adding the new subscriber to your selected list.

Finally, refresh your Acumbamail list to verify that the new subscriber has been added successfully. This automation will now work seamlessly, adding new subscribers from Google Sheets to Acumbamail automatically whenever a new row is added.

Conclusion

In this tutorial, we explored how to automate adding new subscribers to Acumbamail from Google Sheets using Pabbly Connect. By following these steps, you can streamline your email marketing efforts and save valuable time.