你要考慮data security更加要放上網,你既責任係set返對應既security, e.g. 有相應gsuite acccount既人先會睇到data
你要做既野係先upload 舊有excel表上google sheet, 再去google api拎crediential, 再將個creditential放入你個python/js 讀左佢, 佢會彈個browser問你登入同拎auth去經api access 個table
跟住你就可以用google提供既api去加減/query data, 因為google後面既query system係SQL底,速度上係遠超過VBA
你要inject data入table,你可以用google form:
https://www.youtube.com/watch?v=nagieG_Q6XQ
呢樣野唔存在security問題,因為用form條友只係加data,唔會access到DB
睇data就你share條link出去,記得send access right唔俾二次share,同埋share左唔俾改:
https://support.google.com/docs/answer/2494893?co=GENIE.Platform%3DDesktop&hl=en
你想俾一條友改DB,可以set限時限acc俾佢用呢個表去改data