<aside> <img src="/icons/command-line_gray.svg" alt="/icons/command-line_gray.svg" width="40px" />

Goal: Automate prospect scoring and qualification using AI. Save time analyzing lead context and deciding follow-up actions.

How It Works (Zapier Flow Breakdown):

🔹 Step 1 – Trigger: Google Sheets When a new row is added to the AI-Powered Prospect Qualifier sheet, the automation starts.

🔹 Step 2 – Filter: Zapier Filter

Only continue if the AI Score cell is empty (avoids looping).

🔹 Step 3 – ChatGPT (gpt-3.5-turbo-instruct)

Sends the company name and job title to ChatGPT. Prompt example:

“You are an expert sales assistant. Score this lead from 1 to 5, explain the insight behind it, and suggest the next step. Company: ChainNova Role: Head of Partnerships”

GPT responds with a clear structure like:

Score: 4

Insight: ChainNova is a tech company...

Next Step: Follow-up

🔹 Step 4 – Python (Zapier Code) Parses the text response into three clean values: score, insight, and next_step.

Python Script: ‣

🔹 Step 5 – Google Sheets: Update Row

Writes the three values back into the original spreadsheet row.

Tools Used: Zapier, Google Sheets, ChatGPT (gpt-3.5-turbo-instruct), Python (via Zapier Code), GitHub

Python Script:

Code for the JSON cleaning step:

🔗 https://github.com/AlvLeoAI/zapier/blob/main/ai_business_extractor.py

Result:

• No manual prospect scoring
• Structured lead insight per row
• Follow-up recommendations based on AI
• Super scalable for inbound/lead lists
• Great for Sales, Partnerships, Outreach

</aside>

<aside> <img src="/icons/link_gray.svg" alt="/icons/link_gray.svg" width="40px" />

https://zapier.com/shared/620b6227998eae0e939e5302634b959549026ef7

</aside>