How to Automate Daily Google Ads Call Reports to Google Sheets Using Pabbly Connect?

[hrishikumar]

Hi, I am looking to set up an automation in Pabbly Connect to fetch daily call report details from Google Ads and update them in Google Sheets automatically.



Here’s what I want to achieve:

1. Fetch the following call details:

• Campaign Name

• Ad Group Name

• Keyword triggering the call

• Caller Number

• Call Duration

2. Store this data in a Google Sheet that updates daily.



The issue I’m facing:

• In Pabbly Connect, I can’t find a direct trigger to fetch Google Ads call report data.

• I’ve considered using Schedule as the trigger, but I’m unsure how to configure the action with Google Ads to pull the required data.

• I know Google Ads API might be required, but I’m not sure how to set it up in Pabbly to fetch these details.



Can someone guide me step-by-step on how to:

1. Use Google Ads API to fetch call data.

2. Configure Pabbly Connect to automate the process.

3. Map the fetched data into Google Sheets.

 

[ArshilAhmad]

Hi @hrishikumar,

Currently, we do not have an action event for Google Ads that can fetch call report data from Google Ads. If you would like this action event to be added to the Google Ads application, you can submit your request on our dedicated platform:
https://pabbly.featureos.app/b/Update-Existing-Application

Our integrations team will review your request and, if feasible, add the desired action event to Google Ads.

In the meantime, you can contact Google Ads support to check if they provide an endpoint that could help you with this. If they do, please share the endpoint with us, and we will assist you in setting it up in Pabbly Connect.

 

[hrishikumar]

Hi @ArshilAhmad. Thanks for your response.

I have submitted the request for the new action event from the link you shared, please note that I have no idea about what is endpoint and how do they work, so I feel helpless in getting that for you.

I am looking forward to get this action event asap.

Thanks,
Hrishi.