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

Save Google Ads Leads to Google Sheets Automatically

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start automating your Google Ads leads, first access Pabbly Connect. Open your browser and go to the Pabbly Connect landing page by entering pabbl.com/connect. If you are new, click on the “Sign Up for Free” button.

This free trial allows you to integrate up to 100 Google Ads leads into your spreadsheet each month. After testing, you can decide on a subscription plan that suits your needs.

2. Creating a Workflow in Pabbly Connect

Once logged in, click on the “Create Workflow” button to begin. This opens the workflow builder where you will set up the automation. Click on the “Add Trigger” button and select Google Ads as your trigger application.

Choose “New Lead Form Entry” as the event.
Click on “Connect” to receive your webhook URL.
Copy this URL for use in your Google Ads campaign.

Now, navigate to your Google Ads campaign and paste the webhook URL in the lead delivery section. This connects Google Ads with Pabbly Connect.

3. Setting Up Google Ads to Capture Leads

In your Google Ads campaign, ensure you have created a lead form to collect necessary details. This includes fields like name, email, phone number, and city. Make sure to add this lead form to your campaign.

Click on the “Add Lead Forms” button to select the fields you want.
Ensure the lead delivery section is set up correctly with the webhook URL.

Once these steps are completed, you can test the connection by sending test data. This confirms that your Google Ads leads are now integrated with Pabbly Connect.

4. Adding Google Sheets to Your Workflow

Next, you will add Google Sheets as an action application in your workflow. Click on “Add New Action Step” and select Google Sheets. For the event, choose “Add New Row” and click on “Connect”.

If you have previously connected Google Sheets to Pabbly Connect, select the existing connection. Otherwise, create a new connection by signing in with your Google account and granting the necessary permissions.

5. Mapping Lead Data to Google Sheets

After connecting Google Sheets, select the specific spreadsheet and sheet where you want to save the lead data. Use the mapping feature in Pabbly Connect to insert data dynamically from the previous step.

Map fields like first name, last name, email, phone number, and city.
Ensure you save and send a test request to confirm the data is added.

Once confirmed, your workflow is set. Now, every time a new lead is generated, their details will automatically populate in your Google Sheets, streamlining your lead management process.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the integration of Google Ads leads into Google Sheets. By following these steps, you can ensure that no lead gets missed, allowing your sales team to respond promptly and efficiently.