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

How to Add Lead Details to Google Sheets in 5 Minutes

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the integration process, you need to access Pabbly Connect. If you are an existing user, simply open your workflow builder. For new users, visit pabbl.com/connect in your browser.

Once on the landing page, click on the ‘Sign up for free’ option in the top right corner. This allows you to explore Pabbly Connect with 100 free tasks each month, enabling you to add lead details to your Google Sheets without any cost.

2. Setting Up Your Workflow in Pabbly Connect

After accessing Pabbly Connect, the workflow builder is where you will configure your automation. Click on the ‘Add Trigger’ button to initiate your workflow.

For the trigger application, select Google Ads and choose the event as ‘New Lead Form Entry’. Click on ‘Connect’ to retrieve the webhook URL. You will then need to copy this URL and paste it into your Google Ads campaign’s lead delivery settings.

Open your Google Ads campaign.
Locate the lead delivery option.
Paste the webhook URL and click on ‘Send Test Data’.

Once the test data is sent, Pabbly Connect will capture the response, confirming that your integration is set up correctly.

3. Adding Lead Details to Google Sheets

Now that your trigger is set, the next step is to add the captured lead details into Google Sheets using Pabbly Connect. Click on ‘Add New Action Step’ and select Google Sheets as the action application.

For the event, choose ‘Add New Row’. 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 necessary permissions.

Select the spreadsheet named “New Lead Details”.
Choose the sheet named “Details”.
Map the lead details dynamically from the previous step.

Mapping allows Pabbly Connect to insert data from the trigger automatically, ensuring that your Google Sheets updates with each new lead.

4. Testing the Integration in Pabbly Connect

After mapping the fields, click on ‘Save and Send Test Request’ in Pabbly Connect. This action tests the connection and adds the lead details to your Google Sheets.

Once the test is successful, check your Google Sheets to verify that the details such as name, email, phone number, and city have been added correctly. This confirms that the integration is functioning as intended.

Remember, for this automation to work, your Google Ads campaign must be in live mode. If it’s in draft mode, new leads will not trigger the process.

Conclusion

In this tutorial, we demonstrated how to integrate Google Ads with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of capturing lead details seamlessly. Enjoy the benefits of automation with Pabbly Connect and streamline your workflow effectively.