When i replace my spreadsheet ID with the ID of a spreadsheet with a public shared link adress the scenario runs flawless. So it is the verification process that has a problem.
I have enabled the google sheets and google drive API’s.
Hi, thanks for your quick response.
The reason i am using an http module is that some parameters of the download is customizable as opposed to the google drive download a file module. For example i use this url in the http module:
I asked chatGPT what the problem was by giving it the input value and output value (can be found down underneath). It said
When you use “Google Sheets → Make an API call” in Make.com, you can’t use the full https://docs.google.com/... URL like in your example.
The Google Sheets API only allows requests to endpoints under https://sheets.googleapis.com/v4/spreadsheets/``..., not document view links such as docs.google.com/spreadsheets/``....
That’s why you’re seeing the error — the Google API tries to add /v4/ in front of your URL, resulting in a request to:
I was under the impression from your post that you were willing to use an API and missed the URL you’re pointing to in your request visible in screenshoots.
You’re simply generating an export link. You don’t need any cloud platform app or even modules to do this.
All you need to do is change the permissions to public before generating the link and fix one issue in your URL.
Make’s documentation is unfortunately really poor when it comes to Google OAuth so it’s often trial and error with the redirect URIs, scopes and authorization parameters until it works.
Try stripping everything down to basics and make the following changes to your setup.
First, in your Google Cloud Console project:
1. APIs & Services > Enable APIs & Services
Search for Google Drive API and make sure it’s enabled.
2. Branding
Authorized domains: make sure these are set:
integromat.com
make.com
3. Audience
Test Users: make sure your Gmail account is added as a test user.
4. OAuth Consent Screen > Clients
Authorized Redirect URIs - remove all except these two:
https://www.make.com/oauth/cb/oauth2
https://www.integromat.com/oauth/cb/oauth2
5. Data Access (scopes)
To download a Google Sheet, you should only need this scope: https://www.googleapis.com/auth/drive.readonly
6. In Make > HTTP OAuth 2.0 Connection
Create a new connection and configure it like this:
Scope separator:SPACE
(it doesn’t matter for your use case here since you only use one scope, but just as a note in the future if you’ll need to add more scopes)
Authorize parameters (this should remove the requirement to constantly refresh your connection):
key: access_type
value: offline
Don’t add any other parameters in this advanced section, leave all blank.
The connection should go through with no issues - if you run into any kind of errors during the login to your Google account, report back with what the error was.
Once the connection is established, paste your docs.google.com link like you had, use the GET parameter, and make sure you have viewer or editor access to the sheet with the account you configured as test user in Google Cloud Console.
