Integrate Sendinblue with Google Sheets Using Pabbly Connect: A Step-by-Step Guide

Learn how to integrate Sendinblue with Google Sheets using Pabbly Connect. Follow this step-by-step tutorial to automate your email marketing campaigns. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To start integrating Sendinblue with Google Sheets, first access Pabbly Connect. Open your web browser and type in the Pabbly Connect URL. This tool allows you to automate workflows without coding.

Once on the site, navigate to the products section and select Pabbly Connect. Click on the ‘Sign In’ button to access your dashboard. If you don’t have an account, you can create one for free in just a few minutes.

2. Create a Workflow in Pabbly Connect

After signing into Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button. A dialog box will appear asking for a workflow name. Enter ‘Sendinblue to Google Sheets’ and click on ‘Create’.

This will open the trigger window. Here, choose the app as Sendinblue and select the trigger event as ‘New Contact Added to a List’. This trigger will initiate the process whenever a new contact is added to your Sendinblue account.

3. Configure Sendinblue Settings

To configure Sendinblue, navigate to your Sendinblue account settings. Click on ‘Settings’ and locate the ‘Webhooks’ option. Click on ‘Configure’ and then select ‘Add a New Webhook’.

In the dialog box that appears, you will need to enter the webhook URL provided by Pabbly Connect. This URL allows Sendinblue to send data to Pabbly Connect when a new contact is added. Choose the event ‘Added to a List’ and click on ‘Add’ to save your settings.

4. Capture Data from Sendinblue

With the webhook configured, return to Pabbly Connect and click on the ‘Capture Webhook Response’ button. This will allow Pabbly Connect to wait for data from Sendinblue. Now, create a dummy contact in Sendinblue to test the integration.

Navigate to the ‘Contacts’ section in Sendinblue, click on ‘Add a Contact’, and fill in the required details. After saving the contact, Pabbly Connect should capture the data, confirming that the integration is successful.

• Navigate to Sendinblue and click on ‘Add a Contact’.
• Enter the contact details and save.
• Check Pabbly Connect to see if the data is captured.

Once the data is captured, you can proceed to the next step of sending this information to Google Sheets.

5. Send Data to Google Sheets

To send the captured data to Google Sheets, click the plus button in Pabbly Connect to add an action. Select Google Sheets as the app and choose the action event ‘Add New Row’.

Connect your Google Sheets account by selecting ‘Connect with Google Sheets’. Choose the appropriate account and authorize Pabbly Connect to access your Google Sheets. Select the specific sheet where you want the data to be added and map the fields accordingly.

• Select the Google Sheets account to connect.
• Map the fields such as email, ID, list, and date created.
• Click on ‘Save and Send Test Request’ to verify.

Check your Google Sheets to confirm that the data appears correctly, ensuring that the integration is functioning perfectly.

Conclusion

In this tutorial, we’ve demonstrated how to use Pabbly Connect to integrate Sendinblue with Google Sheets seamlessly. By following these steps, you can automate your email marketing processes efficiently.