How can I access data from Googlesheets?

Answered

Easy! This would be an API call in Knowi.

Try this:

1) Select REST as the Datasource

2) Give the Connection a name and then simply enter then set the following for the Rest Host: https://docs.google.com and save your connection
3) Create a new query that uses this new API datasource and enter the following in the Query endpoint: /spreadsheets/d/<your_spreadsheet_id_here>/export?format=csv

Here's an example: http://recordit.co/tl54DHmitB

1 comment

Manny Ezeagwula May 08, 2019 17:41

To pull data with multiple sheets you can join multiple queries and specify the sheets gid in the endpoint URL will let you specify which sheet.

See example, http://recordit.co/B6pAgC3jtw

1

Comment actions Permalink

Please sign in to leave a comment.