Google Sheets API v4 receives HTTP 401 responses for public feeds

by

I managed to get this working. Even I was frustrated at first. And, this is not a bug. Here’s how I did it:

  1. First, enable these in your GDC to get rid of authentication errors.

-Google Apps Script Execution API

-Google Sheets API

Note: Make sure the Google account you used in GDC must be the same account you’re using in Spreadsheet project else you might get a "The API Key and the authentication credential are from different projects" error message.

  1. Go to https://developers.google.com/oauthplayground where you will acquire authorization tokens.
  2. On Step 1, choose Google Sheets API v4 and choose https://www.googleapis.com/auth/spreadsheets scope so you have bot read and write permissions.
  3. Click the Authorize APIs button. Allow the authentication and you’ll proceed to Step 2.
  4. On Step 2, click Exchange authorization code for tokens button. After that, proceed to Step 3.
  5. On Step 3, time to paste your URL request. Since default server method is GET proceed and click Send the request button.

Note: Make sure your URL requests are the ones indicated in the Spreadsheetv4 docs.

Here’s my sample URL request:

https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID?includeGridData=false

I got a HTTP/1.1 200 OK and it displayed my requested data. This goes for all Spreadsheetv4 server-side processes.

Hope this helps.

More Related Contents:

  1. Google Sheets API returns “The caller does not have permission” when using server key
  2. Google Sheet API V4(Java) append Date in cells
  3. How do I access (read, write) Google Sheets spreadsheets with Python?
  4. “Encountered an error while globbing file pattern” error when using BigQuery API w/ Google Sheets
  5. Copying a spreadsheet copies all linked files as well
  6. GAS “On edit” trigger not running when edited from API
  7. Accessing Google Spreadsheets with C# using Google Data API
  8. How can I access Google Sheet spreadsheets only with Javascript?
  9. email notification if cell is changed
  10. Download a spreadsheet from Google Drive / Workspace using Python
  11. Pushing data to Google spreadsheet through JavaScript running in browser
  12. Google Apps Script for Multiple Find and Replace in Google Sheets
  13. gspread authentication throwing insufficient permission
  14. Google Sheet API v4
  15. How to Print sheet/range using .gs script in Google Sheets?
  16. What is the fastest way to update a google spreadsheet with a lot of data through the spreadsheet api?

Leave a Comment