I want to give spreadsheet edit access to the users in web app (React) portal using service account. So after sign in into portal, user should be logged into Google Sheet using service account and should be able to edit the spreadsheet. Here is the flow I am expecting:
- User login into the custom web portal with given username and password (Not google login).
- On successful login, user sees the spreadsheet embedded into the web page and it is accessed using Service Account. Assuming, spreadsheet is shared with service account.
- User can make changes in the spreadsheet (changes will be done using service account)
- User can click Google Apps Script button.
I understand that we can edit the spreadsheet programmatically using service account, but is it possible to embed private spreadsheet in the portal and edit it using service account. Also can service account run the apps script in Google Sheet?