AI Automation · Workflow Engineering
Lead Import & Email Automation System
Four connected n8n workflows that import leads, send scheduled emails, follow up on a timer, and find remote jobs.
- Status
- Prototype
- Year
- To confirm
- Role
- Designer and builder
- Client
- Independent project
01
Overview
A personal automation system made of four connected n8n workflows with Google Sheets as the data store: API lead import, scheduled sending, timed follow-ups, and a remote job finder.
- n8n
- Google Sheets API
- REST APIs
02
The challenge
Outbound lead work, such as importing leads, sending emails and remembering to follow up, is repetitive and easy to drop when done by hand.
03
System requirements
- API lead import
- Scheduled sending
- Timed follow-ups
- Remote job finder
- Google Sheets as the shared data store
04
Solution architecture
Responsibility
API lead import
Pulls leads from an API into the Google Sheets data store.
05
Implementation
Content needed: real screenshots (desktop and mobile). Generated mockups are never shown as screenshots.
06
Technical decisions
- Split the system into four focused workflows connected through one data store
- Use Google Sheets as the data store to keep state visible and easy to edit
07
Results and validation
Content needed: measured results with period and method. Never estimated.
Evidence
- Listed as a personal project on the owner's CV. Workflow screenshots are not yet included.
08
Lessons learned
Content needed: what you would do differently
Content checklist (remove once filled)
- Screenshots of the four n8n workflows (remove credentials and lead data first)
- How the follow-up timing and the job finder actually work, in a sentence each
- Whether it runs live and for what. Keep the status as Prototype until you can say
- Any results, only with a period and method
09