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	3	275	November 8, 2024
Help me to view all my data in googlesheets via Web Api Questions about Thunkable beginner	5	162	August 16, 2023
Retreive Specific Data from Google Sheets Questions about Thunkable	14	704	November 8, 2024
Functions with google shhets Questions about Thunkable beginner	6	538	November 8, 2024
Data visualization Questions about Thunkable webapi	12	1861	November 8, 2024

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

Related topics