Create New Sendinblue Subscribers from Google Sheets Using Pabbly Connect

Learn how to create new Sendinblue subscribers directly from Google Sheets using Pabbly Connect in this detailed step-by-step tutorial. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create new Sendinblue subscribers from Google Sheets, you will first need to access Pabbly Connect. Start by navigating to the Pabbly website and signing up for a free account. This integration allows you to automate the process of adding new contacts to Sendinblue whenever you input data into your Google Sheets.

After signing up, log into your Pabbly Connect account. From the dashboard, locate the option to access Pabbly Connect. Once inside, you will see the option to create a new workflow. This will be the foundation for your integration process.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a new workflow that connects Google Sheets and Sendinblue using Pabbly Connect. Click on the ‘Create Workflow’ button at the top right corner of the dashboard. A dialog box will prompt you to name your workflow; you can name it something like ‘Google Sheets to Sendinblue’.

• Select ‘Google Sheets’ as the trigger app.
• Choose the trigger event as ‘New Spreadsheet Row’.
• Click on the ‘Add-ons’ menu in Google Sheets to find Pabbly Connect Webhooks.

By setting up this workflow, you are enabling Pabbly Connect to monitor your Google Sheets for new entries. Once an entry is detected, it will trigger the action to create a new subscriber in Sendinblue.

3. Setting Up Google Sheets for Integration

Next, you need to prepare your Google Sheets for integration with Pabbly Connect. Open your Google Sheets document and ensure that the last data entry column is designated as the trigger column. This is typically the last column where you will input subscriber details.

Install the Pabbly Connect Webhooks add-on if you haven’t done so already. After installation, refresh your Google Sheets to ensure the add-on is active. Then, go back to the Add-ons menu, select Pabbly Connect Webhooks, and click on ‘Initial Setup’. Here, input the webhook URL provided by Pabbly Connect and set the trigger column to the last data entry column.

4. Creating Subscribers in Sendinblue

With your Google Sheets set up, the next step is to create new subscribers in Sendinblue using Pabbly Connect. You will select Sendinblue as the action app in your workflow. Choose the action event as ‘Create a Contact’. To establish this connection, you will need to input your Sendinblue API key.

• Access your Sendinblue account and find your API key under the SMTP & API section.
• Copy and paste the API key into the Pabbly Connect setup.
• Map the fields such as email, first name, and last name from your Google Sheets to Sendinblue.

Once all fields are mapped correctly, click on ‘Save and Send Test Request’. This action will create a new contact in your specified list within Sendinblue, confirming that the integration is successful.

5. Conclusion

In conclusion, using Pabbly Connect to create new Sendinblue subscribers from Google Sheets is a straightforward process. By following the steps outlined above, you can automate your subscriber management efficiently. This integration saves time and ensures that your email lists are always updated with new contacts.

With Pabbly Connect, you can seamlessly connect various applications and streamline your workflow. If you have any questions or need further assistance, feel free to reach out for support.