PICKED FROM N8N.IO · LEADS & SALES
Watches a Google Sheet for new rows, such as form enquiries, and sends each lead to OpenAI along with your qualification rules. The model replies with a result, and the workflow writes 'qualified' or 'not qualified' back into a status column on the same row, so you can sort and filter your leads.
Template by Yulia · 30.1k views on n8n.io · listed there as “Qualify new leads in Google Sheets via OpenAI's GPT-4”
- DIFFICULTY
- Beginner
- NODES
- 5
- USES AI
- Yes
- PUBLISHED
- March 2024
001 / WHAT HAPPENS
- 01
A new row added to the Google Sheet starts the workflow.
- 02
The lead's details and your written qualification rules are sent to OpenAI.
- 03
A Set step pulls the model's answer out of its JSON reply.
- 04
A Merge step joins that answer to the original lead row.
- 05
The Google Sheet row is updated with the qualification result in a separate column.
WHO IT SUITS
Suits small service businesses that collect enquiries in a Google Sheet or Google Form and want a quick first pass on which leads deserve a call.
CONNECTS
- Google Sheets
- OpenAI
002 / BEFORE YOU USE IT HERE
- !Customer or lead details are sent to an overseas AI provider, which is a cross-border disclosure under APP 8 of the Privacy Act, so say so in your privacy policy.
- !The sheet update matches on a column such as the form timestamp, so check that column is unique and that your own sheet columns replace the sample ones.
- !The OpenAI node is an older one, so test it against your current n8n version and a paid OpenAI API key before relying on results.
LOCAL SWAP
Swap the Google Sheets nodes for the Microsoft Excel 365 nodes if your enquiries live in Excel.
Need n8n and the AI hosted in Australia? →003 / MORE FOR LEADS & SALES
- 24 NODESAI
LEADS & SALES
AI appointment booking and lead follow-up by SMS with Cal.com
TwilioCal.comAirtableOpenAIAdvancedby Jimleuk29.3k views - 8 NODES
LEADS & SALES
Capture sign-ups with n8n multi-page forms and Google Sheets
n8n FormGoogle SheetsSlackBeginnerby Jimleuk7.5k views - 7 NODES
LEADS & SALES
Capture Typeform leads in HubSpot and email info packs
TypeformHubSpotGmailBeginnerby Lorena5k views
004 / QUESTIONS
Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.
Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.
We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.
Book a free call→