We’re interested in using Retool to build a dashboard that will let our customers visualize the results of some calculations that are happening within a Google Sheets file.
Within this file, we have a bunch of raw values on tab A, and then another tab B which contains some formulas that take the raw values from tab A as input and outputs some results.
What we’d like to do is to fetch the results of the calculations from tab B, and then display those on a variety of charts in Retool.
The main requirement is that we need to make sure that our customers should only be able to access the results of the calculations, from only very specific cells within the file.
Thus, we want to make sure that they won’t be able to access the “raw” values on tab A, as well as the actual formulas used to generate the results on tab B. And that, even if end-users (not standard Retool users) try to “hack” around the app.
Could you please confirm with me if Retool is sufficiently safe for our use case?