Qualify new leads in Google Sheets via OpenAI's GPT-4

1. Create a Google Sheet document This template uses Google Sheet document connected to Google Forms, but a standalone Sheet document will work too Adapt initial trigger to your needs: check for new entries periodically or add a manual trigger [Link to the Google Sheet template](https://docs.google.com/spreadsheets/d/1jk8ZbfOMObvHGGImc0sBJTZBhracO4jRqfbryMgzEs)

Integrations Used (2)

Google Sheets

OpenAI

Workflow Structure (5 nodes)

100%

Google Sheets Trigger

Check for new entries

Merge

Google Sheets

Update lead status

Open Ai

Qualify leads with GPT

Set

Extract JSON reply

Node Types:

logic

action

transform

default

trigger

Requires credentials

Prerequisites

Required Credentials (3)

Google Sheets

Used by: Update lead status

Docs

Google Sheets Trigger

Used by: Check for new entries

Docs

OpenAI

Used by: Qualify leads with GPT

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~40 min

Score: 41/100

Conditional Logic

When to Use This Workflow

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Sales Automation

Automate lead capture, follow-ups, and CRM updates to close more deals.

Focus on selling, not on manual data entry and tracking.

workflow.json

{
  "id": "8FLJK1NsduFL0Y5P",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a"
  },
  "name": "Qualify new leads in Google Sheets via OpenAI's GPT-4",
  "tags": [
    {
      "id": "y9tvM3hISJKT2jeo",
      "name": "Ted's Tech Talks",
      "createdAt": "2023-08-15T22:12:34.260Z",
      "updatedAt": "2023-08-15T22:12:34.260Z"
    }
  ],
  "nodes": [
    {
      "id": "1f179325-0bec-4e5c-8ebd-0a2bb3ebefaa",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
...