Free AI Prompt Templates for Google Apps Script

A prompt cheat sheet for getting real Google Apps Script code out of an AI model instead of something that looks right and throws on the first run. It is not a script you install — it is the prompting method, with the templates, laid out so you can use it on every project after this one.

What it covers

The five pillars a prompt needs before an AI can write working Apps Script, shown against a bad prompt and a good one on the same task so the difference is visible rather than asserted. Each model is handled on its own terms — ChatGPT, Gemini, Claude and DeepSeek do not respond to the same phrasing — and three techniques that matter most for spreadsheet work are demonstrated: few-shot, role prompting and chain-of-thought. There is a section on debugging existing Apps Script with AI, which is where most people waste the most time, and a walkthrough of setting up a Gemini Gem as a permanent Apps Script assistant.

Highlights

• The 5 pillars of a perfect prompt, with live before-and-after
• Per-model prompting styles for four AI tools
• Few-shot, role and chain-of-thought prompting for Sheets work
• Debugging Apps Script with AI, the right way round
• 5 golden rules for coding with AI
• A Gemini Gem set up as your own Apps Script assistant
• Prompt cheat sheet web app with ready-made templates

Who it is for

Apps Script developers and Google Sheets power users who already use AI to write code and keep getting answers that need three rounds of correction. It is also the fastest way in for someone learning to build on Sheets, because the prompts carry the structure you have not learned yet.