Once you know the basics, AI can rely on your documents, plug into your tools, act on your behalf and run on its own. Here is how to climb the steps, one at a time.
Each level gives the AI more power… and calls for a little more care.
Level 1
Ask better to get better.
Turn on thinking mode for complex problems, structure your requests, give the AI a role and ask it to critique its own work or to ask you questions before answering.
Level 2
Fewer hallucinations, more relevance.
Give the AI your own documents as reference, or let it run a real investigation on the web before handing you a sourced report.
Level 3
The AI fetches information where it lives.
With connectors, the AI reads your emails, calendars and files to answer questions like “What did I promise client Smith last week?”.
Level 4
You set the goal, the agent handles the steps.
An agent plans, uses tools, checks and retries until the result is reached: building a complete file, filling in an online form, fixing and testing a program.
Level 5
AI works even when you are away.
With the API, AI becomes a building block of your automations: sorting emails every morning, summarising form responses, enriching a Sheets table. Without code, Workspace Studio does it too.
A few lines of Apps Script are enough to add AI to your spreadsheets. Paste this code into Extensions › Apps Script, save your API key in the script properties, then call the function from your automations.
/**
* Summarises a text in 3 points with the Gemini API.
* The API key is stored in script properties (never in the code).
*/
function summariseWithGemini(text) {
const key = PropertiesService.getScriptProperties().getProperty('GEMINI_API_KEY');
const url = 'https://generativelanguage.googleapis.com/v1beta/models/gemini-flash-latest:generateContent';
const response = UrlFetchApp.fetch(url, {
method: 'post',
contentType: 'application/json',
headers: { 'x-goog-api-key': key },
payload: JSON.stringify({
contents: [{ parts: [{ text: 'Summarise in 3 points:\n' + text }] }]
}),
muteHttpExceptions: true
});
const data = JSON.parse(response.getContentText());
return data.candidates?.[0]?.content?.parts?.[0]?.text ?? 'No answer';
}A deep research run every Monday on your industry, delivered as a sourced report.
A script sorts incoming emails by priority and prepares draft replies.
Attach an accounting export: the AI spots anomalies and produces the charts.
Gemini in Meet writes the minutes and the action list for you.
“Read my calendar and unread emails, and tell me what needs my attention.”
Describe the tool you dream of: the AI builds it, tests it and explains it to you.
The more autonomous the AI, the more these rules matter.
Approve actions that commit you: sending an email, paying, deleting, publishing.
Only connect the tools you need, with limited permissions.
Personal and confidential data only on business plans that comply with data protection law.
A web page or email can hide instructions (“prompt injection”).
The API is billed per use: set caps and avoid endless loops.
Review results and keep a record of what the AI did.
An assistant answers your questions one at a time. An agent receives a goal and chains the steps itself: searching, using tools, checking, fixing, until the result is reached.
Not always. Some connectors and NotebookLM are free. Agents, deep research and high limits usually require a subscription. The API is billed per use.
The risk can be managed: use a business plan, only grant the access needed, keep human approval for any action that commits you, and be wary of content from strangers.
An open standard for plugging an AI into a tool (a database, a CRM, business software) in a uniform way. An MCP connector written once works with Claude, Gemini and other compatible assistants.
Pick a repetitive task that takes you at least an hour a week, test it at level 1 or 2, then move up a level once the result is reliable. A small win beats an abandoned big project.
I automate Google Workspace every day with Apps Script and AI. I can help you find the right use cases, train your team or build your first automations.
Développeur freelance spécialisé dans l'optimisation des flux de travail professionnels, le développement d'add-ons sur-mesure (Google Sheets, Docs, Gmail) et l'intégration de modèles IA (Gemini).
Updated on