Currently Google added the visualization services to Google sheet which means you can just share the sheet and use the share URL but replace the part that says edit?usp=sharing with gviz/tq? and you will get the data in the Google sheet. Example: https://docs.google.com/spreadsheets/d/[sheet ID]/g…

More than that, you can actually filter results if you add SQL like query to the end of the URL. The query text has to be urlencoded. So instead of /gviz/tq? you can do /gviz/tq?tq= and your query which will get only matching rows from the sheet.

Get data from google sheets without using the data source blocks!

Free Templates, Designs, and Block Combinations

manyone May 8, 2022, 6:12am 9

2 Likes

Topic		Replies	Views
Get data from sheets Questions about Thunkable	2	252	August 25, 2021
Help me to view all my data in googlesheets via Web Api Questions about Thunkable beginner	5	129	August 16, 2023
Retreive Specific Data from Google Sheets Questions about Thunkable	13	528	June 23, 2021
Functions with google shhets Questions about Thunkable beginner	5	489	May 21, 2020
Quiz App using google sheet via google's visualization API Query Language (instead of Data Source) Free Templates, Designs, and Block Combinations	15	1135	January 16, 2024

Get data from google sheets without using the data source blocks!

Related Topics