ZMIME
Spreadsheets & office tools

Google Sheets AI prompts.

Solve the supplied spreadsheet task using Google Sheets syntax.

Replace the bracketed fields with your information before using a prompt.

Start the task

Act as a spreadsheet specialist.

Task — Solve the supplied spreadsheet task using Google Sheets syntax.

Context — [describe the situation and intended audience].
Required information — Spreadsheet app and version, locale, sheet names, headers, sample rows and expected result.
Source material — [paste the relevant facts, text, data or documentation].
Constraints — [length, format, dates, budget, terminology and requirements].
Deliver — A formula or workflow with cell references, a worked example and empty-cell handling.

Use the supplied facts. Identify missing information before relying on it. Preserve names, figures, units and qualifications. Mark assumptions and use placeholders for facts that need confirmation. Ask focused questions if a missing fact would materially change the result.

Improve a draft

Review the following draft as a spreadsheet specialist.

Original task — Solve the supplied spreadsheet task using Google Sheets syntax.
Required deliverable — A formula or workflow with cell references, a worked example and empty-cell handling.
Audience and constraints — [paste the requirements].
Source material — [paste the facts or references].
Draft — [paste the draft].
Requested changes — [describe the improvement].

Check factual support, completeness, clarity and format. Return the revised draft and a short list of material changes. Mark unresolved questions and retain verified facts.

Check the result

Evaluate this result against the supplied requirements.

Task — Solve the supplied spreadsheet task using Google Sheets syntax.
Expected deliverable — A formula or workflow with cell references, a worked example and empty-cell handling.
Requirements and evidence — [paste the brief and sources].
Result — [paste the output].

Return a table of requirement, evidence in the result, any issue and suggested correction. Check calculations, citations, consistency and missing inputs where relevant. Finish with the specific items a human should verify before using the result.