gas-fakes agent: local natural language requests against workspace resources

[Bruce Mcpherson]

gf_agent is an interactive automation agent designed for the Gemini CLI that enables users to execute Google Workspace tasks locally. By leveraging the gas-fakes framework, it allows for seamless automation of tasks like managing spreadsheets, emails, and calendars directly from a local environment using natural language.

The key point is that you need no local scripts and no Apps Script IDE deployments. It leverages gas-fakes buit in authentication, and is installed as part of the gas-fakes init process. j

Once installed - Just ask for workspace things to happen directly from germini cli. Since it actually just generates apps script code behind the scenes, you can of course capture that code as the basis for other apps.

Some examples:

• Summarise Data: “Find latest 5 emails from ‘Martin Hawksey’ and summarize them in a Google Doc”.
• Manage Files: “Create a sheet called ‘Todays drive files” and add any files on Drive modified today to it”.
• Schedule Events: “Add a meeting to discuss gf_agent with martin Hawksey to my calendar for tomorrow at 10am”.
• Multiple services and image manipulation: “get the content of                                                                          https://ramblings.mcpher.com/resurrecting-scriptdb-nosql-database-for-apps-script/ and create a google document. Make  a copy of that document and reduce all the images to 25% of their current size.         
• Process Spreadsheets: Using my airports spreadsheet, from the sheet with the most data, find the highest 5 airports in the world, convert their elevation to metres and show their distance from London in kilometres.

article: https://ramblings.mcpher.com/gas-fakes-agent/

[alamin Khan]

Hello Bruce,

Thank you for your email about gf_agent. I have a few questions regarding its installation process as well as its limitations. Could you elaborate more on how it interacts with existing Google Workspace accounts and if there are any prerequisites? I appreciate your help!

Sincerely,
[Your Name]

[Bruce Mcpherson]

Hi

There are these steps

. Install globally with npm

. Create a manifest apps script.json with the scopes you will want to use

. Next there is a choice depending on the kind of auth you want to use. Application default credentials .. adc .. or domain wide delegation .. dwd. You can use dwd if you have permission to do this using domain admin ui. This will automatically create a service account with the scopes in your manifest and will act as if it was you and tell you what to do to enable dwd in the admin console. Alternatively, Adc will also act as you, but many scopes are sensitive and need a little more google oauth credential set up in the cloud console. All this is documented on the getting started docs in the repo.

. gas-fakes init will start a dwd dialog, gas-fakes init —auth-type adc will start an adc dialog. 

. Next gas-fakes auth will take you through the usual google consent screens. This will set up your local environment with a permanent auth. The login persona you choose at this point will be the one that acts on your workspace assets.

. All this is generally a one off exercise unless you need to modify the scopes you need. 

So essentially, whoever you login as during the auth process is who gas fakes will pretend to be from that point on.

The agent skills are installed either manually as per the docs, or as part of the gas-fakes init process if you choose that option.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/DBB893D7-67F4-4C04-BE4B-1D5DF7301E90%40gmail.com.