Google Sheets et Gemini pour les PME

Ce qu'elle couvre

Un atelier pratique qui apprend aux dirigeants de petites entreprises à exploiter les fonctionnalités Gemini intégrées à Google Sheets : les formules =AI(), la barre latérale Gemini, et des automatisations concrètes pour catégoriser des transactions, synthétiser des réponses à des enquêtes, rédiger des e-mails personnalisés à partir de données tabulaires et construire un CRM léger. Les participants travaillent sur leurs propres feuilles de calcul et repartent avec des modèles prêts à l'emploi. Aucune expérience en programmation n'est requise.

À l'issue, vous saurez

• Write =AI() formulas that categorise transaction rows automatically without manual tagging.
• Use the Gemini sidebar to summarise a column of free-text survey responses in under two minutes.
• Generate a personalised draft email for each row of a contact list using a single formula.
• Build a functional lead-tracking CRM in Sheets using AI columns for status summaries and follow-up suggestions.
• Design clear, reusable prompts suited to spreadsheet cell contexts.

Sujets abordés

• Using =AI() and related Gemini formulas in Sheets
• Navigating the Gemini sidebar for contextual analysis
• Categorising financial transactions with AI formulas
• Summarising open-ended survey results at scale
• Drafting personalised emails directly from row data
• Building a lightweight AI-assisted CRM in Sheets
• Prompt crafting for spreadsheet tasks
• Data hygiene basics before applying AI functions

Modalité

Delivered in person or via live virtual session (Zoom/Meet). Participants must bring a laptop with their own Google Workspace account. Hands-on exercises account for roughly 70% of session time. Trainer shares a starter workbook in advance; participants are encouraged to bring one real spreadsheet from their business. Materials include a formula cheat sheet and three reusable template files.

Ce qui fait que ça marche

• Participants bring a real spreadsheet problem from their own business to work on during the session.
• The team agrees on shared prompt templates so AI outputs stay consistent across team members.
• A short weekly review habit is set up to spot-check AI-categorised or AI-drafted outputs before they are acted on.
• Google Workspace Gemini licences are activated and tested before the workshop day.

Erreurs fréquentes

• Applying AI formulas to messy, inconsistently formatted data and then blaming the AI for poor results.
• Using overly vague prompts in =AI() cells, producing inconsistent or hallucinated outputs.
• Skipping data hygiene steps and sending AI-drafted emails with wrong names or figures.
• Assuming Gemini in Sheets replaces a proper CRM for businesses growing beyond ~200 contacts.

Fournisseurs à considérer

• OpenClassroomsopenclassrooms.com →
• Le Wagonwww.lewagon.com →
• Jedha Bootcampwww.jedha.co →
• LinkedIn Learningwww.linkedin.com/learning →

Sources

• Use Gemini in Google Sheets — Google Workspace Learning Center →