BestPromptFinder

Google Sheets Apps Script to Automate a Task

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

Write a Google Apps Script for my Google Sheet. My sheet: tab names [ ], columns [A: date, B: name, C: amount...], roughly [N] rows. What I want automated: [e.g. email me every Monday with last week's totals / move rows marked 'Done' to an Archive tab / create a Google Doc invoice for each new row / add a timestamp when a cell changes] When it should run: [on a button / on edit / daily or weekly trigger] Please: 1. Write the complete script with comments, using the column positions I gave and named constants at the top so I can change them. 2. Explain where to paste it (Extensions > Apps Script), how to save, authorise and test it, and how to set the trigger, step by step for a non-programmer. 3. Add a 'test mode' that logs what it would do without changing data or sending email. 4. Handle empty rows and wrong data types without crashing. 5. Tell me what permissions it will ask for and why. Never delete data; archive or copy it instead.

Why this prompt

• Hand-picked, editorially reviewed prompt
• Written for ChatGPT, Claude, Gemini

Source

Created by BestPromptFinder — editorial prompt, not user-generated. See our content & source policy.

Related Coding prompts