🧭 Project Overview
This project was designed to simplify student data collection and make the acknowledgment process fully automated.
Here’s how it works — when a student fills out a Google Form, their details are automatically added to an Excel Sheet, and within seconds, they receive a confirmation email on their registered Gmail account.
The automation ensures that no student entry is missed, no data is manually entered, and every student gets an instant response — making the whole process smooth, reliable, and efficient.
⚙️ How the System Works
Here’s the workflow of my automation setup using Make.com:
Google Form Module: Collects responses from students in real time.
Excel Sheet Module: Automatically logs all form responses into a structured spreadsheet.
Gmail Module: Sends a confirmation email to the student, acknowledging their form submission.
Each module is connected through a single Make.com Scenario — whenever a new form is submitted, Make.com triggers the workflow, executes all actions, and completes the process automatically within seconds.
Everything happens without writing any backend code — just smart integration and automation!
🪄 Step-by-Step Process: How I Built the Automation in Make.com
Designed the Google Form
I created a Google Form with essential fields such as Name, Email ID, Department, and Feedback Message. This form acts as the main input source for collecting student details.Prepared the Excel/Google Sheet
Next, I set up an Excel Sheet (connected via Google Sheets) with matching columns — Name, Email, Department, and Feedback — so that every form response could be automatically recorded in the correct format.Created a Scenario in Make.com
Inside Make.com, I started a new Scenario — which is basically an automation workflow. It begins with a trigger (when someone submits a form) and follows with multiple actions.Added the Google Forms Trigger Module
I selected Google Forms as the first module and linked it to my form. This makes the scenario activate each time a new response is submitted.Mapped the Data Fields
I mapped each Google Form field (like “Name” and “Email”) to the corresponding columns in the Google Sheet. This ensures that every piece of data goes exactly where it belongs.Added the Google Sheets / Excel Module
The next module was Google Sheets, which captures the response data and stores it row by row in my Excel Sheet automatically.Configured Conditional Logic (Optional)
I added a small condition filter — so that emails would only be sent when a valid email ID was detected. This prevents errors or empty submissions from triggering unnecessary emails.Added the Gmail Module
Then I connected Gmail as the next module. This module is responsible for sending out a confirmation email to the student as soon as their data is stored successfully.Customized the Email Template
I wrote a short, polite email message:“Dear [Name], thank you for submitting your details. Your information has been successfully recorded in our database.”
This personalized message automatically replaces [Name] with each student’s real name using dynamic variables.Tested the Automation Flow
I ran several test submissions on the Google Form to verify that the data was being correctly recorded in Excel and that the emails were being sent instantly to each user.Enabled Auto Run & Scheduling
Finally, I activated the Scenario Auto Run in Make.com, ensuring the automation runs continuously in the background, 24/7. No manual trigger is needed.Monitored the Execution Logs
I checked the Scenario Run History in Make.com to track execution success, view timestamps, and confirm that every module was working properly.
Through these 12 steps, I built a fully functional no-code system that collects, records, and acknowledges student responses in real time — 100% automatically.
Join the conversation! Your thoughts help the community grow.