Integrating Google Ads Leads with Zoho CRM and Google Sheets Using Pabbly Connect

Learn how to automate your lead generation process by integrating Google Ads leads into Zoho CRM and Google Sheets using Pabbly Connect. Step-by-step guide included.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To start the automation process using Pabbly Connect, you need to access the platform. Begin by visiting the Pabbly Connect homepage by typing ‘Pabbly.com/connect’ in your browser. Once there, you will see options to sign in or sign up for free.

If you are a new user, click on the ‘Sign up for free’ button to create your account. Existing users can simply sign in. After creating your account, you will receive 100 free tasks per month, allowing you to explore the features of Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard. Here, you can view existing workflows or create a new one. Click on the ‘Create Workflow’ option. A dialog box will prompt you to name your workflow. You can name it ‘Add Google Ads Leads to Zoho CRM and Google Sheets’.

• Enter the workflow name.
• Select a folder to save the workflow.
• Click on ‘Create’ to proceed.

After creating the workflow, you will see two windows: one for the trigger and another for the action. The trigger will be Google Ads, and the action will be Zoho CRM and Google Sheets, allowing you to automate the entire process seamlessly using Pabbly Connect.

3. Setting Up Google Ads as Trigger in Pabbly Connect

In the trigger window, select Google Ads as the application. For the trigger event, choose ‘New Lead Form Entry’. This means that every time a new lead is generated via Google Ads, Pabbly Connect will capture this data and initiate the workflow.

Once you select the trigger event, a webhook URL will be generated. This URL will be used to connect your Google Ads account with Pabbly Connect. Copy this URL and go to your Google Ads account. In your lead form settings, find the option for lead delivery and set up webhook integration by pasting the copied URL.

4. Adding Leads to Zoho CRM via Pabbly Connect

After successfully setting up the trigger, the next step is to add the lead information to Zoho CRM. In the action window, choose Zoho CRM as the application and select ‘Insert or Update Record’ as the action event. Click ‘Connect’ to establish a connection.

You will need to enter your Zoho domain to connect the two applications. Once connected, you will map the lead details received from Google Ads to the corresponding fields in Zoho CRM. For example, map the first name, last name, email, and phone number.

• Select the leads module in Zoho CRM.
• Map the fields with the data received from Google Ads.
• Click on ‘Save and Send Test Request’ to ensure integration works.

Once the test request is successful, you will see the new lead created in your Zoho CRM, confirming that Pabbly Connect has effectively automated the process.

5. Recording Leads in Google Sheets Using Pabbly Connect

The final step is to record the lead information in Google Sheets. In the action window, select Google Sheets and choose ‘Add New Row’ as the action event. Click ‘Connect’ to create a new connection with your Google Sheets account.

After connecting, select the spreadsheet where you want to log the lead details. Map the fields such as first name, last name, email, and phone number just like you did for Zoho CRM. This ensures that every new lead captured from Google Ads will automatically create a new row in your Google Sheets.

Select the spreadsheet and sheet where data will be recorded. Map the lead details to the corresponding columns. Click ‘Save and Send Test Request’ to finalize the integration.

With this step completed, you will see that a new row has been added to your Google Sheets, confirming that Pabbly Connect has successfully recorded the lead information.

Conclusion

By following these steps, you can efficiently integrate Google Ads leads into Zoho CRM and Google Sheets using Pabbly Connect. This automation streamlines your lead generation process, ensuring that all leads are captured and organized without manual effort.