Quick overview
Quick overview This workflow runs every morning, pulls new leads from an Apify actor, uses the OpenAI Chat Completions API to score each lead against your ideal customer profile, and appends the scored results (including low scores) to a Google Sheets spreadsheet. How it works Runs every day at 8:00 and loads your ideal customer profile, offer description, score threshold, and per-run lead limit. Calls the Apify run-sync-get-dataset-items API to fetch a fresh batch of leads from the configured actor. Normalizes the incoming lead fields into a consistent structure, deduplicates leads, and caps the batch size to your max leads per run. Stops processing if no leads are returned, otherwise sends each lead to the OpenAI Chat Completions API to get a JSON score (1–10) and one-sentence reason. Parses the AI response, attaches the verdict to each lead, and formats a final row including timestamp, lead details, score, reason, and threshold. Appends every processed lead as a new row in Google Sheets. Setup Create a Header Auth credential for Apify (Authorization: Bearer ) and select it in the Apify HTTP request. Create a Header Auth credential for OpenAI (Authorization: Bearer ) and select it in the OpenAI HTTP request. Connect a Google Sheets OAuth2 account and replace the Google Sheet URL and sheet name used for the append operation. Edit the Apify actor URL (YOUR-USERNAME~YOUR-ACTOR) and JSON body to match your chosen actor input. Update the settings values (ICP description, offer description, score threshold, and max leads per run) to fit your qualification criteria and cost limits. An n8n automation workflow template by Rook.
Rook
web
free
Others in the same category, ranked by how often they are opened.
