Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar Mark Forums Read
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
New Webmasters ask "How-To" questions here. This is where other fucking Webmasters help.

 
Thread Tools
Old 07-15-2017, 02:55 PM   #1
NickBaer
Confirmed User
 
Industry Role:
Join Date: Jun 2005
Location: Traveling in the UK
Posts: 444
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, on the road for the three September trade shows. I love Chaturbate W & Bonga & Visit-X
I use PAXUM
www.NickBaerGallery.com
The-Body-Guards.com The-British-Beef.com
adultbizmall.com
www.gay-dvds-for-women-and-men.com
NickBaer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-15-2017, 02:59 PM   #2
NickBaer
Confirmed User
 
Industry Role:
Join Date: Jun 2005
Location: Traveling in the UK
Posts: 444
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, on the road for the three September trade shows. I love Chaturbate W & Bonga & Visit-X
I use PAXUM
www.NickBaerGallery.com
The-Body-Guards.com The-British-Beef.com
adultbizmall.com
www.gay-dvds-for-women-and-men.com
NickBaer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-16-2017, 11:48 AM   #3
magneto664
Confirmed User
 
Industry Role:
Join Date: Aug 2014
Location: Glasgow
Posts: 253
check https://zapier.com/ and https://ifttt.com maybe you find working solution
__________________
magneto664 [x] gmail.com
GET FREE ADULT BACKLINKS - My Fav: chaturbate - dateprofits - datetronix
magneto664 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 07-18-2017, 01:03 PM   #4
NickBaer
Confirmed User
 
Industry Role:
Join Date: Jun 2005
Location: Traveling in the UK
Posts: 444
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, on the road for the three September trade shows. I love Chaturbate W & Bonga & Visit-X
I use PAXUM
www.NickBaerGallery.com
The-Body-Guards.com The-British-Beef.com
adultbizmall.com
www.gay-dvds-for-women-and-men.com
NickBaer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 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
robber is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 08-13-2017, 07:52 AM   #6
Barry-xlovecam
It's 42
 
Barry-xlovecam's Avatar
 
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 17,092
^^^I like your thinking
__________________
Vive la résistance -- Carpe diem

"If you only knew the power of the dark side." ...Darth Vader
Sk.why.pe: barry_555_5 -- ICQ: three1896three617
Barry-xlovecam is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks

Tags
google, sheets, php, experiences, sharing, credentials, time, user, awful, read, successful, write/edit, 4-5, collection, worst, found, hours, tos
Thread Tools




©2000-, AVN Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.