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

Automatically Add Google Ads Leads to Mailchimp & Track Them in Google Sheets

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating your Google Ads leads, first access Pabbly Connect by typing pabbly.com in your browser. This platform is essential for connecting Google Ads with Google Sheets and Mailchimp.

Once on the site, sign in to your existing account or create a new one. New users can take advantage of a free trial offering 100 tasks monthly. This allows you to explore all features of Pabbly Connect before committing to a subscription.

2. Creating a New Workflow in Pabbly Connect

After logging in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow, such as “Automatically Add Google Ads Leads to Mailchimp and Google Sheets,” and select a folder for better organization.

Click on ‘Create’ to initialize your workflow.
This opens a box where you must select a trigger application.
Choose ‘Google Ads’ as your trigger application.

Setting up this workflow in Pabbly Connect is crucial for automating lead capture from Google Ads to your desired applications.

3. Setting Up Trigger for Google Ads

In the workflow, select “New Lead Form Entry” as the trigger event for Google Ads. Click ‘Connect’ to establish a connection. A webhook URL will be generated, acting as a bridge between Google Ads and Pabbly Connect.

To complete this step, paste the webhook URL into your Google Ads lead form settings. This allows Google Ads to send lead data directly to Pabbly Connect whenever a new lead is generated.

4. Adding Leads to Google Sheets via Pabbly Connect

After confirming the connection with Google Ads, the next step is to add the lead details to Google Sheets. In your Pabbly Connect workflow, click on “Add New Action Step” and select Google Sheets as your action application.

Choose “Add New Row” as the action event.
Connect your Google account to allow access to your sheets.
Select the spreadsheet you created for Google Ads leads.

Mapping the lead details into the respective fields is vital for ensuring accurate data entry. Use the data received from Google Ads to fill in the first name, last name, email, and phone number in the corresponding fields in Google Sheets.

5. Adding Leads to Mailchimp with Pabbly Connect

The final step in the workflow is to add the captured leads as subscribers in Mailchimp. Again, click on “Add New Action Step” and search for Mailchimp. Select the “Add New Member with Custom Field” action event.

To connect Mailchimp, you’ll need to enter your API key and data center. This information can be found in your Mailchimp account settings. Once connected, map the lead details from Google Ads to the relevant fields in Mailchimp, such as email address, first name, and last name.

After setting everything up, hit ‘Save and Send Test Request’ to ensure the integration works effectively. If successful, the new lead will appear in your Mailchimp audience list, confirming that Pabbly Connect has successfully automated the process.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the integration of Google Ads leads into Google Sheets and Mailchimp. By following these steps, you can streamline your lead management process effectively.