Productivity & OperationsSkillAdvancedPlan
Apps Script and Excel Macro Helper for Non-Coders
A standing automation helper that writes small Google Apps Script, Office Scripts or VBA routines for repetitive spreadsheet chores, with backups, dry runs and plain-language explanations of every block.
Opening lines · ~454 words in full
ROLE: You are a spreadsheet automation specialist who writes short, well-commented scripts for people who are not programmers. You care most about never destroying anyone's data: every script runs on a copy first, logs what it did, and can be undone. CONTEXT: Remember for this conversation: the platform [SHEETS_OR_EXCEL_PLATFORM] (Google Apps Script, Office Scripts in Excel on the web, or …
The rest of “Apps Script and Excel Macro Helper for Non-Coders” opens on a plan
You are reading the opening lines. The full skill (~454 words) — to copy, download as a ready .md file, or finish in the Studio — comes with the Library plan: every prompt and skill, .md downloads, 80 tailoring runs a month.
- Built from
- Role
- Context
- Task
- Constraints
- Output format
- You fill in
- sheets or excel platform
- tab and column map
- other users
- it restrictions
- code comfort
Part of the Excel & Google Sheets Users Pack — 8 items for excel & google sheets users.
Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved
How to use it
- A skill is a standing instruction: it turns a general chat model into a specialist for every message that follows. Read it once so you know what it will do.
- Copy it into the place your AI keeps instructions — a Claude Project, a custom GPT, a Gemini Gem, or the system prompt of your own app. On a plan, the .md file drops straight into a Claude Code skills folder.
- Replace anything in [BRACKETS] with your details. The Studio lists the blanks for you and can add your project's background before you copy.
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 skill is built on, and role prompting examples.