In this video we delve deep in to passing user inputs in to Google Apps Scripts which allows the user to define parameters in the automated reports.

We use Google Gemini and Google Big Query with Apps Script to Develop an Automated Reports with Parameters and Prompts passed by the user.

Apps Script allows the user to use Google Gemini in Google Sheers but should be controlled in order to ensure the model does not hallucinate bad results for the users. This is a good method to do that allowing the user to only pass certain portions of the prompt to the model.

The full code for this video is below.

GitHub: https://github.com/analyticswithadam/...