{"product_id":"n8n-remoteok-arbeitnow-job-alerts-gmail-openai","title":"n8n RemoteOK \u0026 Arbeitnow Job Alerts: Gmail + OpenAI","description":"\u003ch3\u003eGet fresh RemoteOK and Arbeitnow job leads—automatically, enriched, and emailed to you with an OpenAI summary\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls job listings from \u003cstrong\u003eRemoteOK\u003c\/strong\u003e and \u003cstrong\u003eArbeitnow\u003c\/strong\u003e, deduplicates and scores opportunities in \u003cstrong\u003ePostgreSQL\u003c\/strong\u003e, matches them to users based on fit, and sends personalized \u003cstrong\u003eGmail\u003c\/strong\u003e alerts using a short \u003cstrong\u003eOpenAI-generated\u003c\/strong\u003e recommendation summary.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery 2 hours\u003c\/strong\u003e, fetches job listings from the RemoteOK API and the Arbeitnow job board API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and merges\u003c\/strong\u003e both feeds into a consistent schema, then \u003cstrong\u003eextracts missing skills\u003c\/strong\u003e from job titles\/descriptions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a quality score\u003c\/strong\u003e and generates a \u003cstrong\u003ehash\u003c\/strong\u003e for deduplication.\u003c\/li\u003e\n  \u003cli\u003eChecks \u003cstrong\u003ePostgreSQL\u003c\/strong\u003e for existing opportunities by job hash and \u003cstrong\u003einserts only new\u003c\/strong\u003e opportunities into the \u003ccode\u003eopportunities\u003c\/code\u003e table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery 6 hours\u003c\/strong\u003e, loads users and recent high-quality opportunities, generates user–job pairs, and computes a \u003cstrong\u003efit score\u003c\/strong\u003e based on skills, location, experience, and job quality.\u003c\/li\u003e\n  \u003cli\u003eFilters and deduplicates matches above the threshold, then \u003cstrong\u003eupserts\u003c\/strong\u003e them into the \u003ccode\u003ematches\u003c\/code\u003e table with a \u003cstrong\u003enotified\u003c\/strong\u003e flag.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery 6 hours\u003c\/strong\u003e, finds users with \u003cstrong\u003eunnotified\u003c\/strong\u003e high-fit matches, selects each user’s \u003cstrong\u003etop jobs\u003c\/strong\u003e, creates an \u003cstrong\u003eOpenAI\u003c\/strong\u003e recommendation summary, and sends an \u003cstrong\u003eHTML email alert via Gmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eMarks qualifying matches as \u003cstrong\u003enotified in PostgreSQL\u003c\/strong\u003e to prevent repeat alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators running n8n to turn job-board feeds into actionable leads for end users.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing a robust pipeline: ingest → enrich → store → match → notify.\u003c\/li\u003e\n  \u003cli\u003eTeams who want personalized RemoteOK\/Arbeitnow job alerts without manual filtering.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduler:\u003c\/strong\u003e runs ingestion every 2 hours; matching and notification every 6 hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003epostgres\u003c\/code\u003e, and \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData model:\u003c\/strong\u003e stores unique opportunities using a \u003cstrong\u003ejob_hash\u003c\/strong\u003e and prevents duplicate alerts via \u003cstrong\u003e(user_id, job_id)\u003c\/strong\u003e uniqueness and a \u003cstrong\u003enotified\u003c\/strong\u003e flag.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916231729331,"sku":"N8N-18830","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/G5eS73prDwBj8UAaJ2QiM_1d1R9YOb.png?v=1788012587","url":"https:\/\/buyflowscripts.com\/products\/n8n-remoteok-arbeitnow-job-alerts-gmail-openai","provider":"N8N Commerce","version":"1.0","type":"link"}