javascript – Mini-Search Engine can’t read Google Sheet. Have the urls changed?

I have a working mini-search engine that reads JSON from a Google Sheet. It was working last year. I think Google may have changed their API or URLs.

In line 544, there is a variable:

$(function() {
var GSHEET_JSON_URL 

Whatever variable I use, it will return: The specified GSHEET_JSON_URL does not contain JSON:’
Even using a dummy URL like

`https://www.jake.com`

will return the same message.

I think google have changed the URL structure.
I checked the original Codepen, from a different designer. It’s also returning the same error. Im guessing the change must come from the Google Sheets API.

The last URL I remember working is

‘https://spreadsheets.google.com/feeds/list/1WUzfGeyOMVVOb8tbYLqHTrAk7Ii2p6l58EXG-kcgOcY/1/public/values?alt=json’;

The console returns 404.

I’m not sure where to go from here. I will continue looking at Googles Sheets API Docs.