Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start integrating Google Ads with your CRM and Google Sheets, you need to access Pabbly Connect. If you are a new user, open a new tab and search for pabbl.com/connect in your browser. This will take you to the landing page of Pabbly Connect.

Once on the landing page, you will see the option to “Sign up for free” in the top right corner. Click this button to create an account and get 100 free tasks each month to explore Pabbly Connect. This allows you to set up your automation without any initial cost.

2. Setting Up Your Workflow in Pabbly Connect

After signing into Pabbly Connect, navigate to the workflow builder. This is where you will set up the automation process. The workflow consists of triggers and actions, where a trigger starts the process and actions are the results.

To create your workflow, click on the “Add Trigger” button. For the trigger application, select the application you are using to collect lead details, such as Google Ads. Choose the event as “New Lead Form Entry” and click on “Connect”. You will then be provided with a webhook URL that you need to copy for later use.

  • Click on “Add Trigger”.
  • Select Google Ads as the trigger application.
  • Choose “New Lead Form Entry” as the event.

Now, paste the copied webhook URL into your Google Ads lead form settings under the lead delivery section. Test the connection by sending test data. If successful, you will see the captured response in your Pabbly Connect workflow, confirming the integration.

3. Capturing Lead Details in Google Sheets

Once you have connected Google Ads with Pabbly Connect, the next step is to capture the lead details into Google Sheets. Click on “Add New Action Step” and select Google Sheets as the action application. Choose the event as “Add New Row” and click on “Connect”.

If you have an existing connection, select it; otherwise, create a new one by signing in with your Google account. Grant the necessary permissions and then select the spreadsheet and sheet where you want the lead details to be added. Instead of manually entering the lead details, utilize the mapping feature in Pabbly Connect to automatically insert data from the previous step.

  • Select Google Sheets as the action application.
  • Choose “Add New Row” as the event.
  • Map the lead details to the corresponding fields in your spreadsheet.

After mapping the details, click on “Save and Send Test Request”. If successful, you will see the lead details added to your Google Sheets. From now on, every new lead from Google Ads will automatically populate in your spreadsheet.

4. Adding Leads to Your CRM Using Pabbly Connect

Next, you will set up the integration to add leads to your CRM. Click on “Add New Action Step” again, and this time select your CRM application, such as Zoho CRM. Choose the event “Create Contact” and click on “Connect”.

If you haven’t created a connection yet, you will need to input your Zoho CRM domain. This can be found in your Zoho account URL. After entering the domain, grant the necessary permissions to Pabbly Connect. Then, map the lead details just as you did for Google Sheets. Ensure you include all required fields for creating a contact.

  • Select Zoho CRM as the action application.
  • Choose “Create Contact” as the event.
  • Map the necessary lead details to the contact fields.

After mapping, click on “Save and Send Test Request”. You should receive a confirmation that a new contact has been created in your Zoho CRM. Now, every time a new lead is captured from Google Ads, their details will be automatically added to both Google Sheets and your CRM.

5. Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to integrate Google Ads with your CRM and Google Sheets. By following the steps outlined, you can automate the process of capturing lead details efficiently. With Pabbly Connect, you can streamline your workflow and ensure that your leads are organized and easily accessible.

Try this automation today and enhance your lead management process with Pabbly Connect. You’ll save time and reduce manual data entry, allowing you to focus on growing your business.