Retrieve contents from google drive spreadsheet and display it as a table.

Ryner Galaus

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, <a href="https://drive.google.com/open?id=1QfH3GLKMlaUGNZExCSXPi-B9lBKa8pf-" rel="nofollow ugc">view this pdf</a>.
Display of tables uses the <a href="https://mottie.github.io/tablesorter/docs/" rel="nofollow ugc">tablesorter script library</a>. You can check their jQuery plugin awesomeness <a href="https://github.com/Mottie/tablesorter" rel="nofollow ugc">at github</a>.
<ul>
<li>
Shortcode: [RSGGDS_TABLE]
</li>
<li>
Needed data from your spreadsheet are
<ul>
<li>Spreadsheet Link ID</li>
<li>Table Title</li>
<li>Desired columns separated by commas (example: A,B,C,D)</li>
<li>First and Last rows separate by period. (example: 1.15)</li>
</ul>
</li>
<li>
Table Display
<ul>
<li>Sticky header</li>
<li>Sortable </li>
</ul>
</li>
<li>
Requirements
<ul>
<li>PHP 5.4 or higher</li>
<li>WordPress 4.8 or higher</li>
<li>jQuery 1.4.3+</li>
</ul>
</li>
<li>
Browser Compatibility
<ul>
<li>Firefox 2+</li>
<li>Internet Explorer 6+</li>
<li>Safari 2+</li>
<li>Opera 9+</li>
<li>Konqueror</li>
</ul>
</li>
<li>
Future features
<ul>
<li>Spreadsheet need not be public</li>
<li>Can use link of the spreadsheet instead of the ID</li>
<li>Table templates</li>
</ul>
</li>
</ul>

Alternatives to RSG Retrieve Google Drive Spreadsheet

Top alternatives