Task prompt · Coding

Write a Google Apps Script automation

by Agent Yard Team

Automate Google Sheets, Docs and Gmail.

You'll attach

Text only

Works with

ChatGPTClaudeGeminiGrokCopilotGrok Bot

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.

How to use it

  1. Open chatgpt.com or claude.ai (or another AI listed here).
  2. 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.
  3. Copy the prompt, paste it into the chat and send.

Fill in the blanks (optional)

Prompt

Remix
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 best new prompts and personas, nothing else.

The Weekly is presented byyour brandSponsored · open

More Coding prompts

Footer partner · openThis strip runs at the foot of every page. One partner at a time.Ask about it →