Magellan Google Review Generator

Magellan Review Generator

Automated workflow to filter and generate Google Review requests.

1. Parent List Get File

2. Student List Get File

3. Last Session (Active) Get File

4. Last Session (Inactive) Get File

5. Session History Get File

6. Inactive Cut-off Date

Exclude inactive families whose Last Session was before this date.

7. Filter by Manager

8. Filter by Status

9. Tutor Selection

10. Custom Message Template

Variables: [ParentName] [ChildName] [TutorName] [SubjectText]

Live Preview (Dummy Data)

Generated Messages

Parent First Name	Child First Name	Subject(s)	Tutor(s)	Last Session	Phone	Email	Status	Reviewed?	Editable Message & Quick Actions
Upload your files and click Generate to view the list.