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

Learn how to automate adding subscribers to Sendy from Google Sheets using Pabbly Connect. Follow our detailed tutorial for seamless integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Sendy, first access Pabbly Connect by visiting the official website. You can do this by entering the URL Pabbly.com/connect in your browser. Upon reaching the homepage, you will see options to sign in or sign up for free.

If you are a new user, click on the ‘Sign up for free’ button to create your account. Existing users can simply sign in. Pabbly Connect offers 100 free tasks every month, allowing you to explore its features and capabilities for automating various tasks.

2. Creating a Workflow in Pabbly Connect

Once you are logged into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button located at the top right corner. A dialog box will appear prompting you to name your workflow.

For this integration, name your workflow ‘Create Sendy Subscriber with Custom Fields from Google Sheets’ and choose a folder to save it in, such as ‘Test Integrations.’ After naming, click on ‘Create’ to proceed. This opens two windows for setting up the trigger and action for your automation.

3. Setting Up the Trigger with Google Sheets

In the trigger window, select Google Sheets as your application. The trigger event should be set to ‘New or Updated Spreadsheet Row.’ This ensures that every time a new row is added to your Google Sheet, the automation will trigger.

After selecting the trigger event, you will receive a webhook URL. Copy this URL, as you will need it for connecting Google Sheets to Pabbly Connect. Go to your Google Sheet, click on Extensions, then Add-ons, and select ‘Get Add-ons.’ Search for ‘Pabbly Connect Webhooks’ and install it if you haven’t done so already.

• Install the Pabbly Connect Webhooks add-on.
• Open the add-on and go to Initial Setup.
• Paste the copied webhook URL and set the trigger column to the last data entry column.

After completing the setup, send a test to ensure the connection is established successfully. Once confirmed, you will see the response details in Pabbly Connect, including subscriber information.

4. Setting Up the Action with Sendy

Now that your trigger is set, it’s time to configure the action. In the action window, select Sendy as your application and choose the action event ‘Add Subscriber.’ Click on connect and select ‘Add New Connection’ to establish a connection with your Sendy account.

You will need to provide your Sendy URL and API key. To find these details, log into your Sendy account, copy the URL up to Sendy, and ensure no trailing slash is included. Then, go to the settings section in Sendy to retrieve your API key and paste it into Pabbly Connect.

• Enter the Sendy URL without a trailing slash.
• Paste the API key from your Sendy account.
• Click on Save to connect.

Once connected, map the fields from the Google Sheets response to Sendy, including subscriber name, email, country code, and custom fields such as mobile number. This mapping ensures that each new subscriber is added with the correct information.

5. Testing the Integration

After setting up the action, it’s crucial to test the integration to ensure everything works seamlessly. Click on ‘Send Test Request’ in Pabbly Connect to verify that the subscriber is added correctly in Sendy. Once you receive a positive response, check your Sendy account to confirm the new subscriber is listed.

To finalize the integration, go back to your Google Sheets, click on Extensions, and select ‘Send on Events’ from the Pabbly Connect add-on. This ensures that every time a new row is added, the data will be sent to Pabbly Connect automatically.

Test the integration by adding a new subscriber’s details in your Google Sheet, and check Sendy to see if the new subscriber appears with all the mapped information. This confirms that your automation is working as intended.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the process of adding subscribers from Google Sheets to Sendy. By following these steps, you can efficiently manage your subscriber list with custom fields, enhancing your email marketing efforts.