I have set up a Google Apps Script that validates data that is entered into various Google Sheets files. I am looking for a way to allow users to access those Google Sheets files without making them sign in manually.
There are various onEdit() triggers set up that monitor these Sheets files and apply formatting to cells when data input errors occur. I'm doing validation with Google Apps Scripts because the errors are determined through non-straightforward business logic which makes Sheets' built-in data validation insufficient. The triggers are set up by a standalone Google Apps Script project. This setup means I cannot simply share a link to the Google Sheets file and have people edit it anonymously and have the data checked and cells formatted, because the scripts require more permissions than are necessary for anonymous editing.
I've looked briefly at some Google Auth API docs, but I'm not a security or web dev by trade so it's a bit confusing.
I'm looking for a solution where the user could click on a link to a Sheets file and automatically be redirected to the Sheets file and be signed in to a Google account that is managed by me, and which already has permission to access that Sheets file (this way they won't be editing these files with their personal accounts). The link would be on a Drupal site that users would have already signed into using Drupal's built-in sign-in functionality, in case that makes a difference.
