# 🚨 Glide working as GUI for IIoT projects

**URL:** <https://community.glideapps.com/t/glide-working-as-gui-for-iiot-projects/61367>\
**Category:** Project Showcase\
**Created:** [May 4, 2023, 10:52pm UTC](https://community.glideapps.com/t/glide-working-as-gui-for-iiot-projects/61367 "2023-05-04T22:52:52Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [March 8, 2024, 1:17am UTC](https://community.glideapps.com/t/glide-working-as-gui-for-iiot-projects/61367/15 "2024-03-08T01:17:46Z")

</div>

> [@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](https://community.glideapps.com/t/how-to-csv-export-and-send-as-email/31618/23):
>
> 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}](https://spreadsheets.google.com/tq?tqx=out:csv&tq=%7BQuery%7D&key=%7BSpreadsheetKey%7D&sheet=%7BSheetName%7D) Example: my GS is this and has more than 110k rows 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](https://developers.google.com/sheets/api/samples/reading)**

The plan C could be to use a service like **[Sheet.best](https://docs.sheet.best/#quickstart)** 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!

---

_[View the full topic](https://community.glideapps.com/t/glide-working-as-gui-for-iiot-projects/61367)._