- Prompt at a glance
- Category
- Text & chat
- Works with
- Claude · ChatGPT · Gemini
- Length
- 88 words
- Fields to fill
- DESCRIBE THE TABS AND COLUMNS
- Last updated
Automate Google Sheets with Apps Script
This prompt writes a Google Apps Script for your sheet, such as a daily email of rows due today. It adds a menu item to run it by hand, an optional timed trigger and clear steps to test it on a copy.
Act as a Google Apps Script expert. My sheet: [DESCRIBE THE TABS AND COLUMNS] What I want automated: [e.g. every morning, email me rows where due date is today] Write the full script with comments, a menu item to run it by hand, and a time-driven trigger if it should run on its own. Handle empty rows and bad dates. Tell me exactly where to paste the code, what permissions Google will ask for and why, and how to test it on a copy of the sheet first.
Test on a copy of your sheet. Scripts can change many rows at once, and undo does not always catch it.
From copy to answer in four steps
- 1
Open Claude and start a new chat.
- 2
Paste the prompt.
- 3
Replace each [BRACKETED] field with your real details and paste in your own text where asked.
- 4
Reply with follow-ups such as "make it shorter" or "make it sound more like me".
About this prompt
Which AI tools work with this prompt?
It is written for Claude, ChatGPT and Gemini. Paste it into your preferred tool and adjust the wording if the result is off.
What do I need to fill in?
Replace the field before you send it: DESCRIBE THE TABS AND COLUMNS. Each field shows an example in the prompt.
Should I paste private information into the prompt?
Only what the task needs. Remove names, contact details and other sensitive data before pasting a resume or document into any AI tool.
