Integrate Sendinblue with Google Sheets Using Pabbly Connect

Learn how to automate the process of saving Sendinblue contact details to Google Sheets using Pabbly Connect with this step-by-step tutorial. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Overview of Pabbly Connect for Integration

Pabbly Connect is an automation platform that allows users to integrate various applications seamlessly. In this tutorial, we will use Pabbly Connect to save Sendinblue contact details directly into Google Sheets. This integration automates the process of transferring contact information, making it efficient and error-free.

To get started, navigate to the Pabbly Connect website and create an account. Once logged in, you can access the dashboard, where you will set up the workflow for this integration.

2. Creating a Workflow in Pabbly Connect

To create the workflow, click on the plus sign and select ‘Create Workflow.’ Name your workflow, for example, ‘Save Sendinblue Contact Details to Google Sheets.’ This will help you identify the integration later. Once named, click on the ‘Create’ button.

• Choose the trigger application as Sendinblue.
• Select the trigger event as ‘New Contact Added to a List.’
• Copy the webhook URL provided by Pabbly Connect.

Next, follow the instructions to set up the webhook in your Sendinblue account. This involves logging into Sendinblue, navigating to the settings, and adding a new webhook with the URL you copied. Make sure to select the option for when a contact is added to a list.

3. Capturing Contact Details from Sendinblue

After setting up the webhook, return to Pabbly Connect. You will see that it is waiting for a response. To capture the contact details, add a new contact in your Sendinblue account. Fill in the required fields such as email, first name, last name, and mobile number, and select a list to add the contact to.

Once the contact is added, Pabbly Connect will capture the response. You will see the email address and other details like the list ID and created date. However, to retrieve additional contact details, you need to set up another action step.

• Select Sendinblue again as the action application.
• Choose the action event ‘Get Contact Information.’
• Connect using the existing connection.

This step allows you to retrieve the complete contact details, which you will then map to Google Sheets in the next section.

4. Adding Contact Details to Google Sheets

Now that you have the contact details, it’s time to send this information to Google Sheets. In Pabbly Connect, add another action step and select Google Sheets as the application. Choose the action event ‘Add New Row’.

Connect your Google account and select the specific spreadsheet and sheet where you want the contact details to be stored. Map the fields such as first name, last name, email address, mobile number, and the list name to the respective columns in Google Sheets.

Map the first name and last name from the retrieved contact information. Include the email address and mobile number. Add the list name using the lookup table feature in Pabbly Connect.

Once all fields are mapped, click on ‘Save and Send Test Request’ to ensure the data is correctly sent to Google Sheets. Check your Google Sheets to confirm that the contact details have been added successfully.

5. Testing the Integration in Real-Time

After setting up your workflow, it’s essential to test the integration to ensure it works as intended. Go back to your Sendinblue account and add another new contact. Fill out the details just like before, ensuring it’s added to the same list.

Once the contact is saved, check your Google Sheets again. You should see the new contact details populated automatically. This confirms that the integration between Sendinblue and Google Sheets via Pabbly Connect is functioning correctly.

If everything looks good, remember to save your workflow in Pabbly Connect. This way, you can automate the process of saving contact details to Google Sheets every time a new contact is added in Sendinblue.

Conclusion

This tutorial demonstrated how to effectively use Pabbly Connect to automate the saving of Sendinblue contact details to Google Sheets. By following these steps, you can streamline your contact management process, ensuring that all new contacts are automatically recorded in your Google Sheets.

With Pabbly Connect, you can integrate multiple applications and enhance your workflow efficiency without any coding skills. Start automating today to save time and reduce errors!