Project Overview

This project is an AI-powered email inquiry classifier built using Make.com, Gmail, OpenAI, JSON parsing, Google Sheets, and Gmail notifications.

The system watches for new unread emails, analyzes the email content using AI, classifies the inquiry type and priority, saves the email details into a Google Sheets CRM, generates a suggested reply, and sends a structured Gmail notification for review.

Business Problem

Many businesses receive inquiries through email but struggle to organize them, identify urgent messages, and respond quickly.

This automation helps teams classify emails, prioritize important inquiries, draft replies faster, and track email requests in one central CRM.

Tools Used

• Make.com – automation workflow builder
• Gmail – email trigger and notification system
• OpenAI – email classification, summary, and suggested reply generation
• JSON Parser – converts AI output into structured fields
• Google Sheets – CRM/database for storing email inquiries

Workflow

Gmail watches for unread emails → OpenAI analyzes the email → JSON Parser extracts structured AI output → Google Sheets saves the inquiry record → Gmail sends a structured notification to staff.

Key Features

• Watches new unread Gmail messages