How to Create Brevo Contact on Google Forms Submission Using Pabbly Connect

Learn how to integrate Google Forms with Brevo using Pabbly Connect to automate contact creation with step-by-step instructions. 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. Accessing Pabbly Connect for Google Forms Integration

To create Brevo contacts on Google Forms submission, you first need to access Pabbly Connect. Start by navigating to the Pabbly Connect homepage by typing the URL in your browser. Here, you can either sign in if you are an existing user or sign up for a free account if you are new.

Once logged in, you will be directed to the dashboard where you can create new workflows. Pabbly Connect allows you to automate tasks between Google Forms and Brevo without any coding skills. This integration will enable automatic contact creation in Brevo whenever a new form submission occurs.

2. Creating a Workflow in Pabbly Connect

In this section, we will create a workflow that connects Google Forms with Brevo using Pabbly Connect. Click on the ‘Create Workflow’ button on your dashboard. You will be prompted to name your workflow; for this example, name it ‘Create Brevo Contact on Google Form Submission’.

After naming your workflow, select a folder to organize your automations. You can create a specific folder for lead management. Once you have set this up, click on ‘Create’ to proceed. This will open a blank workflow interface with two sections: Trigger and Action.

• Select Google Forms as the trigger application.
• Choose the trigger event ‘New Response Received’.
• Copy the webhook URL provided by Pabbly Connect.

These steps will set the foundation for your automation, ensuring that every new submission in Google Forms is captured by Pabbly Connect.

3. Setting Up Google Forms to Capture Responses

To connect Google Forms to Pabbly Connect, you must insert the copied webhook URL into your Google Form. Open your Google Form and navigate to the Responses section. Click on ‘View in Sheets’ to link your form with a Google Sheet, creating a new sheet if necessary.

Once your sheet is set up, you will see columns corresponding to the fields in your form, such as Name, Email, Phone Number, and Inquiry Type. After capturing a response in Google Sheets, you need to set up the Pabbly Connect Webhooks add-on to send this data back to Pabbly Connect.

• Install the Pabbly Connect Webhooks add-on from Google Workspace Marketplace.
• Configure the initial setup by pasting the webhook URL in the designated field.
• Set the trigger column to the last column of your responses, typically column E.

This setup ensures that every time a new form is submitted, the response is automatically sent to Pabbly Connect for further processing.

4. Connecting Brevo to Pabbly Connect

After successfully capturing responses in Google Sheets, the next step is to connect Brevo to Pabbly Connect. In the Action section of your workflow, select Brevo as the action application. Choose the action event ‘Create or Update a Contact’ to add new contacts based on the Google Forms submissions.

To establish this connection, you will need to enter your Brevo account domain and API key. You can generate a new API key by logging into your Brevo account and navigating to the SMTP and API page. Once you have your API key, paste it into the Pabbly Connect interface.

Map the email field from the Google Sheets response to the Brevo contact email. Select the appropriate list in Brevo for new inquiries. Split the full name into first and last names using the Text Formatter in Pabbly Connect.

This step ensures that every new lead captured in Google Forms is added as a contact in Brevo, streamlining your lead management process.

5. Testing the Automation Workflow

Once the connections are established, it’s crucial to test the automation you’ve set up using Pabbly Connect. To do this, submit a new entry through your Google Form. After submission, check your Google Sheets to confirm that the response has been recorded correctly.

Next, log into your Brevo account to verify that the new contact has been added to your selected list. This end-to-end test will confirm that your automation is functioning correctly and that leads are being captured seamlessly.

Submit the form with different lead details to test the workflow. Check Google Sheets for the new entry and Brevo for the new contact.

By following these steps, you will have successfully automated the process of creating Brevo contacts from Google Forms submissions using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the creation of Brevo contacts from Google Forms submissions. By following the step-by-step instructions, you can streamline your lead management process and enhance your marketing efforts.