Showing results for 
Search instead for 
Did you mean: 
Responsive Resident
Responsive Resident

How to authenticate Google Sheets API using OAuth 2.0 from Power Automate?

I am new to Google Suit. As part of a requirement, we are trying to access Google Sheets from Microsoft Flows (Power Automate) using HTTP call. I have the details to access Google Sheets API such as client_id, client_secret and redirect_uri. It would be if any thoughts on the approach to achieve the authentication with the above details.

Scenario: We have some Google Sheets which holds data to be READ and WRITE Back.

I have tried calling Google Token API with below details, but getting an error

Error 400: invalid_request Required parameter is missing: response_type

Our main goal is to bypass user consent and authenticate Google APIs using client id and secret and perform the required actions on the data.

Steps performed to authenticate the Google API

Method: Get
"client_id": "",

"redirect_uri": "",

"response_type": "code",

"scope": "",

"access_type": "offline",

"prompt": "none"


I am following as a reference.

Impactful Individual
Impactful Individual

Is that URL correct?  Looks like it should be


If the URL isn't the issue, I'd go through your Headers JSON with a fine-toothed comb.  It's strange that the error message is saying that your response_type header is missing when it looks like it's right there.  Make sure all your quotes and commas are where they should be, and that everything is spelled correctly.

Impactful Individual
Impactful Individual

Oh wait, I read too fast.  You're passing these as headers, but they're supposed to be query parameters.  See this example:

So it sounds like you can add all the parameters to the URL.

New Member

Did you manage to find a solution?

Love to hear this.


Super User
Super User

Hi @krishnags , @LFoundersMario , @Jronash 


I have separated this into three tutorial videos.


Video Part 1 - How to obtain authorisation code?


Video Part 2 - How to obtain access and refresh tokens?


Video Part 3 - How to obtain bearer token using refresh token and access Google Drive API using PowerAutomate?


Please have a look and comment.

Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up

Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,276)