{"product_id":"n8n-workflow-screen-contact-activity-from-csv-openai-gpt-4o","title":"n8n Workflow: Screen Contact Activity from CSV (OpenAI GPT-4o)","description":"\u003ch3\u003eScreen contact activity from a CSV—using page text and OpenAI in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow screens your contacts by checking what’s visible on their website, Facebook, and Instagram pages (when provided), then uses OpenAI (gpt-4o-mini) to classify each contact as \u003cstrong\u003eactive\u003c\/strong\u003e, \u003cstrong\u003einactive\u003c\/strong\u003e, or \u003cstrong\u003euncertain\u003c\/strong\u003e—and outputs the results to a new CSV.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManually starts\u003c\/strong\u003e and reads a contacts CSV from your local filesystem via n8n file operations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and processes records in batches\u003c\/strong\u003e, preparing each contact for review.\u003c\/li\u003e\n  \u003cli\u003eFor each contact, \u003cstrong\u003ebuilds browser automation\u003c\/strong\u003e steps to visit:\n    \u003cul\u003e\n      \u003cli\u003ethe contact’s \u003cstrong\u003ewebsite\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003etheir \u003cstrong\u003eFacebook\u003c\/strong\u003e URL (if present),\u003c\/li\u003e\n      \u003cli\u003etheir \u003cstrong\u003eInstagram\u003c\/strong\u003e URL (if present).\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts visible page text\u003c\/strong\u003e using an \u003cstrong\u003eMCP Client endpoint\u003c\/strong\u003e (default: \u003cem\u003ehttp:\/\/localhost:8931\/mcp\u003c\/em\u003e) that supports browser tools like \u003cem\u003ebrowser_navigate\u003c\/em\u003e, \u003cem\u003ebrowser_wait_for\u003c\/em\u003e, and \u003cem\u003ebrowser_evaluate\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and aggregates evidence\u003c\/strong\u003e per channel, then sends an evidence-based screening prompt to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to return a JSON verdict (active\/inactive\/uncertain) with confidence and reasoning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites one output row per contact\u003c\/strong\u003e to an output CSV, including evidence excerpts and timestamps, and \u003cstrong\u003eaborts\u003c\/strong\u003e if an unexpected runaway loop creates too many rows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVerify whether leads or partners appear \u003cstrong\u003eactive\u003c\/strong\u003e on their public web\/social presence.\u003c\/li\u003e\n  \u003cli\u003eUpdate CRM-like lists by flagging \u003cstrong\u003einactive\u003c\/strong\u003e contacts automatically.\u003c\/li\u003e\n  \u003cli\u003eDeprioritize ambiguous leads as \u003cstrong\u003euncertain\u003c\/strong\u003e for manual follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/parts:\u003c\/strong\u003e Code, Sticky Note, Convert to File, Manual Trigger, Read\/Write File, Split in Batches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e for JSON classification; \u003cstrong\u003eMCP browser endpoint\u003c\/strong\u003e for extracting visible page text.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Provide OpenAI credentials, confirm the model in the OpenAI node, ensure your MCP endpoint is reachable, and set valid input\/output CSV paths with matching columns.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146327576755,"sku":"N8N-20245","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2ADUA0cRgIH1XG-Qx20nI_heCESSX8.png?v=1790846076","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-screen-contact-activity-from-csv-openai-gpt-4o","provider":"N8N Commerce","version":"1.0","type":"link"}