How to Create Brevo Contacts from Google Sheets Using Pabbly Connect

Learn how to create Brevo contacts from Google Sheets using Pabbly Connect. This step-by-step tutorial guides you through the integration process effortlessly. 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 Google Sheets and Brevo Integration

To create Brevo contacts from Google Sheets, you need to access Pabbly Connect. Start by opening your browser and searching for Pabbly Connect. Once on the landing page, new users should click on the ‘Sign Up for Free’ button to create an account. Existing users can simply sign in to access their dashboard.

After signing in, you will see all applications provided by Pabbly. Click on ‘Access Now’ for Pabbly Connect to reach the dashboard. Here, you can view all your workflows. To create a new workflow, click on the blue ‘Create Workflow’ button located in the top right corner.

2. Creating a Workflow in Pabbly Connect

When creating a workflow in Pabbly Connect, you will need to name it. For instance, you might name it ‘Create Brevo Contacts from Google Sheets’. After naming your workflow, click on ‘Create’. This will open two windows: one for the trigger and another for the action.

In this case, Google Sheets will be your trigger application. Select ‘New or Updated Spreadsheet Row’ as the trigger event. This means that whenever a new row is added to your Google Sheets, it will trigger the workflow in Pabbly Connect. To connect Google Sheets with Pabbly, you will need to copy the provided webhook URL and follow the instructions given in the interface.

• Go to your Google Sheets and enter the details of a contact.
• Navigate to Extensions > Add-ons > Get Add-ons to install the Pabbly Connect Webhooks add-on.
• Select the Pabbly Connect Webhooks option and click on ‘Initial Setup’.

After completing these steps, your Google Sheets will be connected to Pabbly Connect, allowing automatic responses to be captured whenever a new row is added.

3. Mapping Data from Google Sheets to Brevo

Once your Google Sheets is connected to Pabbly Connect, you will need to set up the action application, which is Brevo. Select Brevo as your action application and choose ‘Create or Update Contact’ as the action event. Click on ‘Connect’ and then select ‘Add New Connection’. You will need to enter your Brevo domain and API key.

To find your domain, simply check the URL of your Brevo account. For the API key, navigate to your Brevo account, go to the profile option in the top right corner, and select ‘SMTP and API Key’. Generate a new API key by clicking on the respective button and give it a name. Copy this API key and paste it into Pabbly Connect.

• Map the email and other contact details from the Google Sheets response to the corresponding fields in Brevo.
• Set the email blacklisted field to true if you don’t want to send emails to the contact.
• Select the appropriate list from Brevo where you want the new contacts to be added.

By mapping these details accurately, every new entry in your Google Sheets will create a corresponding contact in Brevo, ensuring that your workflow remains dynamic and efficient.

4. Testing the Workflow in Pabbly Connect

After setting up the mapping, it’s time to test your workflow in Pabbly Connect. Click on ‘Save and Send Test Request’ to check if a new contact is created in Brevo. If successful, you will receive a response that includes the contact ID, confirming that the integration is working as intended.

To validate this, go back to your Brevo account and check the specified list. You should see the newly created contact with the details you entered in Google Sheets. This confirms that your workflow has been set up correctly and is functioning as expected.

Before finalizing, make sure to adjust the settings in Google Sheets to send on events. This will ensure that every time a new row is added, the data is sent to Pabbly Connect automatically without needing manual intervention.

5. Finalizing the Google Sheets and Brevo Integration

To complete the integration process, return to your Google Sheets and navigate to Extensions > Pabbly Connect Webhooks. This time, select ‘Send on Events’. This will allow your Google Sheets to automatically send data to Pabbly Connect whenever a new row is added.

Now, add another row to your Google Sheets with new contact details. Once you do this, check your Brevo account again to see if the new contact has been added automatically. This step verifies that your integration is seamless and efficient, leveraging Pabbly Connect for automation.

By following these steps, you have successfully integrated Google Sheets with Brevo using Pabbly Connect. This automation saves time and enhances productivity by ensuring that all new contacts are created without manual input.

Conclusion

In this tutorial, we demonstrated how to create Brevo contacts from Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of adding contacts and enhance your workflow efficiency.