Google Sheets and PHP

[NickBaer]

Has anyone been successful getting PHP to read (and maybe write/edit) Google Sheets?

4-5 hours later, I have found the worst awful collection of "how to's" and user experiences.

Most are about v3, but it's been v4 for a long time.

I think I have the Sharing done right, and Credentials.

[NickBaer]

I've been using PHPExcel with .xls files for a few years now. Learned tonight that Google Sheets downloads as .xlsx... but was able to find the fix for PHPExcel 1.8 to do .xlsx. Which is backwards compatible with .xls.

So I at least have a workaround. Since I like to travel, I like using Sheets with the Chrome Excel extension, rather than .xls files and OO (which is a dead-end project, and LibreOffice is of no interest to me with the Excel Chrome Extension). I would like to take the next step beyond downloading/FTP'ing a .xlsx file to my webserver, to being realtime read (at least) of that spreadsheet data by my PHP script for the webpage in question..

[magneto664]

check https://zapier.com/ and https://ifttt.com maybe you find working solution

[NickBaer]

Got it to work. Used a very simple method, because all I want to do is "read" a Google Sheets spreadsheet.

When I get to the point that I want to "edit" or "write," then I will use Plan B, which is harder.

[robber]

Have you considered using a csv file as it can be read with google sheets and you can easily read it directly into your web server. It also would allow for you to push amendments back by recreating the file which should be pretty simple with PHP

It would save any messing on both sides 😊

[Barry-xlovecam]

^^^I like your thinking