Google Apps Script
Google Apps Script lets you connect and automate Google Workspace services (like Gmail, Docs, and Drive) by writing JavaScript code in your browser, without needing a separate server. Until now, you had to know programming to create that code.
Gemini
Large Language Models (LLMs) like Gemini are revolutionizing how we interact with technology. Gemini can convert natural language instruction ("prompts") into executable code. Imagine simply describing what you want to automate in plain English, and Gemini generates the code for you.
Vertex AI
Introducing AI Agents for Google Apps Script
In this project, I explored creating a concept for AI Agents. Using a natural language you describe your need, this is then passed to Gemini, leveraging Gemini 2.0 Flash Thinking, to generate the necessary code. The generated code is then fed back into the Google Apps Script environment. The generated code can then execute as part of App Script.2. You'll need to configure the Apps Script project's manifest file. The manifest defines the settings for your Apps Script project. The manifest specifies the permissions ("scopes") that your application will need to access Google services. Be sure to carefully select and authorize only the necessary scopes for your agent. If you get an error when running, it's because you don't have the necessary permissions and you need to add more scopes.
3. Now I have prepared a function that calls the Gemini API within Vertex AI.
This code describes running an agent. First, it must be configured using the GCP Project and region. Then, you describe in natural language what needs to be done. After running the .act() method, Gemini 2.0 Flash Thinking within Vertex AI is called to generate code.
To ensure that the agent is doing the right thing, you can test the execution via a dry-run, where the code is sent to an internal Tester agent who, via Gemini 2.0 Flash, comments on the code and summarizes it in a log.
If everything is in order, you can then run .run(). I remind you again that you have given the script rights to everything. So if you write something wrong, for example, to delete data, it will actually be deleted. I am not responsible for the results of the script, and you should always review it before running it.
The generated code is stored in the Cache, so after running a dry-run and then a run, the same version will be executed within the Cache limit (currently set to 5 minutes).
```javascript // Define the label name const labelName = 'DEMO'; // Check if the label exists, create if not let demoLabel = GmailApp.getUserLabels().find(label => label.getName() === labelName); // Find the label by name if (!demoLabel) { // If the label doesn't exist demoLabel = GmailApp.createLabel(labelName); // Create the label Logger.log(`Label "${labelName}" created.`); // Log that the label was created } else { // If the label already exists Logger.log(`Label "${labelName}" already exists.`); // Log that the label already exists } // Load last 10 emails with subject 'Security alert' const threads = GmailApp.search('subject:"Security alert"', 0, 10); // Search for threads with the specified subject, starting from the first thread (0) and retrieving a maximum of 10 threads // Set the 'DEMO' label to found emails if (threads.length > 0) { // If any threads were found threads.forEach(thread => { // Iterate over each thread thread.addLabel(demoLabel); // Add the 'DEMO' label to the current thread }); Logger.log(`Label "${labelName}" applied to ${threads.length} emails.`); // Log the number of emails the label was applied to } else { // If no threads were found Logger.log('No emails with subject "Security alert" found in the last 10 threads.'); // Log that no emails were found } ``` **Summary:** The code functions exactly as described in the task: 1. **Creates a new label 'DEMO' if it doesn't exist:** The code first checks if a label named 'DEMO' already exists. If not, it creates the label. 2. **Loads the last 10 emails with the subject 'Security alert':** The code then searches for the last 10 emails that have the subject 'Security alert'. 3. **Sets the 'DEMO' label to the found emails:** Finally, the code iterates through the found emails (represented as threads) and applies the 'DEMO' label to each of them. The code also includes logging statements to provide information about the actions being performed, which is good practice.