Automated Student Onboarding and Personalized Welcome Email Using Google Sheets, Make.com and Gemini AI

Workflow Project Documentation

What if every new student was automatically welcomed with a personalized email the moment their details were added to Google Sheets with zero manual work?

Project Overview

The Automated Student Onboarding Workflow is an AI-powered automation to streamline the onboarding of students into programmes.

Instead of collecting student information through a traditional Google Form, Google Sheets is used as the data-entry and trigger source. Once a new student record is added to the designated Google Sheet, Make.com automatically detects the new row, sends the student’s information to Google Gemini AI, and generates a personalized welcome message and three-step learning plan.

The generated message can then be sent automatically to the student through Gmail or another communication channel.

Overall Workflow

Google Sheets
     │
     │ New Student Row
     ▼
Make.com
     │
     │ Watch New Rows
     ▼
Google Gemini AI
     │
     │ Analyze Student Information
     ▼
Personalized Welcome Email
     │
     ▼
Google Sheets Update
     │
     ▼
Gmail
     │
     ▼
Student Receives Welcome Email

Project Objective

The primary objective of this project is to automate the student onboarding process while maintaining a personalized human-like experience.

The workflow is designed to:

1. Capture student onboarding information.
2. Detect newly added student records automatically.
3. Send relevant student information to Gemini AI.
4. Analyze the student’s background, current skill level and challenges.
5. Generate a personalized three-step Data Science learning plan.
6. Produce a professionally formatted welcome email.
7. Update the student’s record in Google Sheets.
8. Send the personalized email automatically.
9. Reduce repetitive manual onboarding activities.

Problem Statement

Traditional student onboarding processes often require administrators or instructors to manually review each student’s information and write individual welcome messages. For example, when a student provides:

• Name
• Email
• Department
• Current skill level
• Learning goal or challenge

the programme coordinator may need to manually determine what the student should learn first and compose a suitable welcome email. This process becomes inefficient when the number of students increases.

Problems with the manual process

• Repetitive administrative work
• Inconsistent communication
• Time-consuming student assessment
• Difficulty personalizing messages at scale
• Increased possibility of errors
• Delays in welcoming new students

The proposed automation addresses these challenges by combining Google Sheets, Make.com and Gemini AI.

Technologies Used and their role

Google Sheets acts as the central data source.

Make.com acts as the automation engine connecting the different applications.

Gemini AI acts as the intelligent layer that interprets the student’s information and creates personalized content.

Gmail acts as the communication channel for delivering the generated welcome message.

Workflow Process

Sign in to Make.com and create a scenario

Step 1: Student Information Is Added

A new student record is entered into Google Sheets. The information becomes the input for the automation.

Step 2: Make.com Watches the Google Sheet

The first module in Make.com is:

Google Sheets → Watch New Rows

Get Adeyemi Adenuga’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

This module monitors the selected spreadsheet.

When a new row is detected, Make.com retrieves the information contained in that row.

The data becomes available for mapping into subsequent modules.

Step 3: Student Information Is Passed to Gemini AI

The student’s information is mapped into the Gemini AI prompt.

The prompt uses dynamic variables such as:

{{Name}}
{{Current Skill}}
{{Department}}
{{Bio/Struggle}}

This allows every student to receive a different response.

For example:

Name: Chinedu Okafor
Current Skill: Beginner
Department: Agricultural Economics
Bio/Struggle:
I am good at Excel but I want to learn Machine Learning
to predict crop yields. Math is hard for me.

AI Prompt Design

The Gemini AI prompt instructs the model to act as a Data Science Mentor.

A suitable prompt is:

Act as a professional Mentor at Elevare Knowledge Systems. Write a warm, personalized welcome email to {{Name}}, a {{Current Skill}} student from the {{Department}} department.
The student's current struggle or goal is:
{{Bio/Struggle}}
Create an encouraging and personalized email that makes the student feel welcomed, understood, and confident about starting their Data Science journey.
Include a short introduction, acknowledge their background and challenge, and provide a customized 3-step starting plan that is relevant to their goal.
Structure the email with clear paragraphs and a numbered 3-step plan.
End with an encouraging closing and:
Warmly,
Data Science Mentor
Elevare Knowledge Systems
FORMATTING RULES:
- Maximum 180 words.
- Use clear paragraphs with a blank line between each paragraph.
- Keep the 3 steps as a numbered list.
- Do not use Markdown.
- Do not use asterisks.
- Do not put the entire email into one paragraph.
- Do not invent information that was not provided.
- Keep the tone warm, professional, encouraging and personalized.
- Return only the email content.

This prompt improves consistency and prevents Gemini from returning poorly formatted content.

Email Automation

The final stage can use:

Gmail → Send an Email

The student’s email address is mapped from:

{{Email}}

The workflow therefore eliminates the need for an administrator to manually copy and paste the AI-generated message.

Benefits of the Workflow

1. Automation

The system significantly reduces repetitive onboarding tasks.

2. Personalization

Each student receives guidance based on their:

• Background
• Skill level
• Goals
• Challenges

3. Scalability

The same workflow can process many students without requiring the coordinator to manually write individual emails.

4. Consistency

Every student receives a professional onboarding experience following the same general structure.

5. Faster Response

Students can receive their welcome message shortly after their information is added.

6. Centralized Data

Google Sheets provides a simple location for monitoring student information and automation status.

7. AI-Assisted Mentoring

Gemini provides an initial personalized learning recommendation that can support the instructor or mentor.

Conclusion

The Automated Student Onboarding and Personalized Welcome Email Workflow demonstrates how no-code automation and generative AI can be combined to improve educational operations.

Google Sheets provides a simple and accessible data-entry mechanism, Make.com provides the automation infrastructure, Gemini AI provides intelligent personalization, and Gmail provides the communication channel.

The resulting system is capable of turning a basic student record into a personalized, encouraging onboarding experience with minimal manual intervention.

The project can also serve as a foundation for a broader AI-powered student management and mentoring system, incorporating personalized curricula, progress monitoring, automated reminders, student dashboards and ongoing AI-assisted mentorship.

Ready to Automate Your Student Onboarding?

Stop wasting hours on manual data entry and generic welcome emails.

Thank you for reading, you can clap 50 times or more…..

Adeyemi Adenuga - KnowEdge Tech Hub | LinkedIn