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 |