RSG Retrieve Google Drive Spreadsheet

Retrieve contents from google drive spreadsheet and display it as a table. This however needs your spreadsheet to be public and is published to the web. To publish your spreadsheet and make it public, view this pdf.

Display of tables uses the tablesorter script library. You can check their jQuery plugin awesomeness at github.

• Shortcode: [RSGGDS_TABLE]

• Needed data from your spreadsheet are

  • Spreadsheet Link ID
  • Table Title
  • Desired columns separated by commas (example: A,B,C,D)
  • First and Last rows separate by period. (example: 1.15)

• Table Display

  • Sticky header
  • Sortable

• Requirements

  • PHP 5.4 or higher
  • WordPress 4.8 or higher
  • jQuery 1.4.3+

• Browser Compatibility

  • Firefox 2+
  • Internet Explorer 6+
  • Safari 2+
  • Opera 9+
  • Konqueror

• Future features

  • Spreadsheet need not be public
  • Can use link of the spreadsheet instead of the ID
  • Table templates