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 Nick Baer Industry Role: Join Date: Jun 2005 Location: In Europe. Using high speed Internet to update my studios. Posts: 1,338	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. __________________ Made my first porno in 1986. Sold my first VHS in 1993. Did my first live Cam in 1994. Coach-Karl.com NickBaerGallery.com I host with MojoHost.com and To Buy or Sell Sites Imagine AI Content

07-15-2017, 02:59 PM	#2
NickBaer Nick Baer Industry Role: Join Date: Jun 2005 Location: In Europe. Using high speed Internet to update my studios. Posts: 1,338	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.. __________________ Made my first porno in 1986. Sold my first VHS in 1993. Did my first live Cam in 1994. Coach-Karl.com NickBaerGallery.com I host with MojoHost.com and To Buy or Sell Sites Imagine AI Content

07-16-2017, 11:48 AM	#3
magneto664 God Bless You Industry Role: Join Date: Aug 2014 Location: Glasgow, $cotland Posts: 1,467	check https://zapier.com/ and https://ifttt.com maybe you find working solution __________________ magneto664 📧 gmail.com Adult Backlinks 💘Best Website Stats 💘 Best CDN for Adult Content My Fav: 👍Chaturbate 👍 Stripchat 👍 Dateprofits 👍 AdultFriendFinder

07-18-2017, 01:03 PM	#4
NickBaer Nick Baer Industry Role: Join Date: Jun 2005 Location: In Europe. Using high speed Internet to update my studios. Posts: 1,338	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. __________________ Made my first porno in 1986. Sold my first VHS in 1993. Did my first live Cam in 1994. Coach-Karl.com NickBaerGallery.com I host with MojoHost.com and To Buy or Sell Sites Imagine AI Content

08-12-2017, 02:12 PM	#5
robber Web Developer Industry Role: Join Date: Jan 2011 Location: UK Posts: 264	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 😊

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