SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2011
    Posts
    121
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to pull data from google drive spreadsheets?

    Is there a way to pull the content from google drive spreadsheet fields and echo them into a webpage? I'm building a website where the client wants to be able to update weekly events. This is the only section of the site that really needs cms functionality and I don't want to build (or implement) a formal cms if I don't have to. I though this might be a way to make a really lightweight cms.

    The spreadsheet would only have several columns (month, day, event title, event description)

    Basically I would want to loop through each row (starting with the 2nd) and echo the field contents.

    Any ideas?

  2. #2
    SitePoint Zealot
    Join Date
    Dec 2011
    Posts
    121
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Is this something that just can't be done or too much hassle to mess with? Are there any other solutions to really simple cms for when only one page with pull information from it?

  3. #3
    SitePoint Wizard bronze trophy
    Join Date
    Jul 2006
    Location
    Augusta, Georgia, United States
    Posts
    4,139
    Mentioned
    16 Post(s)
    Tagged
    3 Thread(s)
    https://developers.google.com/apps-s...e/spreadsheet/

    A quick search using "google spreadsheets server-side API" revealed that link though I've never actually used that API myself.
    The only code I hate more than my own is everyone else's.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •