Using Ads API with Microsoft Flow / Power Automate

[Joe Evans]

I'm going to start this by saying I am not a professional developer.

My company uses Microsoft 365 for everything, and I am using Power Automate to automate a lot of processes. I've been successful implementing REST APIs into Power Automate using the built-in HTTP function. 

However, I can't even seem to get the ball rolling with implementing a REST call for the Ads API. All I want to do is use the Keyword Planning Service to get historical metrics on an array of keywords.

Currently the team is doing this manually by logging in, pasting the keywords they want, then pasting the results into Excel. 

From what I can see in the documentation, this could be automated with the API, but there doesn't seem to be a clear/easy starting point or accessible test environment that I've been able to find with just about every other API I've encountered. 

Has anyone had any success using a REST call to use the keyword planner?

[Google Ads API Forum Advisor Prod]

Hi Joe,

Thank you for posting your concern.

I am afraid that our team currently does not have a guide for implementing the generate historical metrics feature using the REST interface of the Google Ads API. However, I would suggest referring to this document as it presents the design and working details specific to the API's REST implementation, and other information that are needed to call the REST interface directly. Then you may apply the configuration of Keyword Planning discussed on this document to the implementation of your REST API.

Let me know if you have further questions.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2Fao5q:ref