This is an automated n8n workflow that scores new leads and sends personalized emails to the most promising ones. It connects Google Sheets, CometAPI, and Gmail. It is built for n8n users and automation engineers.
The workflow checks your Google Sheets spreadsheet every minute for a new row. It sends each lead's name, company, and message to CometAPI, which returns a purchase-likelihood score from 1 to 10. Leads that score 7 or higher are prioritized.
For each prioritized lead, CometAPI writes a short lead summary and a personalized email draft. The email is sent through your Gmail account with a tailored subject line. The lead's details, score, summary, and email draft are then added to the results sheet in Google Sheets.
- Platform
- n8n workflow
- Integrations
- Google Sheets, CometAPI, Gmail
- Trigger
- New row added to a specified Google Sheets spreadsheet, checked every minute
- Lead input
- Name, company, and message
- Scoring
- Purchase-likelihood score from 1 to 10 via CometAPI
- Priority threshold
- Score of 7 or higher
- Outreach
- Personalized email with tailored subject line, sent from Gmail
- Records
- Lead details, score, summary, and email draft appended to the results sheet
- Nodes used
- Google Sheets Trigger, Gmail, Code, If, Sticky Note
- Use cases
- Sales teams, SaaS companies, marketing automation