Google Sheets

Hi Brian,

Dom here, co-founder of Five, a low-code company.

The first question I'd ask is this: do you want to continue using Google Sheets or Microsoft Excel as your database? If yes, then indeed Retool is a great choice because it connects to Google Sheets and lets you build a front end on top of it. An alternative could be AppSheet, which belongs to Google and does the same as Retool.

My advice, however, would be not to use a spreadsheet as a database. I won't go into all the reasons for this. But a spreadsheet is not designed to support web applications. At some point, it will either become very slow or you will struggle with data integrity, especially if you have ten users reading & writing data concurrently. That's why I'd look for an online database application builder.

Now, this is where I'm biased, given my role at Five, but here's what Five lets you do:

You can create your own MySQL database straight inside Five. So instead of storing data in a spreadsheet, you store it in a web-hosted MySQL database. You can import CSV files into your database, so your existing data won't be lost. You can then build the front end on top of the MySQL database. The advantages: you get something that is scalable and won't break in the future. And MySQL is open-source, so even if at some point in the future, you won't go elsewhere with your application, your data is portable.

Hope this helps and as I said, think about the right back end for your application first. :)

Dom

Hi Brian! Based on your requirements, I’d strongly suggest giving Retool a try. It excels at having the pre-assembled components library which lets you put together apps in a breeze. It scales with your needs and the medium plan should be quite sufficient for a while. I’m helping companies with their use of Retool as part of my business: www.blackholeconsulting.net

Hope this recommendation helps! Cheers, Stephan

It's hard to make a suggestion here as your use case isn't clear enough.

Use BigQuery if you want to replicate your probably on premise Oracle and Elasticsearch databases so you can profit from the speed of BigQuery. You can do the replication via Google Cloud Functions. Your Google Sheets can be connected to BigQuery and BigQuery can easily be connected to DataStudio.

If you do data science on the data there would be BigQuery ML and Google Colab that would fit into your stack.

In case you do BigData analysis you can go with Apache Spark if you have enough resources (on-prem or Cloud). I suggest you to use a Kubernetes backbone for this as you only reserve the resources when in use and the cluster can be used for other stuff as well.

For dashboarding find your preference and the preference of your audience with DataStudio, Tableau or Apache Superset

A trending feed showcases the most popular topics, hashtags, or posts on social media platforms in real time. These feeds are driven by algorithms that analyze user engagement, such as likes, shares, and comments, to identify what resonates with audiences. Trending feeds serve as a valuable tool for users and marketers, offering insights into current events, pop culture, and consumer interests. Engaging with trending topics can enhance visibility and drive traffic. For a deeper understanding, check resources from platforms like Hootsuite and Sprout Social, which provide insights into leveraging trending feeds effectively.