Education workflow
Parent Letters
Turn a Google Sheets class roster into a personalised letter for every family using one Google Docs template. Portant's data merge builds, names, and files each letter so you can email or print without retyping.
~5 min setup · Used by 100+ teams
Trusted by 40,000+ teams
Overview
Send personalised parent letters from one Google Docs template
School offices spend Friday afternoons retyping the same parent letter, swapping in each family's name, the right class, and the trip date. One typo on row 17 and two parents call the front desk on Monday morning.
This template hands the typing back to the data. Portant uses data merge to turn each row in your Google Sheets roster into a Google Docs letter, then names every file by student and saves the batch to the class folder. Add Portant AI to translate the letter for multilingual families before it goes out.
It's built for teachers, school office admins, heads of year, and parent liaisons who handle class communication every week. The same workflow covers term newsletters, permission slips, attendance reminders, parent-teacher conference invites, and fundraising appeals.
Who is this for
Is this template right for you?
Teams who generate documents from structured data.
-
A class set of letters out in under five minutes. Portant's data merge turns every Google Sheets row into a personalised Google Docs letter in one run, so the office stops typing the same letter once per family.
-
Proof of which families opened the letter. Portant's email tracking flags which parents have read the message, so the office follows up only with the families who missed it instead of phoning the whole class.
-
Letters every family can read in their language. Portant AI translates the approved letter into the language flagged on each row, so multilingual school communities get the same message at the same time.
Setup
How to set up the parent letter workflow
-
01
Step 1: Connect Google Sheets and Google Docs
Sign in to Portant with your Google Workspace account, then pick the class roster sheet and the parent letter template you've already built in Google Docs.
-
02
Step 2: Map columns to merge tags
Drop tags like {{Parent Name}}, {{Student Name}}, {{Class}}, and {{Trip Date}} into the template, then match each one to the matching column in your roster.
-
03
Step 3: Set output management rules
In Portant's output settings, name each file by student, save the batch to a class folder in Drive, and choose PDF or Doc as the export format.
-
04
Step 4: Send with email tracking or translate first
Turn on Portant's email tracking so you can see opens, or use Portant AI to translate the letter into each family's preferred language before the batch goes out.
Frequently asked questions
List one family per row in Google Sheets with parent name, email, student name, and class, then connect that sheet to a Google Docs letter template inside Portant. Portant's data merge replaces the tags in the template with the data on each row and produces one letter per family in a single run.
Keep your class roster in Google Sheets, keep the school letterhead in one Google Docs template, and let Portant generate one file per family. The whole batch runs in minutes, every letter looks like the school's official letter, and the files save to one Drive folder so the office can find any one of them later.
Yes. Add a column to the Google Sheet that flags each family's preferred language, then turn on Portant AI in the workflow to translate the body of the letter row by row. The school's English letter and the translated version both come out of the same template, so the formatting and letterhead stay identical.
A class set of around 30 letters runs in under a minute once the workflow is built. A whole-school batch of 500 families takes a few minutes, since Portant generates each Google Docs file in parallel and writes them all into a single class or year group folder in Drive.
Yes. Connect a Google Forms sign-up sheet as the data source instead of a static roster, and Portant generates a parent letter the moment a family completes the form. This works well for trip consent, after-school clubs, and parent-teacher conference bookings.
Send the batch through Portant with email tracking switched on. Each family's row in the workflow log shows whether the letter was opened and when, so the office can phone or re-send only to the parents who haven't read it. That replaces guessing whether the email got through.
Related templates
Student Progress Reports
Build personalised progress reports for an entire class from one Google Sheet roster, with grades, attendance, and behaviour notes already in place. Portant's data merge and AI generate a tailored Doc per student, then file the PDFs by class.
View template
Graduation Certificate
Turn one Google Sheets roster into a finished graduation certificate per learner, exported as named PDFs in your cohort folder. Portant data merge fills your Google Slides design and output management handles the file names and sequential certificate numbers.
View template
Incident Report Template
Staff log the event in a Google Form, and Portant generates a formal incident report Doc from the response. Data merge handles every field, and approval workflows route it to your HSE manager before the report goes to safety, legal, or insurance.
View templateJoin over 40k+ teams using Portant
Portant has been a game-changer for Clipboard! It's saved our sales team countless hours every week by generating order forms, proposals and contracts with info from HubSpot automatically filled in.
With Portant, I run documents directly from HubSpot. No jumping between platforms. No copying data.
Portant replaced three separate tools for us. One platform handles docs, signatures, and follow-ups without leaving HubSpot.
Portant was the simplest and quickest signing integration I've ever implemented, it works natively with HubSpot.
At RepCard, Portant gave us an end-to-end automated workflow inside HubSpot, we replaced manual agreement creation at scale.
We're seeing higher average closed revenue with Portant and faster days to close, it's showing us a material impact on sales velocity.
Love this product. Have been using it for over a year and the integration to Google Workspace is awesome. Lots of credit for listening to your users!
When the executive team asks for an extension document, Portant gets it to them in about an hour, it's empowered my whole team.
Truly a gamechanger! Portant streamlines these tasks and allows me to focus on the things that require my attention and problem-solving!
This software brilliantly takes over the tedious process of creating and sending invoices. This not only saves time but massively reduces errors of data entry.
This product is a gamechanger for all of those painful manual document merges. Love what you and the team have built!
Our reps used to spend 30 minutes per proposal. Now it’s under two minutes and the documents look better than ever.