I built this credential-free workflow to test the logic of a lead-scoring and outreach-draft pipeline before connecting Google Sheets, Gmail, a CRM, or an AI provider.
What it does
- creates three synthetic leads using
example.com addresses
- normalizes the lead fields
- applies transparent deterministic scoring
- produces draft outreach copy marked for human review
- returns a compact pipeline summary
What it deliberately does not do
- no scraping
- no credentials
- no real contacts
- no AI/API cost
- no email sending
I import-tested and executed this version on n8n 2.22.6. It is meant as an acceptance-test layer, not a production cold-email system.
Run it
- Copy the workflow JSON below.
- Paste it into a blank n8n canvas.
- Open
Manual Trigger and execute the workflow.
- Inspect
Build Pipeline Summary; each draft should say Human review required.
Before production I would add a Sheets/CRM source, duplicate checks, structured AI output plus raw-response logging, a 2xx/allowlist gate for website research, Gmail draft creation, stop-on-reply rules, and a daily report. I would still test one sample row before any batch.
This is the no-credentials demo layer from a larger system I am building. If you try it, I would especially value feedback on whether your first source is Google Sheets or a CRM, and which guardrail you usually add first.
1 個讚
Small maintenance update for anyone adapting this demo into a Google Sheets → Gmail draft workflow:
- Compare approval states exactly. A substring check such as
.includes("approved") also accepts Not approved.
- Save the Gmail draft ID back to the source row. If draft creation succeeds but the sheet update fails, reconcile the existing draft before retrying; a Sheets status flag alone is not a transactional lock.
- Creating a draft is not sending an email. Start any follow-up clock only after the actual send, not after draft creation.
The inline workflow above is still available without visiting a store. I also packaged the no-credentials sample JSON with a short README alongside the planning checklist: free sample + first-run checklist. Enter 0 to download it free.
Disclosure: I maintain the associated paid templates, but no purchase is needed for this demo. This sample uses fictional leads and deterministic rules, makes no external API calls, and does not create Gmail drafts or send messages. The connected Sheets/Gmail revision is still awaiting live integration testing.
For people building a similar flow, which is your first blocker: field mapping, approval handling, or duplicate drafts after retries?
Hey @imguanxingyu, thank you so much for sharing this! I’ll definitely give it a try. I really like the approach of credential-free workflows, as they can be implemented and tested right away without having to reconnect any credentials.
Just out of curiosity: did you look into using native n8n nodes as well, rather than relying only on Code nodes? I always try to stick with the native nodes where possible, as I think they make it much easier to understand what’s happening with the data and how the workflow works.