Need a quick summary of my CSV data and a ready‑to‑use chart
A quick description plus a draft visual, using Gemini's multimodal strengths.
Google's AI — built into Docs, Sheets, and Gmail
Google DeepMind's assistant (2023) — built into Google Workspace, multimodal by default, with a context window up to a million tokens (Gemini 2.5 Pro).
Gemini (Google DeepMind) is the frontier chatbot wired into Google Workspace: it drafts a formatted Google Doc, fills a Sheets table, or writes a Gmail reply with no copy-paste, is multimodal by default, and reads up to a million tokens at once. → Workspace integration is the real differentiator; for pure coding or deep literature search, Claude or Perplexity outperform it.
Gemini is Google's frontier chatbot, wired straight into Google Workspace. Below: where its Docs / Sheets / Gmail integration wins, and where another tool does better.
Working inside Google Docs, Sheets, and Gmail with no copy-paste; digesting a whole thesis PDF or an image in one prompt.
Its edge disappears the moment you leave Docs, Sheets or Gmail — outside Workspace, reach for a tool built for the job instead.
Free tier (Gemini 2.5 Flash) at gemini.google.com. Google AI Plus $20/mo, Pro $30/mo, Ultra from $50/mo; also bundled in Workspace Business Standard.
The model selector at the top of the Gemini chat window is where you pick which model answers your prompt — 3.5 Flash is the free-tier default for everyday questions, and 3.1 Pro is the heavier option you switch to mid-conversation when a task needs deeper reasoning.
Open Gemini with a Google account, use the free tier and run a real research prompt
I'm a biologist preparing a journal club. In plain language, explain the mechanism of CRISPR base editing vs. prime editing, then give me three discussion questions a non-specialist audience could engage with.Just type it into the prompt bar at gemini.google.com — no setup, no API key. Gemini answers in whatever language you write in.
The prompt itself is the control surface here: giving Gemini a role, an audience, and an output format in the same message shapes the answer before it is generated, and refining in the same thread lets you correct one part without re-explaining the whole task.
Do this first Complete a Gemini research task
Generate sharper answers by assigning a role, audience and output format then refining within the same conversation
You are a grant reviewer for the DFG. Here is my one-paragraph project summary: [paste]. Critique it as a reviewer would: list the three weakest points, then rewrite the paragraph to address them. Keep it under 150 words.Give it a role (grant reviewer), the material (your summary), the task (critique + rewrite), and a format constraint (under 150 words).
The Upload button (the paperclip in the prompt bar) lets Gemini read a file directly rather than you pasting its contents into the chat, while the separate Connect Google Workspace step is what lets it search your own Gmail, Drive and Docs instead of only the file you attached.
Do this first Craft targeted Gemini responses
Upload a PDF, image or other file and ask Gemini questions that draw on your Gmail, Drive and Docs
[Upload a 40-page review PDF] Summarise the key findings in five bullets, then list the three references cited most often as foundational to this field, with the exact section each appears in.Click the upload button (the + / paperclip in the prompt bar) and attach the file before sending. Gemini reads the document itself — you don't paste its contents.
The arrow chip at the end of a grounded Gemini answer opens the "Related content and sources" panel — it is the mechanism that turns a claim into something traceable back to an actual web page rather than the model's own paraphrase.
Do this first Ask Gemini questions using your own files and Google Workspace
Receive up‑to‑date facts with clickable source links you can verify yourself
What are the most recent (2025–2026) clinical trial results for lecanemab in early Alzheimer's disease? Give me the headline outcomes and link the primary sources you used.Ask for recent, factual information and explicitly request sources. Some Gemini responses are grounded on live Google Search results.
The Describe your image box on the image-generation screen turns a text prompt into a picture, and the same screen accepts an uploaded file for Gemini to analyse instead — the Create image chip is what tells it to render an image rather than reply with text.
Do this first Get web‑sourced answers from Gemini
Generate a diagram from text and interpret an uploaded picture using Gemini
Generate a clean, labelled schematic diagram of the central dogma (DNA → RNA → protein) suitable for a lecture slide, with clear arrows and no decorative clutter.Type the request; Gemini generates the image inline. Image generation is available on the free tier.
A Gem is a saved persona with standing instructions (and optionally reference files) that you reopen instead of retyping a prompt; Canvas is a separate side-by-side editor for drafting and revising a document section by section rather than through chat replies.
Do this first Create and analyse images with Gemini
Build a Gem for a recurring task and use Canvas to write and revise longer pieces in a live editor
Create a Gem called 'Methods Editor'. Instructions: You rewrite draft Methods sections to match the style of a high-impact biology journal — past tense, passive voice, precise reagent and concentration detail, no marketing language. Always ask for the organism and technique if I don't state them.Open the Gems area, choose 'create your own', paste these instructions, and optionally upload reference files. Then chat with the Gem whenever you need that job done.
The Gemini sidebar is the same assistant, docked inside a Google Workspace app instead of its own tab. Inside Sheets it can read the range you have selected — so the selection, not the prompt, is what tells it which numbers to describe, and what a chart it drafts is drawn from.
Do this first Create a reusable assistant and edit drafts side‑by‑side
Create a text summary and an editable bar chart directly from a CSV file opened in Google Sheets
A Gem is a saved prompt with a name. Everything you would otherwise retype — the instructions, the format, the role — is stored once and run from an icon, which is what turns a good one-off prompt into something you use every week.
Do this first Generate a written overview and bar chart from CSV data in Sheets
Execute your recurring Gemini workflow without re‑typing the prompt
Deep Research is a Gemini mode that first drafts a multi-step research plan for your approval, then browses and synthesises sources on its own — it behaves less like a chat reply and more like an analyst you brief, watch work, and then check.
Do this first Run a saved Gemini assistant with a single click
A complete, sourced research report is created, approved, and exported for further formatting
Deep Research: the current landscape of mRNA vaccine platforms for solid tumors — leading candidates, delivery systems, key 2024–2026 trial results, and the main open challenges. Produce a structured report with sources.Select 'Deep Research' in the prompt bar, then enter the query. Deep Research is available on the free tier.
Best viewed on desktop — tap Enlarge to read the numbered controls.
19 outcomes in all — one per recipe below.
Need a quick summary of my CSV data and a ready‑to‑use chart
A quick description plus a draft visual, using Gemini's multimodal strengths.
Need a quick diagram from a text description
A draft visual in seconds you iterate on, instead of fighting a drawing tool.
Patient handout needs a new language
A quick draft translation that helps a patient understand their care between visits — reviewed against the original before use, and via a certified translator for anything legally or clinically sensitive.
Need a quick map of a topic while you work elsewhere
A broad first map of a topic with links, assembled while you do something else.
Need to narrow down dozens of resumes fast
A ranked shortlist with a one-paragraph rationale per candidate, turning a 2-hour CV screen into minutes.
Lots of free‑form survey responses
A thematic breakdown of qualitative feedback in minutes, instead of days of manual coding.
See agreements, disagreements and takeaways across docs
A synthesis across a stack of papers instead of reading each one cold, without ever leaving Drive.
Compare financial terms from two contracts without downloading PDFs
A structured comparison table of every financial clause across both documents, pulled right out of your inbox.
A complete, accurate answer assembled from your own docs, not from the model's general knowledge.
Need a repeatable task without re‑typing prompts
A one-click specialist instead of re-typing the same setup prompt.
Escalation thread full of messages
A manager or second-line agent can read the situation in 2 minutes instead of scrolling 40 messages.
Need a competitor snapshot for calls
A one-page battlecard your reps can actually use on a call, built in minutes from public material.
Want free‑tier AI models but don’t have an account
You can start using Gemini instantly with any Google account and get immediate access to its free-tier models
Don’t know which tone to use
Specifying a role and target audience changes Gemini's tone and depth dramatically
Refine a reply without starting over
Continuing the conversation lets Gemini keep prior context, so each refinement builds on the previous answer
Can't copy text from a screenshot
Images are converted to searchable text, letting you query screenshots of figures or tables
When you need to know where info comes from
Adding a request for page or section forces Gemini to cite the exact spot in the document
You receive answers that include clickable citations you can verify yourself
You confirm whether the answer's claim matches what the original page actually says
You catch paraphrase errors or hallucinations before trusting the summary
Need a quick diagram or infographic from a single sentence
You can turn a single sentence into a labelled diagram or infographic instantly
Need to change just a detail in a picture
You can change specific details without regenerating the whole picture, preserving correct elements
Drafting a long document but want real‑time AI help
Use Canvas to draft and revise long documents with live Gemini feedback instead of scrolling through chat
Draft Methods need journal‑style formatting
A pre-configured Gem can automatically reformat Methods sections to match high-impact biology journal conventions
Need to turn a research report draft into something interactive
Convert a research report draft in Canvas into quizzes, infographics, or mini web pages for teaching or onboarding
Need a research outline you can check before it runs
You control the research scope by approving or editing the AI-generated plan before it runs
When I need a detailed research report with citations
The agent delivers a ready-to-use multi-section report with citations and optional audio
Need a ready‑to‑use slide deck from a research report
Exporting to Canvas lets you repurpose raw research into slides, infographics, or quizzes
Need a deep dive on mRNA vaccine platforms for solid tumours
A well-crafted prompt guides the agent to produce a focused, sourced report on a complex topic
ChatGPT excels at breaking down difficult concepts into clear, multi-step explanations
Select the tool that best matches your workflow: Gemini for live web data, ChatGPT for deep explanations
The context window is the total amount of text Gemini can read in one conversation. Free users get a sizable window (enough for a lecture handout or a short paper). Paid subscribers get a much larger window — up to around a million tokens, roughly a thousand-plus pages — letting them feed in entire textbooks or large datasets in one session.
Yes, Gemini is multimodal: you can upload an image and ask questions about it in plain language. Photograph a diagram from your textbook, a chart from a paper, or a microscope image and ask Gemini to describe what it shows, label structures, or explain a process. For highly specialised microscopy images it may still make errors, so cross-check any identifications with your course materials.
The 'Flash' model is faster and optimised for quick, everyday questions. The 'Pro' model is slower but performs much better on complex, multi-step reasoning — detailed essay analysis, interpreting experimental data, or understanding a complicated mechanism. For routine questions in class, Flash is fine; for deep analytical work, Pro gives noticeably better results. Free users get the fast model by default; the Pro model requires a paid subscription.
Yes. You can upload multiple files per prompt, including PDFs, images, spreadsheets, and most document types. Gemini can summarise the content, answer questions about it, and generate charts from data within the files, on both web and mobile. The very large context window (enough for many hundreds of pages) is available on paid plans.
You can connect your Google Workspace account to Gemini (with 'Keep Activity' enabled and Smart features on). Gemini can then summarise emails and documents, find information in your Drive files, and create Calendar events — all by asking in plain language. Note that it cannot access images or comments inside files, and school or work accounts require administrator permission first.
Deep Research is a feature where Gemini automatically browses many websites, cross-references the results, and writes a structured, multi-page report with citations — similar to hours of manual research. Free users get a few Deep Research reports per month; paid subscribers get more and can also search their own Google Drive and Gmail content. The report can be exported to Google Docs and links back to all sources.
Gemini demonstrates superior reasoning and coding consistency, especially with large codebases and complex dependencies. It handles multi-step analytical problems better than competitors and maintains context across larger projects without degrading output quality.
Gemini natively supports a 1-million-token context window that accepts text, images, audio, video, and YouTube links simultaneously. This allows you to ask cross-modal questions without switching tools or manually transcribing content.
Need to combine web and Drive data into one report
Gemini’s research mode automatically searches the web, attaches Google Drive files or Notebook LM notebooks, and synthesizes them into a single editable canvas with source citations. This works because it combines live web retrieval with a structured output layout, saving hours of manual cross-referencing.
Need to make or understand images and short videos in a chat
Gemini natively generates images and short videos directly within the chat interface and can analyze uploaded media or YouTube links. This works because Google’s infrastructure tightly integrates its diffusion models and video synthesis tools with the conversational UI, eliminating the need for external generators.
Need answers from only my company docs
A Gemini ‘gem’ lets you feed an entire NotebookLM plus extra files into a custom LLM that answers queries using only your proprietary data, providing a secure, domain‑focused retrieval‑augmented generation (RAG) layer.
Meeting video, slides, and whiteboard photo?
Gemini can ingest mixed media (video, audio, images, text) in a single request thanks to its multimodal capability and 1 million‑token context window, allowing it to synthesize information from all sources at once.
The same set on /recipes, filtered by tool and role.
The single most current Gemini-for-work video. Watch this before deciding whether Gemini fits a research or comms workflow you already do in Google Workspace.
The plain beginner intro. Start here, then watch the Workspace and for-work videos to go deeper.
The signal-over-noise video from a top productivity creator. Watch to learn what's worth using, not everything that exists.
The context window is the total amount of text Gemini can read in one conversation. Free users get a sizable window (enough for a lecture handout or a short paper). Paid subscribers get a much larger window — up to around a million tokens, roughly a thousand-plus pages — letting them feed in entire textbooks or large datasets in one session.
Yes, Gemini is multimodal: you can upload an image and ask questions about it in plain language. Photograph a diagram from your textbook, a chart from a paper, or a microscope image and ask Gemini to describe what it shows, label structures, or explain a process. For highly specialised microscopy images it may still make errors, so cross-check any identifications with your course materials.
The 'Flash' model is faster and optimised for quick, everyday questions. The 'Pro' model is slower but performs much better on complex, multi-step reasoning — detailed essay analysis, interpreting experimental data, or understanding a complicated mechanism. For routine questions in class, Flash is fine; for deep analytical work, Pro gives noticeably better results. Free users get the fast model by default; the Pro model requires a paid subscription.
Yes. You can upload multiple files per prompt, including PDFs, images, spreadsheets, and most document types. Gemini can summarise the content, answer questions about it, and generate charts from data within the files, on both web and mobile. The very large context window (enough for many hundreds of pages) is available on paid plans.
You can connect your Google Workspace account to Gemini (with 'Keep Activity' enabled and Smart features on). Gemini can then summarise emails and documents, find information in your Drive files, and create Calendar events — all by asking in plain language. Note that it cannot access images or comments inside files, and school or work accounts require administrator permission first.
Deep Research is a feature where Gemini automatically browses many websites, cross-references the results, and writes a structured, multi-page report with citations — similar to hours of manual research. Free users get a few Deep Research reports per month; paid subscribers get more and can also search their own Google Drive and Gmail content. The report can be exported to Google Docs and links back to all sources.
Geminipromptcontext windowmultimodaltokenDeep ResearchDeep ThinkGemsCanvasGemini LiveAudio OverviewNotebookConnected AppsMemoryImagenGoogle AI ProGoogle AI UltraNotebookLMAsk, share, or report — over on the Heidelberg AI community forum.