Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating the creation of Google Contacts from Google Forms, you need to access Pabbly Connect. Begin by navigating to the Pabbly Connect homepage at pabbly.com/connect.

Once on the homepage, you have two options: sign in if you are an existing user or sign up for free if you are new. Signing up gives you access to 100 free tasks each month to explore the platform.

2. Setting Up Google Forms Integration in Pabbly Connect

After logging into Pabbly Connect, you will create a new workflow. Start by selecting Google Forms as your trigger application. This allows you to capture responses from your form.

  • Select “New Response Received” as the app event.
  • Click the “Connect” button to generate a Webhook URL.
  • Copy the generated Webhook URL for the next steps.

This Webhook URL acts as a bridge between Google Forms and Pabbly Connect, ensuring that all responses are captured automatically.

3. Configuring Google Sheet with Webhook URL

Next, you need to configure the Google Sheet connected to your Google Form. This is essential for capturing the form responses in real-time using Pabbly Connect.

Open your Google Sheet linked to the form and navigate to Extensions > Add-ons > Get add-ons. Search for “Pabbly Connect Webhooks” and install it if you haven’t already.

  • Once installed, go back to Extensions and select “Pabbly Connect Webhooks”.
  • Click on “Initial Setup” to enter the copied Webhook URL.
  • Set the trigger column to the last data column, usually column E.

After submitting the setup, your Google Sheet will be ready to send data to Pabbly Connect whenever a new form response is submitted.

4. Testing the Integration with Sample Data

With the setup complete, it’s time to test the integration. Fill out your Google Form with sample data, including first name, last name, email, and phone number.

After submitting the form, return to Pabbly Connect to send test data. This will confirm that the integration is working correctly.

  • Copy the Google Form URL and paste it in a new tab.
  • Fill in the required fields and submit the form.
  • Check your Google Sheet to verify that the data appears correctly.

Once the test data is received, you can see the response in Pabbly Connect, confirming that the integration is functioning as intended.

5. Creating Google Contacts from Google Forms Leads

Now that you have successfully tested the integration, it’s time to create Google Contacts automatically from the form submissions. In Pabbly Connect, add Google Contacts as your action application.

Select “Create Contact” as the action event. You will then need to connect to your Google account to allow Pabbly Connect access to create contacts.

  • Map the fields from the Google Form response to the Google Contacts fields.
  • Ensure that all required fields are filled for the contact creation.
  • Save and test the action to verify that the contact is created successfully.

After refreshing your Google Contacts, you should see the new contact created from your Google Form submission, demonstrating the power of Pabbly Connect in automating this process.

Conclusion

This tutorial has shown you how to automate the creation of Google Contacts from Google Forms submissions using Pabbly Connect. By following these steps, you can streamline your workflow and save time on manual data entry.

Utilizing Pabbly Connect allows for seamless integration between applications, making it easier to manage your contacts effectively.