Integrating Google Sheets with Sendy Using Pabbly Connect: A Step-by-Step Guide

Learn how to automate subscriber creation in Sendy from Google Sheets using Pabbly Connect. Follow our detailed tutorial for seamless integration. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Sendy, first access Pabbly Connect by visiting its website. If you are new to Pabbly, you can sign up for free, which provides you with 100 tasks each month. Existing users can simply sign in to their accounts.

Once logged in, navigate to the Pabbly Connect dashboard, where you will see options to create a new workflow. This platform enables you to connect various applications seamlessly without coding skills, making automation straightforward and efficient.

Creating a Workflow in Pabbly Connect

In this step, you will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and provide a name for your workflow, such as ‘Create Sendy Subscriber from Google Sheets’. Choose the appropriate folder to save your workflow for better organization.

After naming your workflow, you will see two boxes appear labeled ‘Trigger’ and ‘Action’. The trigger is the event that starts the workflow, in this case, a new row added to Google Sheets. The action is what happens as a result, which is creating a subscriber in Sendy.

Setting Up the Trigger with Google Sheets

To set up the trigger, select Google Sheets as the trigger application in Pabbly Connect. The trigger event will be ‘New or Updated Spreadsheet Row’. This means that whenever a new row is added to your specified Google Sheets, it will activate the workflow.

Next, you will connect Pabbly Connect to Google Sheets using a webhook URL. This URL acts as a bridge between Google Sheets and Pabbly Connect. To do this, go to your Google Sheets, click on ‘Extensions’, then ‘Add-ons’, and finally ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. Refresh your Google Sheets after installation.

• Click on ‘Extensions’ again, go to ‘Pabbly Connect Webhooks’, and select ‘Initial Setup’.
• Paste the webhook URL from Pabbly Connect into the designated field.
• Specify the trigger column, which is the final data column in your sheet (e.g., Column D).

After submitting the setup, click on ‘Send on Event’ to ensure that future data entries in your Google Sheets are sent to Pabbly Connect.

Adding Subscribers to Sendy

With the trigger set, it’s time to configure the action application, which is Sendy. Select Sendy as the action application in Pabbly Connect and choose the action event ‘Add Subscriber’. If you have an existing connection, you can save it; otherwise, click on ‘Add New Connection’ to enter your Sendy API key and installation URL.

To find your API key, log in to your Sendy account, navigate to the ‘Admin’ settings, and regenerate your API key. Copy this key and paste it into Pabbly Connect. Additionally, enter your Sendy installation URL to complete the connection.

• Retrieve the List ID from your Sendy account by clicking on ‘View All Lists’.
• Map the necessary fields such as name and email address from the Google Sheets response to the corresponding fields in Sendy.
• Click on ‘Save and Send Test Request’ to finalize the subscriber addition.

After completing these steps, check your Sendy account to confirm that the new subscriber has been successfully added.

Testing the Integration

To ensure everything is working correctly, test the integration by adding a new row in your Google Sheets with customer details. As soon as you fill in the required fields, such as first name, last name, phone number, and email address, the workflow in Pabbly Connect will be triggered.

Return to Pabbly Connect and observe the webhook response. You should see the details from your Google Sheets populated in the response. This indicates that the connection is functioning as intended.

Finally, check your Sendy account to verify that the new subscriber has been added to your specified list. Repeat this process with different entries to ensure consistent performance of the automation.

Conclusion

In this tutorial, we demonstrated how to integrate Google Sheets with Sendy using Pabbly Connect. By following the steps outlined, you can automate subscriber creation effortlessly and ensure your email marketing campaigns run smoothly.