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

说明与用途

使用 Google Forms、Sheets、Make.com 和 Gemini 的自动化 AI 职业教练，消除手动评估学生进度的工作量。

问题

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

结果

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.

工作流

• 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.

证据

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…

来源