I use a script in a cronjob to grab data from a google spreadsheet. It worked fine for over a year but recently started giving occasional 404s and now gives 404 every time.
I don’t care how I get the data out, I just need a way my script can get the data.
Right now I’m using this URL to get data but I really don’t care how I get it so long as it’s machine readable and automated. https://spreadsheets.google.com/feeds/cells/1KxpfpHzCstsg_hvG8v6ksgjt3ghAHb1URwW41mW7Vgs/1/public/full?alt=json
My script is PHP at a URL called by a cron job every 15 minutes (yeah, that isn’t very tight design, I know!)
Source: Ask PHP