Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To begin automating your Google Ads leads, you need to access Pabbly Connect. Start by visiting the Pabbly website and signing into your account. If you are a new user, you can sign up for free and get 100 tasks monthly to test the platform.

Once logged in, navigate to the Pabbly Connect app from the dashboard. Here, you can create and manage your workflows. Click on the “Create Workflow” button to start building your automation process. This is where you will set up the integration between Google Ads, Google Sheets, and Gmail.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a new workflow in Pabbly Connect. Click on the “Create Workflow” button and choose the new beta workflow builder. Name your workflow, for example, “Automate Google Ads Leads with Google Sheets and Gmail,” and select a folder for organization.

  • Click on the “Create” button to finalize your workflow setup.
  • Choose Google Ads as your trigger application.
  • Select “New Lead Form Entry” as the trigger event.

After selecting the trigger, you will receive a webhook URL from Pabbly Connect. This URL acts as a bridge between Google Ads and your workflow, allowing data to flow seamlessly. Make sure to copy this URL for the next steps.

3. Setting Up Google Ads with Pabbly Connect

Now, you need to integrate Google Ads with Pabbly Connect using the webhook URL. Open your Google Ads account and create a lead form. Ensure you include fields such as first name, last name, email, phone, city, and company name.

In the lead delivery section of your Google Ads form, paste the webhook URL from Pabbly Connect. After entering the URL, click on “Send Test Data” to verify the connection. This test will confirm that your Google Ads is correctly linked to Pabbly Connect.

  • Ensure the test data is sent successfully.
  • Check your Pabbly Connect workflow to see if the test data has been received.

Once you confirm the test data is received, your Google Ads integration is complete, and you can proceed to the next step.

4. Adding Lead Data to Google Sheets

The next step involves adding lead details to your Google Sheets using Pabbly Connect. Click on “Add New Action Step” and select Google Sheets as your action application. Choose “Add New Row” as the action event and connect your Google Sheets account.

After connecting, select the spreadsheet where you want to store the lead data. Use the mapping feature to fill in the fields with data from the Google Ads lead. This ensures that every time a new lead is captured, the information automatically populates the correct columns in your spreadsheet.

  • Select the spreadsheet and map the fields accordingly.
  • Click on “Save and Send Test Request” to see if the data is added successfully.

Once the test is successful, check your Google Sheets to ensure that the lead details have been added correctly. This step confirms that your data flow from Google Ads to Google Sheets is functioning as intended.

5. Sending Email Notifications via Gmail

Finally, set up email notifications for new leads using Gmail in Pabbly Connect. Click on “Add New Action Step” and choose Gmail as the action application. Select “Send Email” as the action event and connect your Gmail account.

In the email setup, you can map the recipient’s email address from the Google Ads data. Customize your email content to include a personal touch, such as addressing the lead by their first name. After filling in the necessary details, click on “Save and Send Test Request” to ensure the email is sent successfully.

  • Make sure to check for a successful email response.
  • Verify that the email arrives in your inbox as expected.

With this final step, your automation is complete. Now, every time you receive a new lead from Google Ads, it will be added to your Google Sheets, and an email notification will be sent automatically, all facilitated by Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate Google Ads leads using Pabbly Connect, integrating Google Sheets and Gmail for efficient lead management. This setup allows for seamless data tracking and communication, enhancing your business operations.