Google Sheets is ubiquitous and has 1000’s of integration options already built for it, scripts, connections to other apps including Google Data Studio. It allows you to free your data from Tadabase and into something that many other apps can work natively. While Tadabase pipes are amazing, having your data updated in real time into Google Sheets would serves as an excellent way to back up your data in real time without having to a script.
The pipe would allow for read and write to a Google Sheet
Zapier has over 4000+ connections already built to work with data in Google sheets to other apps. Getting our data out of Tadabase exclusively and into Google Sheets, AirTable and other systems that can house data like a database is paramount to run further analysis and operations on. While pipes are nice, they are not going to replace Integromat anytime soon.
If we had Google Sheets, we could be able to immediately use Google Data Studio, Tableau, and many other analytics programs with ease. I think that alone calls for this integration to be built.
You could also build a pipe that would post and get data to MySql database which could serve the same purpose as Google Sheets, but Google Sheets has some connections to it that I really would love to have.