Hi,
My data is recorded in a single google sheet tab and numeric data of all users are in same tab, which is security filtered, per user.
When a user set a criteria to filter his/her own data, I want this filtered data be available to a local computer, probably as csv, and after running some custom analyses on numerical data, return the results to appsheet for presentation of the results in a view. So basically, I want to make some analyses thats not available in appsheet or Google sheet, and provide results. What might be the logical route for such a process? Creating an individual GS tab for each of users? (which I dont prefer). Or any other possibilities?
The local computer that carry out analyses will use python and/or R scripts to do the work. Both are able to read google sheets directly, as far as I know.
Any guidance is appreciated.
LinkedIn
Twitter
