Prompt

Tech & AI at WorkPromptIn a pack

Office Automation Decision — Power Query, VBA, Apps Script or a Proper Tool

Decides the right tool for an office automation — formulas, Power Query, VBA, Apps Script, Power Automate or a real database or app — considering maintainability, security and who will own it.

  • Role-Based
  • Step-by-Step
  • Constraints
  • Structured Output

Opening lines · ~297 words in full

ROLE: You are a business systems analyst who has inherited too many fragile spreadsheet macros. You pick the simplest tool the team can maintain, and you know when a spreadsheet has outgrown itself.

CONTEXT: The process to automate and how often it runs: [PROCESS]. …

Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved

How to use it

  1. Read it, then replace anything in [BRACKETS] with your details — the more concrete the context, the sharper the answer.
  2. Copy it (or download the .md) and paste it into the AI you already use — it knows your work, so that is where the prompt does the most.
  3. Want a sharper answer? Ask the AI to check its own draft against your brief before it replies — that is self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Step-by-Step

Forces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.

Learn this technique
Constraints

Sets the rules and boundaries — tone, length, what to avoid — that keep the output on-target.

Learn this technique
Structured Output

Pins the response to a defined structure so it drops straight into your workflow.

Learn this technique

Works with

Any chat AI — ChatGPT, Claude, Gemini, Copilot, Grok, Mistral or a local model. The structure does the work, so you are not tied to one vendor or one model version.

New to structured prompts? Start with how to prompt AI, the RCTCO prompt framework this prompt is built on, and role prompting examples.

More in Tech & AI at Work

Mint Parameters and Launch-Day ChecklistBuilds the pre-launch checklist for deploying and minting a token — contract parameters, permissions, test runs on testnet, multisig setup and the go/no-go call — so nothing is decided live on launch day.Spend Policy for an AI Agent That Can PayDesigns the spending rules for an AI agent with a wallet or payment card — limits, allow-lists, approval thresholds, velocity checks and kill switch — written so engineers can implement and auditors can check them.Audit Log Design for Agent Wallet ActionsDesigns the audit log for every action an AI agent takes with funds — intents, tool calls, approvals, results — so support, finance and auditors can reconstruct exactly what happened and why.DAO Governance Proposal Draft With Clear OptionsTurns a rough idea into a governance proposal voters can judge in five minutes — problem, specification, costs, risks, alternatives and the exact on-chain action — ready for forum discussion.