Turn HR news into policy update tasks and a weekly Gmail digest with RSS, Google Drive, Gemini, and GPT-5.2

Name: Turn HR news into policy update tasks and a weekly Gmail digest with RSS, Google Drive, Gemini, and GPT-5.2
Availability: InStock
Author: Paul Karrmann

Turn HR news into policy update tasks and a weekly Gmail digest with RSS, Google Drive, Gemini, and GPT-5.2 preview

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Overview

HR Weekly Radar

AI powered workflow that scans HR news via RSS, checks which of your policies or contract templates might need updates, and sends a weekly internal newsletter as HTML.

What this template is for

If you maintain an HR policy and template library, this helps you spot relevant changes faster and turn them into a small, actionable review list.

Good to know

This workflow fetches article pages and sends extracted text to LLMs
Respect the publisher’s terms and avoid redistributing full article text outside your organization
Cost and runtime depend on how many articles you process and how long the extracted text is

How it works

Weekly trigger starts the workflow
RSS feed read pulls new HR articles
Filter keeps only the last 7 days
Limit node caps processing to maxArticles
HTTP request fetches each article page
HTML extract + cleanup converts the article body to plain text
Google Drive node lists your policy and template file names
Merge combines each article with the document list
Reading agent evaluates relevance and suggests:
which documents to review or update
what change to consider
missing document ideas
Build report aggregates results across all articles
Summary agent writes a short, scannable HTML email
Gmail sends the newsletter to your chosen recipient

How to use

Add your RSS feed URL in the Workflow Configuration node (newsUrl)
Set your recipient email (userEmail)
Set your Google Drive folder id that contains policies and templates (templatesFolderId)
Connect credentials for:
Google Drive
LLM provider nodes
Gmail
Run once manually and verify the email formatting, then activate the workflow

Requirements

RSS feed URL with HR or compliance updates
Google Drive folder containing policy and template files
LLM credentials for:
per article analysis
newsletter drafting
Gmail account to send the email

Customising this workflow

Increase or decrease maxArticles to control cost and speed
Adjust the last 7 days filter if you want a different reporting window
Change the HTML extraction selector if your news source has a different page layout
Swap the final Gmail node for Slack, Teams, Notion, or Google Docs
Add a redaction step before the Reading Agent if you want to remove signatures or long quoted sections

Paul Karrmann

3 workflows

Complexity

advanced

Published 31 Jan 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/13124/13124.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Aggregate multi-source job boards to Supabase and Google Sheets

Stop manually checking dozens of career pages. This workflow runs every morning, hits the public APIs of 8+ ATS platforms and job boards, normalizes every listing into a single clean schema, and syncs everything to Supabase and Google Sheets deduplicated and ready to query. ## Who it's for Job seekers, recruiters, or career platforms that want a consolidated, up-to-date feed of openings from specific companies without scraping, without API keys, and without paying for a jobs aggregator. ## How it works 1. A Schedule Trigger fires daily at 8 AM IST 2. A Company List code node defines all sources grouped by ATS type (Greenhouse, Lever, Ashby, Workable, SmartRecruiters, RemoteOK, and board APIs like Remotive, Himalayas, Arbeitnow, Jobicy) 3. A Prepare Request node builds the correct API URL and headers for each source, including multi-page pagination for SmartRecruiters (up to 500 jobs via offset) and Himalayas (up to 500 via page param) 4. An HTTP Request node fetches all sources in batches of 5 5. A Parse + Enrich + Filter node normalizes all divergent JSON structures into a unified schema — resolving ISO country codes, Indian city detection, salary parsing across all formats, and domain-based filtering 6. Deduplicated results are upserted to a Supabase (Postgres) table and written to Google Sheets ## ATS platforms supported Greenhouse, Lever, Ashby, Workable, SmartRecruiters, RemoteOK, Remotive, Himalayas, Arbeitnow, Jobicy ## Normalized output schema `job_id`, `title`, `company`, `location`, `country`, `salary`, `job_type`, `apply_url`, `posted_at`, `source_ats` ## Setup 1. Open the **Company List** node and edit the `sources` array — add or remove companies and their ATS slugs 2. Update `ALLOWED_DOMAINS` in the Parse node to filter by location or job type relevant to you 3. Add your **Supabase** credentials in the Postgres node and confirm your table name and schema match the output fields 4. Connect your **Google Sheets** credentials and set the target spreadsheet and sheet ID 5. (Optional) Adjust pagination limits per source in the Prepare Request node ## Requirements - Self-hosted or cloud n8n instance - Supabase project with a jobs table - Google Sheets with headers matching the normalized schema - No external API keys required — all sources use public endpoints

View

Check and deactivate broken job apply URLs with Postgres and Google Sheets

Keep your job listings database clean without manual checks. Every three days, this workflow fetches all active jobs from your Postgres database, runs each application URL through a validation check, identifies dead links via HTTP status codes and soft-404 redirect detection, then marks failed entries as inactive in both Supabase and Google Sheets simultaneously. ## Who it's for Teams running a job aggregator, career platform, or internal hiring tracker who store job listings in Postgres and want stale or broken apply links removed automatically — without waiting for user reports. ## How it works 1. A Schedule Trigger fires every 3 days 2. All active jobs are fetched from your Postgres (Supabase) database via a SQL query 3. A Prepare URLs node filters out any rows with missing, malformed, or non-HTTP URLs before they're checked 4. An HTTP Request node sends a HEAD request to each `apply_url` 5. A Find Dead Jobs code node analyzes each response and flags a job as dead if: - Status code is `404` or `410` - DNS resolution fails (`ENOTFOUND`) - Connection is refused (`ECONNREFUSED`) - A `301`/`302`/`307` redirect points to a different path — indicating the job was removed and the ATS is silently redirecting (soft-404 detection) 6. If dead jobs are found, an IF node routes them to both update nodes in parallel: - **Supabase (Postgres)** — status set to `inactive` via parameterized SQL - **Google Sheets** — row updated to reflect the new status 7. If no dead jobs are detected, the workflow exits cleanly with no writes ## Setup 1. Connect your **Postgres** credentials and confirm the query in the Fetch Active Jobs node matches your table and column names (`apply_url`, `job_hash`, `job_title`) 2. Connect your **Google Sheets** credentials and set the Resource ID and Sheet Name in the Mark Inactive node 3. Confirm the `inactive` status value in the Postgres update query matches what your app expects 4. (Optional) Adjust the soft-404 redirect detection logic in the Find Dead Jobs node if your ATS platforms use non-standard redirect patterns ## Database columns expected `job_hash` (unique identifier), `apply_url`, `job_title`, `status` ## Requirements - Self-hosted or cloud n8n instance - Supabase (or any Postgres-compatible) database with an active jobs table - Google Sheets with a matching jobs log

View

Screen resumes with GPT-4 Turbo from Gmail and send shortlisted to Slack

# AI Resume Screening Workflow using Gmail, OpenAI (GPT-4 Turbo) & Slack This workflow automatically fetches resumes from Gmail, extracts text from PDF attachments, analyzes candidate profiles using AI, and shortlists qualified candidates by sending their details to Slack. It significantly reduces manual effort in resume screening and speeds up hiring decisions. ### Quick Implementation Steps 1. Connect your Gmail account in n8n 2. Connect your OpenAI API (GPT-4 Turbo) 3. Connect your Slack account 4. Ensure resumes are received as PDF attachments in Gmail 5. Update job requirements inside the AI Resume Analyzer node 6. Run the workflow manually or activate it ## What It Does This workflow automates the resume screening process by integrating Gmail, AI, and Slack into a seamless pipeline. It starts by fetching emails containing resume attachments, then processes and validates these files to ensure only PDF resumes are analyzed. Once validated, the workflow extracts text from each resume and sends it to an AI model. The AI evaluates candidate details such as skills, experience, and contact information, and calculates a match score based on predefined job requirements. Finally, the workflow determines whether a candidate should be shortlisted or rejected. Shortlisted candidates are instantly shared on Slack with complete details, enabling faster hiring decisions and reducing manual screening effort. ## Who’s It For - HR teams and recruiters - Hiring managers - Startups handling large volumes of applications - Recruitment agencies - Businesses looking to automate candidate screening ## Requirements to Use This Workflow - n8n (self-hosted or cloud) - Gmail account (OAuth connected) - OpenAI API key (GPT-4 Turbo access) - Slack account (with channel access) - Resumes in PDF format - Basic understanding of n8n workflows ## How It Works & Set Up ### Setup Instructions 1. **Manual Trigger Setup** Use the *Start Workflow Manually* node to initiate the workflow. 2. **Gmail Configuration** Connect your Gmail account in the *Fetch Gmail* node. Ensure emails contain resume attachments. 3. **Attachment Processing** The workflow formats and checks attachments. Only emails with attachments proceed further. 4. **PDF Validation** Ensure resumes are in PDF format. Non-PDF files are ignored automatically. 5. **Text Extraction** The *Extract Resume Text* node converts PDF resumes into plain text. 6. **AI Configuration** Add your OpenAI credentials in the *OpenAI Chat Model* node. Customize job requirements inside the *AI Resume Analyzer* node prompt. 7. **Evaluation Logic** Candidates are scored based on: - Skills (50%) - Experience (30%) - Location (20%) 8. **Output Handling** If score ≥ 70 → Sent to Slack as shortlisted. Else → Marked as rejected 9. **Activate Workflow** Run manually or activate for continuous use. ## How To Customize Nodes - **AI Resume Analyzer** - Modify job requirements (skills, experience, location). Adjust scoring logic or threshold - **Evaluate Candidate Score** - Change minimum score (default: 70) - **Slack Node** - Customize message format. Change Slack channel - **Gmail Node** - Add filters (labels, subjects, senders) - **Extract Resume Text** - Extend for other file formats if needed ## 1.8 Add-ons (Enhancements) - Store shortlisted candidates in Google Sheets or database - Send rejection emails automatically - Add ATS (Applicant Tracking System) integration - Include resume ranking system - Add duplicate candidate detection - Enable multi-role job matching ## 1.9 Use Case Examples - Automating resume screening for tech hiring - Filtering candidates for specific skill sets (e.g., React Native developers) - Handling bulk job applications efficiently - Shortlisting candidates for remote roles - Pre-screening candidates before interviews There can be many more use cases depending on hiring workflows and business needs. ## 1.10 Troubleshooting Guide | Issue | Possible Cause | Solution | |---------------------------|-----------------------------------------------------|------------------------------------------------------------| | No emails fetched | Gmail not connected or incorrect filters | Reconnect Gmail and check filters | | Attachments not processed | Emails don’t contain attachments | Ensure resumes are attached | | PDF not detected | Incorrect file type | Ensure resumes are in PDF format | | AI response parsing error | Invalid JSON from AI | Check prompt and enforce strict JSON | | No Slack message | Slack credentials or channel issue | Verify Slack connection and channel ID | | Low-quality matches | Incorrect job requirements | Update AI prompt with accurate criteria | ## Need Help? If you need assistance setting up this workflow or customizing it for your business needs, we’re here to help. Whether you want to: - Extend this workflow with advanced features - Integrate it with your existing systems - Build similar automation solutions Feel free to reach out to our [n8n workflow development](https://www.weblineindia.com/n8n-automation/) experts at **WeblineIndia** for expert support and tailored workflow development. 👉 Let us help you automate smarter and scale faster.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Turn HR news into policy update tasks and a weekly Gmail digest with RSS, Google Drive, Gemini, and GPT-5.2

Workflow preview

Overview

HR Weekly Radar

What this template is for

Good to know

How it works

How to use

Requirements

Customising this workflow