Google Sheets and PHP - GoFuckYourself.com

NickBaer · 07-15-2017, 02:55 PM

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 · 07-15-2017, 02:59 PM

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 · 07-16-2017, 11:48 AM

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

NickBaer · 07-18-2017, 01:03 PM

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 · 08-12-2017, 02:12 PM

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 · 08-13-2017, 07:52 AM

^^^I like your thinking

07-15-2017, 02:55 PM	#1
NickBaer Confirmed User Industry Role: Join Date: Jun 2005 Location: Now in England, had a great time at TES Lisbon/Cascais in March, and AVN's InterNext 2018 and AVN Expo. Thanks! Posts: 708	Google Sheets and PHP 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. __________________ Nick Baer, shooting in England. Had a productive time at TES Lisbon! I love Chaturbate W & Bonga & Visit-X I use CoinBase for BitCoins. Paxum for payouts www.NickBaerGallery.com The-Body-Guards.com The-British-Beef.com adultbizmall.com MojoHost www.gay-dvds-for-women-and-men.com

07-15-2017, 02:59 PM	#2
NickBaer Confirmed User Industry Role: Join Date: Jun 2005 Location: Now in England, had a great time at TES Lisbon/Cascais in March, and AVN's InterNext 2018 and AVN Expo. Thanks! Posts: 708	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.. __________________ Nick Baer, shooting in England. Had a productive time at TES Lisbon! I love Chaturbate W & Bonga & Visit-X I use CoinBase for BitCoins. Paxum for payouts www.NickBaerGallery.com The-Body-Guards.com The-British-Beef.com adultbizmall.com MojoHost www.gay-dvds-for-women-and-men.com

07-16-2017, 11:48 AM	#3
magneto664 God Bless You Industry Role: Join Date: Aug 2014 Location: Pitcairn Islands Posts: 846	check https://zapier.com/ and https://ifttt.com maybe you find working solution __________________ magneto664 📧 gmail.com adult+seo+professional+seo+advice adult backlinks 💘 My Fav: 👍chaturbate 👍 stripchat 👍 dateprofits 👍 datetronix 👍

07-18-2017, 01:03 PM	#4
NickBaer Confirmed User Industry Role: Join Date: Jun 2005 Location: Now in England, had a great time at TES Lisbon/Cascais in March, and AVN's InterNext 2018 and AVN Expo. Thanks! Posts: 708	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. __________________ Nick Baer, shooting in England. Had a productive time at TES Lisbon! I love Chaturbate W & Bonga & Visit-X I use CoinBase for BitCoins. Paxum for payouts www.NickBaerGallery.com The-Body-Guards.com The-British-Beef.com adultbizmall.com MojoHost www.gay-dvds-for-women-and-men.com

08-12-2017, 02:12 PM	#5
robber Web Developer Industry Role: Join Date: Jan 2011 Location: UK Posts: 263	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 😊 __________________ My Site: foxydrop.com ICQ: 609-705-438 Link Trades \| FDNetwork

08-13-2017, 07:52 AM	#6
Barry-xlovecam It's 42 Industry Role: Join Date: Jun 2010 Location: Global Posts: 18,088	^^^I like your thinking