How to Add Google Ads Leads to Zoho Sheet Automatically

Learn how to automatically add Google Ads leads to Zoho Sheet using Pabbly Connect with this step-by-step tutorial. Streamline your lead management process now! Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Ads and Zoho Integration

To start adding Google Ads leads to Zoho Sheet automatically, you need to access Pabbly Connect. If you are an existing user, simply log in to your Pabbly Connect account. For new users, open a new tab and search for pabbl.com/connect to reach the Pabbly Connect landing page.

Once on the landing page, click on the ‘Sign Up for Free’ button at the top right corner. This will give you access to hundreds of free tasks each month, allowing you to explore the capabilities of Pabbly Connect. After signing up, log into your account and open the workflow builder to begin the integration process.

2. Setting Up the Trigger for Google Ads Leads

The next step involves setting up a trigger in Pabbly Connect. Click on the ‘Add Trigger’ button and search for ‘Google Ads’. Select it and choose the event as ‘New Lead Form Entry’. Once selected, click on the ‘Connect’ button.

• Search for Google Ads in the trigger application.
• Select ‘New Lead Form Entry’ as the event.
• Click on ‘Connect’ to proceed.

After clicking connect, you will receive a webhook URL. Copy this URL and head over to your Google Ads account. In your Google Ads account, find the lead form you are using and scroll down to locate the ‘Lead Delivery’ option. Here, paste the copied webhook URL into the designated field and click on ‘Send Test Data’ to ensure the connection works properly.

3. Capturing Lead Data from Google Ads

Once you have sent the test data, return to Pabbly Connect to verify that the lead data has been captured successfully. You should see fields like first name, last name, email, phone number, and company name populated with the test data you just sent.

If you’re running a live campaign, you can capture real lead details as they come in. However, for testing purposes, using the test lead data is perfectly fine. You can also click on ‘Recapture Webhook Response’ if you want to fetch real-time leads later on.

4. Adding Google Ads Leads to Zoho Sheet Automatically

Now that you have set up the trigger, it’s time to add the lead details into Zoho Sheet using Pabbly Connect. Click on the ‘Add New Action Step’ and search for ‘Zoho Sheets’. Select it and choose the event as ‘Create Row’. Then click on ‘Connect’.

• Select ‘Create Row’ as the action event.
• Connect your Zoho Sheets account to Pabbly Connect.
• Map the fields from the Google Ads lead to Zoho Sheet.

If you have a previous connection, you can select it, or otherwise, create a new connection by entering your Zoho domain. You can find this domain in the URL of your Zoho Sheet. After entering the domain, click on ‘Save’ and grant necessary permissions to Pabbly Connect.

5. Mapping Lead Details to Zoho Sheet

After connecting to Zoho Sheet, you will need to select the specific workbook and worksheet where you want to add the lead details. Click on ‘Refresh Fields’ to load your workbooks and worksheets. Once loaded, select the appropriate ones. using Pabbly Connect

Now, map the fields from the Google Ads lead data to the corresponding columns in your Zoho Sheet. Mapping allows you to insert dynamic data, ensuring that every new lead updates automatically in the sheet.

After mapping all required fields such as first name, last name, email, and phone number, click on ‘Save and Send Test Request’. You should receive a confirmation that the details have been successfully added to your Zoho Sheet. Now every time a new lead comes in from Google Ads, the details will be automatically updated in Zoho Sheets without any manual intervention.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding Google Ads leads to Zoho Sheet. By following these steps, you can streamline your lead management and ensure that your data is always up to date.