Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

I Added Bulk Contacts to Brevo Using Google Sheets 😱

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Sheets and Brevo Integration

To begin integrating Google Sheets with Brevo, first, access Pabbly Connect by visiting pabby.com/connect. This platform allows you to automate workflows seamlessly.

If you’re new to Pabbly Connect, you can sign up for free and receive 100 tasks to experiment with. This is a great way to test the integration before committing to a paid plan.

2. Creating Your Workflow Using Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard and select the “Create Workflow” option. Here, you can use the AI feature to generate a workflow by entering your prompt.

For this integration, type “add contacts to Brevo from Google Sheets”. The AI will analyze your request and create a workflow that automatically adds new or updated rows from Google Sheets into your Brevo account.

3. Setting Up the Trigger in Google Sheets

To connect Google Sheets with Pabbly Connect, copy the webhook URL provided in the workflow. Open your Google Sheets, go to Extensions, and select Add-ons to find the Pabbly Connect Webhooks app.

Install the Pabbly Connect Webhooks add-on.
Refresh your spreadsheet after installation.
Set up the initial webhook with the copied URL and specify your trigger column.

Make sure the trigger column is where the final data is added, as this will send the entire row data to Pabbly Connect. Click submit once done.

4. Connecting Brevo to Pabbly Connect

Next, set up the connection to Brevo in Pabbly Connect. Click the connect button and create a new connection by entering your API key from Brevo.

To obtain your API key, go to Brevo’s API section and create a new key. After generating it, copy and paste it into Pabbly Connect. This will link your Brevo account to the workflow.

5. Bulk Adding Contacts from Google Sheets to Brevo

After setting up the workflow, you can easily add multiple contacts to Brevo without repeating the setup process. Simply go back to the Google Sheets add-on and select the option to send all data.

This will process each lead one by one.
You will see each contact being created in Brevo automatically.

This automation saves you time and ensures all leads are captured accurately in your Brevo account.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate adding contacts from Google Sheets to Brevo. This integration streamlines your workflow and enhances efficiency in managing your leads.