Integrate Google Ads Leads to HubSpot & Google Sheets with Pabbly Connect

Learn how to automate the integration of Google Ads leads into HubSpot and Google Sheets using Pabbly Connect for efficient lead generation. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate the integration of Google Ads leads into HubSpot and Google Sheets, access Pabbly Connect by visiting its homepage. You can do this by typing Pabbly.com/connect in your browser. Once on the site, 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. On signing up, you will receive 100 free tasks every month, allowing you to explore the features of Pabbly Connect. Existing users can simply sign in to access the dashboard where they can create and manage workflows.

2. Creating a Workflow in Pabbly Connect

After signing in, you will be directed to the dashboard of Pabbly Connect. Here, you can manage existing workflows or create a new one. To create a new workflow, click on the ‘Create Workflow’ button located in the top right corner.

• Provide a name for the workflow, such as ‘Add Google Ads Leads to HubSpot CRM and Google Sheets’.
• Select the folder where you want to save the workflow.
• Click on ‘Create’ to initiate the workflow setup.

Once created, you will see windows for setting the trigger and action. The trigger will be Google Ads, and the actions will include HubSpot CRM and Google Sheets. This setup allows you to automate the process of adding leads seamlessly using Pabbly Connect.

3. Setting Up Google Ads as a Trigger

To set up the trigger, select Google Ads as the application in Pabbly Connect. Choose the trigger event as ‘New Lead Form Entry’. This event will activate the workflow whenever a new lead is generated through your Google Ads lead form.

Upon selecting the trigger event, a webhook URL will be provided. This URL is crucial for connecting Google Ads with Pabbly Connect. Copy the webhook URL and navigate to your Google Ads account. In your lead form settings, find the ‘Lead Delivery’ section to paste the webhook URL under ‘Webhook Integration’.

• Paste the webhook URL in the designated field.
• Enter the key from the URL, which is the last part of the webhook URL.
• Click on ‘Send Test Data’ to ensure the connection works.

After sending the test data, check Pabbly Connect to confirm that the lead details have been successfully captured. This indicates that the integration between Google Ads and Pabbly Connect is successful.

4. Adding Leads to HubSpot CRM

Next, you will set up HubSpot CRM as an action in your workflow. Select HubSpot CRM in Pabbly Connect and choose the action event as ‘Create a Contact’. Click on ‘Connect’ to establish a new connection with your HubSpot account.

After successful authorization, you will need to map the lead details from the Google Ads response to the corresponding fields in HubSpot CRM. This includes first name, last name, email, and contact number. Use the mapping feature in Pabbly Connect to ensure that the data flows correctly from Google Ads to HubSpot.

Map the first name from the Google Ads response. Map the last name similarly. Continue mapping email and contact number.

Once all fields are mapped, click on ‘Save and Send Test Request’ to add the contact to HubSpot CRM. Upon successful creation, you will see the new contact reflecting in your HubSpot account.

5. Adding Leads to Google Sheets

For the final action, you will integrate Google Sheets to log the lead details. In Pabbly Connect, select Google Sheets as the action application and choose ‘Add New Row’ as the action event. Click on ‘Connect’ to authorize your Google Sheets account.

Once connected, you will need to specify the spreadsheet name and the sheet where the data will be added. Map the lead details from the Google Ads response to the relevant columns in your Google Sheet, such as first name, last name, email, and contact number.

Select your spreadsheet named ‘Google Ads Leads’. Choose ‘Sheet1’ for the data entry. Map all required fields from the Google Ads response.

After mapping, click on ‘Save and Send Test Request’. Check your Google Sheets to confirm that a new row has been added with the lead details. This completes the integration process, ensuring that every new lead from Google Ads is logged both in HubSpot and Google Sheets automatically.

Conclusion

Integrating Google Ads leads into HubSpot and Google Sheets using Pabbly Connect streamlines your lead generation process. This automation allows for efficient data management without manual input, enhancing productivity and organization.