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”

THE WORKFLOW5 NODES
⋈Merge▦Update leadstatus≡Extract JSONreplyOQualify leadswith GPTGCheck for newentries
DIFFICULTY
Beginner
NODES
5
USES AI
Yes
PUBLISHED
March 2024

001 / WHAT HAPPENS

  1. 01

    A new row added to the Google Sheet starts the workflow.

  2. 02

    The lead's details and your written qualification rules are sent to OpenAI.

  3. 03

    A Set step pulls the model's answer out of its JSON reply.

  4. 04

    A Merge step joins that answer to the original lead row.

  5. 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? →

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→