Workflow: Zapier + ChatGPT prompts for lead scoring
Need concrete prompt templates and JSON schemas to convert form answers into a 0–100 lead score, then push to HubSpot; preference for low-code, maintainable steps.
Best tools for this use case
Based on the workflow in this discussion, these tools are useful starting points to review.
Zapier
Best general-purpose automation layer for connecting tools and processes quickly.
Make
Powerful automation builder for advanced visual flow design and multi-step operations.
n8n
Technical automation platform with strong flexibility, control and AI workflow potential.
Answers
Approved replies, operator insight, and tactical follow-up from the community.
Concrete minimal flow: ChatGPT scores form JSON; Zapier pushes the score to HubSpot.
Prompt (send full form JSON):
Score this lead 0–100 from the input JSON. Return only JSON: {"score":int,"breakdown":{"budget":int,"fit":int},"explain":"1-sentence rationale"}.
Input JSON example: {"name":"string","email":"string","company":"string","budget":"string","use_case":"string"}
Output example: {"score":73,"breakdown":{"budget":40,"fit":33},"explain":"short"}
Zapier steps: Form trigger → ChatGPT action (use prompt) → Parse JSON → HubSpot Create/Update contact (set score field).