Gas webhook that writes data to multiple spreadsheet of different users

dats7792 注册会员
2023-01-25 21:58

When the app is deployed you can choose execute as and enter yourself as the executer. In that case, make sure that your colleagues have given you the edit rights to their Spreadsheets in question, eg. Spreadsheet A. When the app then runs, it is running as yourself and therefore should work. Or you can set the user as the one which is running the app. See here for more information:

Web-App Permissions

This is the window I am referring to: