How to Create Contacts in Brevo & Add Data to Google Sheets Using Pabbly Connect

Learn how to create contacts in Brevo and add data to Google Sheets using Pabbly Connect. Follow our detailed step-by-step tutorial for seamless integration. 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 to Start the Integration

To begin the process of creating contacts in Brevo and adding data to Google Sheets, you need to access Pabbly Connect. Start by navigating to the Pabbly Connect website in your browser. If you are a new user, click on ‘Sign up for free’ to create an account and receive 100 free tasks to explore the software.

Once you have created your account, log in to access the dashboard. Here, you will see all the workflows you have created. To initiate a new workflow, click on the ‘Create Workflow’ option located in the upper right corner of the dashboard. Give your workflow a suitable name, such as ‘Webhook to Google Sheets to Brevo’ and click on ‘Create’ to proceed.

2. Set Up Webhook Trigger in Pabbly Connect

The next step is to set up the trigger in Pabbly Connect. In this case, the trigger will be a webhook that captures responses from a form. Select ‘Webhook by Pabbly’ as your trigger application. Once selected, you will receive a webhook URL which you will need to copy.

Now, go to your form builder application, such as Jotform, and paste the webhook URL in the integration section of your form. This step ensures that whenever a new form response is submitted, it will be captured by Pabbly Connect. To test this, fill out your form with dummy data and submit it to see if the webhook response is captured successfully.

3. Add Data to Google Sheets from Webhook Response

After successfully capturing the webhook response, the next action is to add this data to Google Sheets using Pabbly Connect. Select ‘Google Sheets’ as your action application and choose the ‘Add New Row’ event. Connect your Google Sheets account by clicking on ‘Connect’ and then ‘Add New Connection’. Make sure you are logged into your Google account to facilitate a smooth connection.

• Select the spreadsheet where you want to add data.
• Map the fields from the webhook response to the corresponding columns in your Google Sheets.
• Click on ‘Save and Test Request’ to see if the data is successfully added.

Once you have mapped the fields and saved the request, check your Google Sheets to confirm that the data has been added correctly. This integration allows you to automatically update your spreadsheet with new form responses.

4. Create a New Contact in Brevo

Now that you have added the data to Google Sheets, the next step is to create a new contact in Brevo using the same response. In Pabbly Connect, add another action step and select ‘Brevo’ as your action application. Choose the ‘Create or Update Contact’ event and connect your Brevo account by entering your domain and API key.

To obtain your API key, log into your Brevo account and navigate to the SMTP and API section. Generate a new API key, name it, and copy it into Pabbly Connect when prompted. Map the necessary fields from the webhook response, such as email and name, to create the contact in Brevo. Finally, click on ‘Save and Send Test Request’ to ensure the contact is created successfully.

5. Filter Responses Based on Age Criteria

Before creating contacts in Brevo, it is essential to filter responses based on age. In Pabbly Connect, add a filter step to ensure that only respondents aged 18 and above are added as contacts. Select the filter condition to be based on the age field from the webhook response.

• Set the condition to check if the age is equal to or greater than 18.
• If the condition is met, the workflow will proceed to create a contact in Brevo.
• If the condition is not met, the workflow will stop, preventing the creation of an underage contact.

This filtering process ensures that only eligible contacts are created in Brevo, streamlining your contact management process.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to create contacts in Brevo and add data to Google Sheets from a webhook response. By following the steps outlined, you can efficiently automate the process of capturing form responses, updating your Google Sheets, and managing contacts in Brevo based on specific criteria. This integration not only saves time but also enhances your workflow efficiency.