Help / How to Use the AI Report Card Generator
This add-on helps teachers generate personalized, standards-based report card comments using AI. It supports Google Gemini, OpenAI, and DeepSeek. Below are detailed steps to set up your API key and use the tool effectively.
⚠️ Note: Some AI providers require payment or a billing setup to use their APIs. This add-on does not provide or resell API keys — you must obtain and manage your own.
Google Gemini (via Google AI Studio):
Sign in with a personal Google account (not all school accounts work).
Click "Get API Key" and create a project if prompted.
Copy the API key provided and keep it safe.
⚠️ If you're using a Google for Education account, your school IT admin may need to enable access to Google AI Studio and allow Gemini APIs.
Go to https://platform.openai.com/signup and create an account.
Once logged in, visit API Keys page.
Click "Create new secret key", name it, and copy the key.
⚠️ A ChatGPT Plus subscription does not include API access. The API is a separate service that requires setting up billing in the OpenAI Platform. New users typically receive $5 in free credits, valid for 3 months.
Go to https://platform.deepseek.com and log in or create an account.
In your dashboard, go to the API Keys section.
Click "Generate New API Key", name it, and copy it.
⚠️ DeepSeek may also require billing details or usage limits — check their dashboard for terms.
In your Google Sheet, click on the "AI Report Cards Comment Generator" menu.
Select your AI provider and paste the API key.
Click "Select Range" buttons to pick:
Headers Range: The row with column names (e.g., "Student Name", "Standard 1 Grade").
Data Range: The student data (below the headers).
Set your desired maximum character limit (default is 500).
Guided Prompt: Fill in structured fields like class name, standards, and grading methods.
Custom Prompt: Write your own AI prompt manually if you prefer full control.
Click "Preview and Generate".
Review the generated prompt and click OK to confirm.
The AI will create comments and write them to the target column, with a backup in the next column.
Load Example Sheet: Loads sample student data to experiment with.
View Terms of Service: Read data usage responsibilities and conditions.
Help / How to Use: Reopen this guide.
If you're stuck, please make sure:
Your API key is correct and active.
Your headers and data ranges don’t overlap.
You’ve selected the right AI provider and inputs.
This tool was built to save you time and help students shine. You're in control — review each comment and personalize as needed!