How I Built an Automated AI Career Coach using Make.com

Description and use

An automated AI career coach that evaluates student progress using Google Forms, Sheets, Make.com, and Gemini, eliminating manual review.

Problem

Manual evaluation of student progress reports is a bottleneck for scaling educational programs.

Outcome

The system processes each submission within seconds, providing a concise status and summary directly in the student’s row, saving instructors hours of manual work.

Workflow

• 1. Set up Make.com trigger using legacy "Watch Responses in Google Sheets" to capture form answers and row number.
• 2. Map form data into a custom prompt for Google Gemini AI.
• 3. Use Gemini to evaluate progress and output status and summary in a fixed format.
• 4. Update the corresponding row in Google Sheets with AI assessment via Make.com.

Evidence

Students in a training program fill out a weekly progress form… Instead of an instructor reading each submission, the data is automatically sent to Google Gemini…

Source