{"product_id":"detect-repeat-upwork-client-demand-with-n8n-data-tables","title":"Detect Repeat Upwork Client Demand with n8n Data Tables","description":"\u003ch3\u003eDetect repeat Upwork client demand with n8n Data Tables\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow spots “repeat-client, repeat-demand” opportunities from incoming Upwork job events—deduplicating history with \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e and deterministically logging evidence-backed matches, with Discord alerts on errors.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests Upwork job events\u003c\/strong\u003e via a \u003cstrong\u003eheader-authenticated webhook\u003c\/strong\u003e (or runs an evaluation using a case from a Data Table).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates inputs\u003c\/strong\u003e, rejecting events that are missing \u003cem\u003ejobId\u003c\/em\u003e, \u003cem\u003eclientId\u003c\/em\u003e, or \u003cem\u003ejobTitle\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates deterministically\u003c\/strong\u003e by generating stable client\/job keys and checking the \u003cstrong\u003eUpworkJobHistory\u003c\/strong\u003e Data Table for an existing eventId or jobKey; duplicates are skipped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores repeat demand\u003c\/strong\u003e by loading the client’s prior job history and comparing the current job using:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003ecategory match\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eskill overlap\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003etitle-token overlap\u003c\/strong\u003e\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts history and opportunities\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eUpdates client aggregates in \u003cstrong\u003eUpworkClientHistory\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eWhen repeat demand is detected, writes an evidence-backed record to \u003cstrong\u003eUpworkOpportunities\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eUpserts the current job into \u003cstrong\u003eUpworkJobHistory\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a structured result\u003c\/strong\u003e indicating whether a repeat-client opportunity was detected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles failures safely\u003c\/strong\u003e by writing an audit record to \u003cstrong\u003eUpworkWorkflowErrors\u003c\/strong\u003e and sending a \u003cstrong\u003eDiscord webhook\u003c\/strong\u003e alert.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor incoming Upwork postings and get notified when the \u003cstrong\u003esame client\u003c\/strong\u003e shows overlapping category\/skills\/title demand again.\u003c\/li\u003e\n  \u003cli\u003eBuild an automated pipeline that enriches leads using stored client\/job history instead of reprocessing duplicates.\u003c\/li\u003e\n  \u003cli\u003eRun repeat-client evaluations from \u003cstrong\u003eUpworkRepeatClientEvalCas\u003c\/strong\u003e for backtesting or QA.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components:\u003c\/strong\u003e if, set, code, discord, webhook, data table\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Data Tables:\u003c\/strong\u003e UpworkJobHistory, UpworkClientHistory, UpworkOpportunities, UpworkRepeatClientEvalCas (plus UpworkWorkflowErrors for audits)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146497872051,"sku":"N8N-20204","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/B3z5Ez3C1FBt2yD1-RNjx_HJieO562.png?v=1790847212","url":"https:\/\/buyflowscripts.com\/products\/detect-repeat-upwork-client-demand-with-n8n-data-tables","provider":"N8N Commerce","version":"1.0","type":"link"}