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 |