🚨 Glide working as GUI for IIoT projects

[gvalero]

@Nataliya_Kovaleva

This is seriously mindblowing to me

Hola Nataliya!

Depending on Google Sheet API version you use, you can have many options to easily retrieve data and almost for free.

Here we talked about it with some additional tips:

How To: CSV Export and send as email

Hola! Playing with the Google Sheets API days ago, I found this useful tip to export your data from GS to a CSV file very easy. All what we need is follow this syntax: https://spreadsheets.google.com/tq?tqx=out:csv&tq={Query}&key={SpreadsheetKey}&sheet={SheetName} Example: my GS is this and has more than 110k rows [image] and if I apply a query to retrieve 3 columns and 50 rows: select A,B, D where B>75 and B<78 limit 50 using this data source URL https://spreadsheets.google.com/tq…

and here you can see and play with GS API v4’s some practical examples to read range values, columns, etc:

Basic reading  |  Google Sheets  |  Google for Developers

The plan C could be to use a service like Sheet.best to turn your GS into a REST API and have many options to write/read/update/delete your data for a comfortable fee. I have tested this service before and it very powerful.

Have a nice night, saludos!