Pack 354 · Developer stacks · 13 items
Excel VBA & Apps Script Automation Pack
10 prompts + 3 skills for office teams automating Excel and Google Workspace — real jobs from the week, with the steps, rules and output an expert would ask for. 7 written for this work, 6 more from the library.
€4one-time · 13 prompts & skills · ≈ €0.31 each
- Instant download
- Yours to keep
- Works in ChatGPT, Claude, Gemini
What's inside
Made for office teams automating Excel and Google Workspace
6 prompts + 1 skill- PromptExcel VBA Macro for a Repetitive Weekly Report
Writes a robust VBA macro that automates a weekly report — importing files, cleaning data, building summaries, formatting and saving — with error handling and instructions for non-programmers.
- PromptGoogle Apps Script Automation for Google Sheets
Builds an Apps Script automation for Google Sheets — triggers, form responses, email notifications, data cleaning, and scheduled reports — with quotas, permissions and error logging handled.
- PromptOffice 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.
- PromptLegacy Excel Macro Audit and Clean-Up
Audits an old, undocumented VBA workbook — what each macro does, risks, hard-coded values, broken references — and produces documentation and a safer, cleaner version.
- PromptGmail and Calendar Automation With Apps Script
Automates routine Gmail and Google Calendar work — labelling and filing emails, drafting replies from templates, creating events from sheets, sending reminders — safely and within quotas.
- PromptSpreadsheet Data to Automated Dashboard Pipeline
Turns manual spreadsheet reporting into an automated pipeline — consistent data structure, cleaning, scheduled refresh and a dashboard — with checks so the numbers stay right.
- SkillOffice Automation Developer
A standing automation developer for office teams: Excel VBA, Power Query, Google Apps Script, Gmail and Calendar workflows and reporting pipelines — safe with data, documented, and maintainable by non-programmers.
Bonus prompts & skills
4 prompts + 2 skills · free with the packFrom the wider PromptCorrectly library, picked for the same work. They come in the same .zip and the start file tells your AI when to use each one.
- SkillWorkflow Automation Opportunity Finder
Audits a manual workflow and pinpoints high-ROI automation steps, tools, and the trigger-action logic to build.
Library · In a pack - SkillOperational Dashboard & Metric Selector
Selects the few metrics worth tracking for an operation and designs a dashboard that drives action, not vanity.
Library · In a pack - PromptProcess Automation Opportunity Assessment
Evaluates which workflows to automate first by scoring volume, rules-clarity, error-cost, and feasibility, with an implementation path.
Library · In a pack - PromptWorkflow-To-Agent Automation Opportunity Mapper
Analyzes a human workflow and identifies which steps to automate with an agent, which to keep manual, and the rollout order.
Library · In a pack - PromptTranslate Business Questions Into SQL
Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.
Library · Free - PromptKPI Dashboard Design & Metric Tree
Designs a focused KPI framework with a metric tree linking a north-star goal to leading and operational drivers.
Library · Free
What you download
Everything comes in one pack (.zip) you keep. Start with 00-GIVE-THIS-TO-YOUR-AI.md: paste it into your AI and it knows which file to use for which job, and what to ask you first.
More for Productivity · Data Analysis & Excel · Business Plans & Strategy
excel-vba-apps-script-automation/ ├─ 00-GIVE-THIS-TO-YOUR-AI.md ├─ START-HERE.md ├─ TIPS-AND-FOLLOW-UPS.md ├─ AI-CHEAT-SHEET.md ├─ prompts/ │ ├─ 01-excel-vba-macro-for-repetitive-report.md │ ├─ 02-google-apps-script-sheets-automation.md │ ├─ 03-power-query-vs-vba-vs-script-decision.md │ ├─ 04-legacy-excel-macro-audit-and-cleanup.md │ ├─ 05-gmail-and-calendar-automation-with-apps-script.md │ ├─ 06-spreadsheet-to-dashboard-automation-pipeline.md │ ├─ 07-process-automation-opportunity-assessment.md │ ├─ 08-workflow-to-agent-automation-opportunity-mapper.md │ ├─ 09-translate-business-questions-into-sql.md │ └─ 10-kpi-dashboard-design-metric-tree.md └─ skills/ ├─ office-automation-developer/SKILL.md ├─ workflow-automation-opportunity-finder/SKILL.md └─ operational-dashboard-metric-selector/SKILL.md
A look inside
ROLE: You are an Excel automation specialist who writes macros office teams can trust. Your code handles messy inputs, explains itself with comments, never silently overwrites data, and comes with instructions a non-programmer can follow. CONTEXT: The manual process done every week, step by step: [MANUAL_PROCESS]. Input …
Questions
What do I get?
A .zip with 10 prompts + 3 skills: 6 prompts + 1 skill written for office teams automating Excel and Google Workspace, plus 4 prompts + 2 skills from the wider library that fit the same work. Each prompt is a ready .md file, each skill a SKILL.md folder, plus 00-GIVE-THIS-TO-YOUR-AI.md (a start file your AI reads first), START-HERE.md, TIPS-AND-FOLLOW-UPS.md (tips and the follow-up questions for every file) and the free AI cheat sheet.
How do I use it?
Open ChatGPT, Claude or Gemini and paste 00-GIVE-THIS-TO-YOUR-AI.md, or attach the folder. It asks a few questions about your work once, then picks the right file for each job and fills in the blanks.
Is it a subscription?
No. €4 once, and the files are yours to keep. Nothing renews.
How do I download it?
Right after checkout, on the confirmation page. Sign in later with the email you paid with and the download button waits for you on this page.
Why this price?
A pack is priced by the items written for its trade: €0.50 a prompt and €1 a skill. The 6 bonus items come free on top. This one is €4 for 13 prompts and skills, about €0.31 an item.