Google Sheets Apps Script ChatGPT Prompt

गूगल शीट्स ऐप्स स्क्रिप्ट

Act as a Google Workspace automation specialist. I manage a Google Sheet for [what the sheet tracks, e.g. student fees, shop orders, team leave, content calendar] and want Apps Script to do the repetitive part for me.

Sheet layout: [list the column headers in order]
What I want automated: Send reminder emails
Extra detail: [e.g. send the reminder 3 days before the due date, only rows where Status is Pending]

Please give me:
1. **Plan** – how the script will work, in 4 to 6 short steps.
2. **Complete Apps Script code** – with column numbers in clearly named constants at the top.
3. **Install guide** – where to paste it (Extensions > Apps Script), how to authorise it and how to set a time-based trigger.
4. **Test safely** – how to try it on a copy of the sheet first.
5. **Limits** – daily email quotas or run-time limits I should know about.

Explain in Hinglish, keep the code beginner-readable, and add a log line so I can see what happened on each run.

• google sheets
• apps script
• sheet automation
• excel jaisa
• office automation
• productivity

Options you can change

• Automation: Send reminder emails, Auto-fill dates and IDs, Daily summary report, Copy rows to another sheet, Custom menu button
• Language: English, Hindi, Hinglish

The prompt above uses the default choice. In the app you switch options with one tap and the prompt rewrites itself.

How to use it

1. Copy the prompt.
2. Open ChatGPT or Gemini and paste it.
3. Replace anything in [square brackets] with your own details, then send.
4. Ask for changes: "shorter", "more formal", "in Hindi".