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
Retreive Specific Data from Google Sheets Questions about Thunkable	14	743	November 8, 2024
Get data from sheets Questions about Thunkable	3	285	November 8, 2024
Text Input Based Data Extraction From Google Sheets Web API's	2	157	November 8, 2024
Functions with google shhets Questions about Thunkable beginner	6	552	November 8, 2024
Quiz App using google sheet via google's visualization API Query Language (instead of Data Source) Free Templates, Designs, and Block Combinations	16	1472	November 8, 2024

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

Related topics