In a simple view Google-Drive-Spredsheets are like Excel but online: https://spreadsheets.google.com/.
There is also a JSON-API to access the Spreadsheet-data. The URL is like “https://spreadsheets.google.com/feeds/list/IDENTIFIER/od6/public/values?alt=json” where “IDENTIFIER” is a unique string you get at your Google-Drive-Spreadsheet (you also have to set the Spreadsheet public readable, but you can hide the real URL when using this plugin).
Shortcode:
[jsoncontentimporterpro id=TEMPLATE_MANAGER_ID]
JCI-Template of the PRO Plugin: twig-code:
<table border=1> {% for item in feed.entry %} <tr><td> {{ attribute(item.title, '$t') }} </td><td> {% set v1 = attribute(item, 'gsx$valueofnumber') %} {{ attribute(v1 , '$t') }} </td><td> {% set v2 = attribute(item, 'gsx$thirdrow') %} {{ attribute(v2 , '$t') }} </td></tr> {% endfor %} </table>
URL: https://spreadsheets.google.com/feeds/list/IDENTIFIER/od6/public/values?alt=json
Example: https://docs.google.com/spreadsheets/d/1__KLa1PHbarb9o7YYOTlUzffaaZqtlixqscySK-hoiY gives you the IDENTIFIER “1__KLa1PHbarb9o7YYOTlUzffaaZqtlixqscySK-hoiY” and then https://spreadsheets.google.com/feeds/list/1__KLa1PHbarb9o7YYOTlUzffaaZqtlixqscySK-hoiY/od6/public/values?alt=json
Plugin output with this Doc and the above twig-code:
felda2 | feldb2 | itemc2 |
felda3 | feldb3 | itemc3 |
felda4 | feldb4 | itemc4 |
this is | berni | |
4 | 24 |