glarrain
Re:Use Python Inside Google Sheets
on Wednesday October 25, 2023 @10:22AM (#38013130)
Awesome. I've been waiting for something like this for a long time!
Question: is there any way to get information from the "environment" e.g. the ID of the Google Drive file, sheet name/id, user that triggered the recalculation, etc?
It would be incredible to be able to send requests to external services using authentication corresponding to the user, not an static API key (I understand Neptyne has a secrets management service for the latter). Use case in mind: query Starburst (trino as a service) with OAuth authentication.