Fetch data from google spreadsheets

[tao-guo]

We have several google spreadsheets used for maintaining events, registration information, members' books for sharing. We can fetch the data using ajax and display it on our own websites.

Just like this: http://acrl.ala.org/techconnect/?p=4001

Use google spreadsheets as our databases :)

[caogecym]

:+1:

[caogecym]

this is one example url we can request: https://docs.google.com/spreadsheets/d/1xR-yPNVL6vhPrj3VudJoiqI86SKiMzbbi6ztsg2so10/gviz/tq?tqx=out:csv&tq&gid=0

[tao-guo]

:+1: Could you work with Yong to make sure you are using the same spreadsheet? Whenever Yong change the sheet in the future, our website should display the lasted one.

[myahmao]

book club library sharing books inventory in google doc : https://docs.google.com/spreadsheets/d/1AWenZi1mIIINelqu4pPyeIqp2c3lVrXuDz2tIl1PPJs/edit#gid=0

[caogecym]

some thoughts after we adopted real time google drive fetching:

• mainland China user access is not guaranteed
• load speed might not be as fast, ~200ms v.s. current ~50 ms

So basically a trade off between admin convenience and user experience.

[myahmao]

then using an exported csv is still an option.