An AI-powered automated outreach system built using Make.com, Google Sheets, Groq AI API, and Gmail for personalized member communication and workflow automation.
This project automates the process of sending personalized follow-up emails to new IAASSE member signups. The system detects new entries from Google Sheets, generates AI-personalized outreach messages, sends emails automatically using Gmail, and updates tracking information such as status and timestamps.
- Automated new signup detection
- AI-personalized email generation
- Gmail integration for automated outreach
- Status and timestamp tracking
- Error handling and fallback email routing
- A/B testing support for engagement comparison
- Workflow automation using Make.com
- Make.com
- Google Sheets
- Groq AI API
- Gmail
Google Sheets → Make.com → AI Personalization → Gmail → Status & Timestamp Update
The system was tested using 20 mock signup entries to verify:
- Successful email delivery
- AI personalization
- Generic fallback handling
- Status updates
- Timestamp accuracy
- Multi-row workflow execution
Two outreach variants were tested:
- Generic email outreach
- AI-personalized outreach
Results showed improved engagement potential with AI-personalized communication compared to generic templates.
One major challenge was handling failures in AI-generated responses while ensuring reliable email delivery. This was solved by implementing router-based fallback logic and automated status tracking inside Make.com.
- Open-rate analytics dashboard
- Automated follow-up emails
- Multi-template support
- Admin monitoring dashboard
- CRM integration
Arafath KITS Warangal
The exported Make.com workflow blueprint is available in the workflow folder.
This blueprint contains the automation logic for:
- Google Sheets signup detection
- AI-powered email personalization
- Gmail automated outreach
- Status and timestamp updates
- Router-based fallback handling
- A/B testing workflow support
The blueprint can be imported into Make.com to replicate the automation workflow structure.



