Getting data out of a google sheet

  api, google-sheets, php

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

LEAVE A COMMENT