Monitor HR compliance updates from DOL with GPT-4o-mini and Google Sheets

Quick overview This workflow checks the US Department of Labour RSS feed every hour, filters for HR-relevant updates, uses OpenAI GPT-4o-mini to assess whether each item requires action, and logs actionable compliance tasks with summaries and checklists to a Google Sheets tracker. How it works 1. Runs every hour and reads the latest items from the US Department of Labor RSS feed. 2. Filters the feed items for HR-related keywords (for example wage, overtime, FMLA, discrimination, and compliance) while excluding settlement and back-pay style announcements. 3. Processes the remaining articles one at a time to avoid rate limits. 4. Sends each article’s title, date, excerpt, and link to OpenAI (GPT-4o-mini) to return strict JSON with actionability, summary, priority, checklist, owner team, and due timeline. 5. Cleans and parses the AI JSON output, formats the checklist as bullet points, and defaults to non-actionable if parsing fails. 6. Appends actionable items to a Google Sheets “Compliance Tracker” tab and waits 30 seconds before continuing to the next article. Setup 1. Add an OpenAI credential for the GPT-4o-mini model. 2. This workflow polls the US Department of Labor RSS feed every hour, filters articles for HR-relevant keywords, uses GPT-4o-mini to analyze each update for actionability, and saves only items requiring real HR action to a Google Sheets compliance tracker. 3. 1 4. The workflow polls the US Department of Labor RSS feed automatically every hour to check for new employment law releases and regulatory updates. 5. 2 6. A filter step checks each article's title and description against an HR keyword list — keeping items about labor, wage, safety, overtime, FMLA, discrimination, and compliance — while dropping settlement verdicts and back-pay award announcements. 7. 3 8. Each filtered article is processed one at a time through a batch loop to avoid sending too many requests to the OpenAI API at once. 9. 4 10. GPT-4o-mini analyzes each article and returns a structured JSON object containing: whether the update is actionable for HR, a 2-sentence summary, priority level (High, Medium, or Low), a specific action checklist, the owner team responsible, and a due timeline. 11. 5 12. A parse step cleans the GPT output, strips any formatting, and converts the checklist array into bullet points ready for the sheet. 13. 6 14. An actionability check routes each article: if GPT marked it actionable (Yes), it is saved to Google Sheets. If not actionable (No), it skips the sheet and goes directly to the wait step. 15. 7 16. A 30-second wait runs after every article — whether saved or skipped — before the loop moves to the next article. This prevents rate limit errors and keeps the workflow stable. Requirements - Active n8n instance (self-hosted or cloud) - OpenAI account with GPT-4o-mini API access - Google Sheets with a tab named Compliance Tracker - Google Sheets OAuth2 credential connected in n8n - No RSS account needed — the DOL feed is publicly accessible Customization - Monitor a different agency — in node 1. RSS — US Dept of Labor Feed, replace the feedUrl value with any public compliance RSS feed: OSHA uses https://www.osha.gov/news/newsreleases/national/rss.xml, EEOC uses https://www.eeoc.gov/rss.xml, and NLRB uses https://www.nlrb.gov/news-outreach/rss - Add more HR keywords — in node 2. Code — Filter HR Relevant Articles, add terms to the includeKeywords array such as ada, cobra, erisa, or pay transparency to catch additional regulation types - Add email alerts for High Priority items — after node 7. Sheets — Save to Compliance Tracker, add a Gmail step with an IF check that sends an immediate email notification when the Priority field equals High - Change the polling frequency — in node 1. RSS — US Dept of Labor Feed, change the poll interval from every hour to every 6 hours or daily to reduce API usage for lower-priority monitoring - Add a Slack notification — after node 7. Sheets — Save to Compliance Tracker, add a Slac