Create Google Sheets automation with Apps Script for school administrative tasks like attendance, grading, and reports.
Act as a Google Workspace automation expert for schools. Create a Google Sheets solution with Apps Script for [ADMIN_TASK] at [SCHOOL_TYPE] school with [STUDENT_COUNT] students. Provide: sheet structure and layout design, formulas for automated calculations, Apps Script code for: automated email notifications to parents, PDF report card generation, attendance summary triggers, custom menu additions, data validation rules, protected ranges for different staff roles, IMPORTRANGE connections between sheets, and conditional formatting for visual indicators. Include setup instructions, troubleshooting guide, and Google Sheets performance optimization tips for large datasets.
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash, Claude 4 Sonnet.
Describe [ADMIN_TASK], [SCHOOL_TYPE], and [STUDENT_COUNT] for the automation solution.
Initial release
Sign in and download this prompt to leave a review.