Integrate 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. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Sheets and Sendy Integration

To start using Pabbly Connect, visit the official website by typing ‘Pabbly.com/connect’ in your browser. This platform allows you to create seamless integrations between applications like Google Sheets and Sendy.

Once on the Pabbly Connect website, you will need to either sign in to your existing account or sign up for a new one. New users can take advantage of 100 free tasks monthly, which is perfect for testing integrations.

2. Creating a New Workflow in Pabbly Connect

After logging into Pabbly Connect, navigate to the dashboard and select the option to create a new workflow. This is where you will set up the connection between Google Sheets and Sendy. Name your workflow appropriately, such as ‘Create Sendy Subscriber from Google Sheets.’

Next, you will see options for setting a trigger and an action. The trigger will be Google Sheets, specifically the event of a new or updated row. The action will be Sendy, where a subscriber will be created automatically. This setup ensures that every new entry in Google Sheets is reflected in Sendy.

3. Setting Up Google Sheets with Pabbly Connect

To connect Google Sheets with Pabbly Connect, you will need to set up a webhook URL provided by Pabbly. First, go to your Google Sheets document containing customer details. Click on Extensions, then Add-ons, and select ‘Get Add-ons’. Search for Pabbly Connect Webhooks and install it.

Once installed, navigate back to Extensions, select Pabbly Connect Webhooks, and click on ‘Initial Setup’. Here, paste the webhook URL you copied from Pabbly Connect and specify the trigger column, which should be the last column with data. For instance, if your final data entry column is D, enter D into the trigger column field. Finally, click on ‘Submit’ to save the configuration.

• Open Extensions in Google Sheets.
• Select Pabbly Connect Webhooks, then Initial Setup.
• Paste the webhook URL and specify the trigger column.

After successfully setting this up, go back to Pabbly Connect and check for a response to ensure the connection is working. You can do this by entering some test data in Google Sheets.

4. Creating Subscribers in Sendy via Pabbly Connect

With the Google Sheets setup complete, the next step is to configure Sendy as the action application in Pabbly Connect. Select Sendy and choose the action event as ‘Add Subscriber’. If you don’t have an existing connection to Sendy, you will need to create one by entering your Sendy API key and installation URL.

To get your Sendy API key, log into your Sendy account, navigate to the Admin section, and regenerate your API key. Copy this key and paste it into Pabbly Connect. Also, enter your Sendy installation URL. After saving the connection, you can proceed to map the required fields for the subscriber data.

• Select Sendy as the action application.
• Enter your API key and installation URL.
• Map the subscriber fields from Google Sheets.

Ensure that you map the name, email, and any other relevant fields from the Google Sheets data to the corresponding fields in Sendy. This mapping will allow for dynamic updates every time new data is added to Google Sheets.

5. Testing the Integration Between Google Sheets and Sendy

After setting up the action in Pabbly Connect, it’s crucial to test the integration. Enter a new row of data in your Google Sheets, including the first name, last name, phone number, and email address. Once you input this data, the workflow should trigger automatically, sending the new subscriber information to Sendy.

Check your Sendy account to confirm that the new subscriber has been added successfully. You should see the new subscriber listed under the specified list in Sendy. If everything is configured correctly, this process will work seamlessly every time a new row is added to Google Sheets.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the creation of subscribers in Sendy directly from Google Sheets. By setting up the trigger and action correctly, you can streamline your email marketing efforts efficiently.