Hi everyone,
This may seem a bit strange but I’m planning to use a Google Sheet as a front end where users can type in inputs. Then, users can click the submit button to trigger a Prefect flow that will read the Gsheet’s inputs, transform it, then write it back onto the Gsheet. I’m wondering if anyone has tried something similar and can offer feedback on my approach:
1. We have a button in Gsheets that will activate a Google Apps Script to do an API call
2. The API call (hosted on AWS API Gateway) will trigger a Lambda function, which will trigger a Prefect flow
3. Prefect flow will read data in Gsheets, transform the data, then write data in Gsheets
Any suggestions or input is appreciated!