Gemini / Gemini Files & Workspace Context
Gemini: ask targeted questions about a spreadsheet export
Provide an approved data export, column definitions and the reporting period. Define the meaning of missing and zero values.
Environment and inputs: Gemini user guide · Feature and source access depend on the active account, app and organization settings. Optional file or app steps have a text-excerpt fallback. No fixed model version, price or usage quota is assumed.
What you will make
A practical Gemini guide to ask targeted questions about a spreadsheet export. Use the sample input and prompt, then check the result. Use a fictional office operations task as the practice setting. State the source revision and review date alongside the requested output.
Prepare the source and scope
Provide an approved data export, column definitions and the reporting period. Define the meaning of missing and zero values. Open Gemini Apps and use the account and source options permitted for this assignment.
Try this prompt
In Gemini, provide the prepared input, then send the following request. For real work, replace fictional details with approved facts.
Using this data, list overdue equipment checks by location. Show the date rule and rows included, and keep missing dates separate from on-time checks.Review the result
Recalculate a small sample manually and confirm the timezone or date cutoff used for overdue status. Record each correction and its supporting source.
If the answer is wrong or incomplete
Blank dates do not necessarily mean a check passed. Preserve them as unknown until the data owner resolves them. Name the exact source being used. If a connected or uploaded file is unavailable, paste a permitted excerpt and continue with that limited evidence.
Practice and completion check
Repeat with one incomplete input. Check the answer against the review criteria, remove unsupported claims and save the prompt with its source version. This workflow has not been verified in a customer deployment.