PRO Plugin: API spreadsheets.google.com

API:
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