We didn't get into education to be data entry clerks. We got into it to teach.
So how many hours a week do you spend with a PDF report open on one side of your screen and a district Google Form on the other, retyping names, ID numbers, and grades?
It's mind-numbing, it invites typos, and it wastes time you don't have.
What if you could hand a stack of student reports to an AI and get back a pre-filled link for every student? No typing. No copy and paste. Just click and submit.
I built that workflow. Here's the recipe.
How It Works
Think of it as a teaching assistant who never gets tired. Instead of you hunting for a student ID and typing it out, the AI reads the PDF for you.
Upload. Drop in your student PDF reports, one at a time or in a batch.
The AI reads. It pulls the name, ID, course, and grade from each document.
You get a link. The AI returns a URL. Click it and the Google Form opens already filled in.
You submit. Hit submit and move to the next student.
You can clear an entire class set in the time it usually takes to type in two students by hand.
But I Don't Own the Form
Normally, automating a Google Form means being the owner or editor. That rules out the compliance forms the district and HR send you.
You don't actually need editing rights. Every question on a Google Form has a hidden ID, and you can read those IDs right off the page using a built-in browser tool called Inspect Element. Find them once, give them to the AI once, and it remembers them.
I walk through that process step by step in the video below.
One Thing to Check First
This workflow means uploading student names, ID numbers, and grades to an AI tool. Check your district's policy on student data before you start. Some districts have an approved enterprise version of ChatGPT or Gemini. Others prohibit consumer accounts for anything containing student information. Worth a quick conversation with your tech director.
The Recipe
You can build this in ChatGPT as a Custom GPT, or in Google Gemini as a Gem.
Copy the instructions at the bottom of this post and paste them into the Instructions field of your AI tool.
You'll need to swap in two things: the base URL of your form, and the entry.xxxxxx number for each question. The video shows how to find both.
Take Back Your Time
None of this is magic. It's using the tools available to us to work smarter instead of harder. Set it up once and save hours for the rest of the school year.
Watch the video demonstration on LinkedIn
User Prompt
TASK: Process multiple PDF grade reports and generate standardized Google Form submission URLs.
INPUT:
- Chat input: Teacher's name (if absent, prompt for it).
- Multiple PDF files uploaded (each contains one student's data).
DATA TO EXTRACT FROM EACH PDF:
- Student First Name
- Student Last Name
- Student ID Number (6-digit number)
- Course Name (full course code and title)
- Actual Grade percentage
PROCESS:
1. Extract the teacher's name only from the chat input. Do NOT use any name found in PDFs.
2. For each PDF:
a. Extract student data (First Name, Last Name, Student ID, Course Name, Actual Grade percentage).
b. Convert the grade percentage to a letter grade (format: Letter (Percentage%)).
c. Compute the current date in MM/DD/YYYY format.
d. Generate a prefilled Google Form URL using the base URL and URL-encoded parameters.
3. Ensure each PDF is processed separately, and output a separate block for each.
URL PARAMETERS (to be URL encoded):
Generate Google Form URL with these parameters:
Base URL: https://docs.google.com/forms/d/e/1FAIpQLScA6vER6fhFDCr31HjAWvGkUF7ngaLIVHrdBH8p8hsZehULPg/viewform
Parameters:
entry.2064812455 = [Teacher Name]
entry.1849467899 = [Student First Name]
entry.1279818763 = [Student Last Name]
entry.521407373 = [Student ID] (6-digit number)
entry.1896804698 = [Course Name]
entry.246279050 = [Current Date in MM/DD/YYYY]
entry.2065455529 = [Letter Grade (Percentage%)]
OUTPUT (for each PDF):
Teacher: [Teacher Name]
First Name: [Student First Name]
Last Name: [Student Last Name]
Student ID#: [Student ID] (6-digit number)
Course Name: [Course Name]
Date Completed: [Current Date]
Actual Grade: [Letter Grade (Percentage%)]
Prefilled Google Form URL: Plain text string in the example format. No hyperlink or markdown.
Do not add a content reference or any additional information to the grade field.
Repeat the OUTPUT for each PDF.
Ensure the Prefilled Google Form URL is visible in the output so the user can copy it.
Example URL Format:
https://docs.google.com/forms/d/e/1FAIpQLScA6vER6fhFDCr31HjAWvGkUF7ngaLIVHrdBH8p8hsZehULPg/viewform?usp=pp_url&entry.2064812455=[Teacher Name]&entry.1849467899=[Student First Name]&entry.1279818763=[Student Last Name]&entry.521407373=[Student ID]&entry.1896804698=[Course Name]&entry.246279050=[Current Date]&entry.2065455529=[Letter Grade (Percentage%)]
Always process all PDFs at once. Do not wait to be prompted to continue.