Hello everyone
I want to pick your thought on a challenging data structure subject!
I work in a real estate agency, our data are stored on a dozens of google sheets, containing dozens of tables each containing thousands of rows.
Each internal team has its own google sheet, but every google sheet is connected to almost any of the other via app script, import range and filters & query inside of google sheets.
Lots of actions are automated on top of these google sheet with app script, autocrat for doc creation, and zaps.
We have two small glide apps plugged on a google sheet, where we import data from all of our google sheets. It means that our glide app is just used for reading and displaying purposes, we can’t edit data. Internally, everyone works on the google sheets, but as you can imagine, it’s slow, it creates errors, and the UX is bad.
My goal is to create one single internal app, under which I would regroup every functionality currently done in our google sheets, and of course, each actions happening afterwards.
But where to begins and what’s the best way?
I have 3 ideas :
- Plugging 1 glide app on top of each google sheet. Each team will have their app, it’s the easiest and fastest way, because every automations wouldn’t need to be created again (as it happens on the google sheets). The inconvenient is that or DB would still be slow, unscalable and not duplicable.
- Restructure Databases to create one main google sheet, where I would plug our main glide app. I prefer this option, but I need to recreate every actions and automations.
- Go full Glide table. I love this options but is it truly scalable ? I’m looking into big query and big glide table, but we don’t find that many experts and there seems to be lots of limitations.
In the long term we want something scalable, and duplicable. I want to keep as much app scripts as possible, or find a way to do it in glide? It’s very convenient to trigger automations and create docs whiteout using zapper, make and PDFmonkey.
Sorry for this long message, and thanks for your feedbacks!
Have a nice day,
Lucas