# Help with Google Sheets API

**URL:** <https://community.make.com/t/help-with-google-sheets-api/37936>\
**Category:** Beginner Questions\
**Tags:** google-sheets, api\
**Created:** [May 18, 2024, 7:41pm UTC](https://community.make.com/t/help-with-google-sheets-api/37936 "2024-05-18T19:41:59Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_Kwitko](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@Alex\_Kwitko](https://community.make.com/u/Alex_Kwitko)\
**Post date:** [May 18, 2024, 7:41pm UTC](https://community.make.com/t/help-with-google-sheets-api/37936/1 "2024-05-18T19:41:59Z")

</div>

Hi,

I hope all is well.

I am having trouble to connect to google Sheets. I tried the normal connection with my user but the connection is not allowing me to do a get Data Range. So, I created an project in Google and credentials that is working fine for Google Drive, but not for Google Sheets. Please any recommendation?

 ![Screenshot 2024-05-18 at 2.39.32 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/b/7b422fbad2f2eeffe0932322ee7a28af9843a853.png)  
 ![Screenshot 2024-05-18 at 2.39.16 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/f/4f7efd99ef420c648eaa20645e42923ee9c890cf.png)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 19, 2024, 1:22am UTC](https://community.make.com/t/help-with-google-sheets-api/37936/2 "2024-05-19T01:22:56Z")

</div>

Welcome to the Make community!

What is the full URL in your first screenshot?

I.e.: what is the URL it is trying to redirect to?

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with us!

---

<div class="post-metadata">

**Author:** ![Alex\_Kwitko](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@Alex\_Kwitko](https://community.make.com/u/Alex_Kwitko)\
**Post date:** [May 19, 2024, 1:54pm UTC](https://community.make.com/t/help-with-google-sheets-api/37936/3 "2024-05-19T13:54:59Z")

</div>

Hi,

## Error 400: redirect\_uri\_mismatch

You can’t sign in to this app because it doesn’t comply with Google’s OAuth 2.0 policy.

If you’re the app developer, register the redirect URI in the Google Cloud Console.

Request details: redirect\_uri=[https://www.integromat.com/oauth/cb/google/](https://www.integromat.com/oauth/cb/google/)

[Related developer documentation](https://developers.google.com/identity/protocols/oauth2/web-server#authorization-errors-redirect-uri-mismatch)

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [May 19, 2024, 2:35pm UTC](https://community.make.com/t/help-with-google-sheets-api/37936/4 "2024-05-19T14:35:31Z")

</div>

It appears you didn’t show advanced options, and insert the GCP app id and secret before you clicked sign in.

---

<div class="post-metadata">

**Author:** ![Alex\_Kwitko](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@Alex\_Kwitko](https://community.make.com/u/Alex_Kwitko)\
**Post date:** [May 19, 2024, 2:54pm UTC](https://community.make.com/t/help-with-google-sheets-api/37936/5 "2024-05-19T14:54:22Z")

</div>

Of course I did, very good recommendation, like turn on and off

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [August 17, 2024, 3:04pm UTC](https://community.make.com/t/help-with-google-sheets-api/37936/6 "2024-08-17T15:04:03Z")

</div>