Task prompt · Coding
Write a Google Apps Script automation
by Agent Yard TeamAutomate Google Sheets, Docs and Gmail.
Use cases
- Automate Google Sheets, Docs and Gmail.
- Reuse it as often as you like: fill in the blanks (task, e.g. emails me a summary of new rows in a sheet every morning; columns) with new details and copy again.
- With ChatGPT, Claude, Gemini and more, the AIs that support what this prompt needs.
Featured in: Best ChatGPT prompts for AI agents and automation.
How to use it
- Open chatgpt.com or claude.ai (or another AI listed here).
- Fill in the highlighted blanks ([TASK, E.G. EMAILS ME A SUMMARY OF NEW ROWS IN A SHEET EVERY MORNING], [COLUMNS]) below, or edit them after pasting.
- Copy the prompt, paste it into the chat and send.
Fill in the blanks (optional)
Prompt
Write a Google Apps Script that [TASK, E.G. EMAILS ME A SUMMARY OF NEW ROWS IN A SHEET EVERY MORNING]. Sheet structure: [COLUMNS]. Include setup steps (where to paste it, permissions, adding a time trigger), the full script with comments, and how to test it safely.
One email a week
The Weekly is presented byyour brandSponsored · openThe best new prompts and personas, nothing else.