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 parser=twig url="https://spreadsheets.google.com/feeds/list/1__KLa1PHbarb9o7YYOTlUzffaaZqtlixqscySK-hoiY/od6/public/values?alt=json" id=TEMPLATE_MANAGER_ID]

twig-code:

<table border=1>
{% for item in feed.entry %}
<tr><td>
{{item.title._symbol_dollar_t}}<br>
</td><td>
{{item.gsx_symbol_dollar_valueofnumber._symbol_dollar_t}}
</td><td>
{{item.gsx_symbol_dollar_thirdrow._symbol_dollar_t}}
</td></tr>
{% endfor %}
</table>

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