Generate tax compliance checklists from RSS with Gemini and Google Sheets

Compliance Checklist Auto-Generator > n8n + Gemini + Google Sheets --- This workflow automatically monitors a tax compliance RSS feed, filters relevant regulatory updates, analyzes them using AI and generates structured compliance checklists for actionable updates. Only meaningful updates are logged into Google Sheets for tracking and follow-up. Quick Implementation Steps Create a Google Sheet with the following columns: Sr. No., Date Added, Published Date, Title, Link, Category, GUID, Summary, Reason, Priority, Checklist, Owner Team, Due Timeline, Status For automatic numbering, set cell A2 to: =ARRAYFORMULA(IF(B2:B<>"", ROW(B2:B)-1, "")) Connect Google Sheets credentials in n8n Configure Gemini (Google AI) credentials Verify RSS feed URL (tax/compliance focused) Test HTML extraction selector for article summaries Activate workflow What It Does This workflow continuously monitors a tax-focused RSS feed and identifies relevant compliance updates using keyword-based filtering. It ensures that only meaningful regulatory content moves forward in the process. Each relevant article is processed individually to avoid API overload and improve accuracy. The workflow fetches the full article content and extracts a concise summary section, which is then prepared for AI analysis. Using Gemini AI, the workflow evaluates whether the update requires action from a compliance team. If actionable, it generates a structured output including summary, reasoning, priority, checklist, responsible team and timeline. These results are then stored in Google Sheets for centralized tracking. Who It's For Compliance teams monitoring regulatory changes Finance and tax professionals Legal and risk management teams Organizations needing structured compliance tracking Automation enthusiasts building regulatory intelligence systems Requirements n8n account (self-hosted or cloud) Google Sheets account and credentials Google Gemini API credentials Access to a relevant RSS feed (e.g., tax or regulatory updates) How It Works & Setup Guide Setup Instructions Configure the RSS Feed Trigger with a reliable tax compliance feed URL Set polling interval (e.g., hourly) Connect Google Sheets node to your spreadsheet (ensure columns match exactly: Sr. No., Date Added, Published Date, Title, Link, Category, GUID, Summary, Reason, Priority, Checklist, Owner Team, Due Timeline, Status) Configure Gemini AI credentials Verify HTML Extract node selector for article summary Workflow Logic 1. RSS Feed Trigger fetches new tax-related updates at defined intervals 2. Code node filters relevant updates using predefined include/exclude keywords 3. Articles are processed one at a time using Split in Batches 4. HTTP Request fetches full article content 5. HTML Extract extracts a concise summary section ("In brief") 6. Set node prepares structured data for AI 7. Gemini AI analyzes content and generates structured JSON output 8. Code node parses AI response safely 9. IF node checks whether the update is actionable 10. Actionable updates are formatted and appended to Google Sheets 11. Non-actionable updates are skipped 12. Wait node ensures rate limiting before processing next article How To Customize Nodes Filter Relevant Tax Compliance Updates (Code Node): Modify include/exclude keyword arrays based on your industry HTML Extract Node: Update CSS selector if your RSS source changes structure Gemini Prompt: Customize instructions to match your compliance policies Google Sheets Mapping: Ensure column names exactly match: Sr. No., Date Added, Published Date, Title, Link, Category, GUID, Summary, Reason, Priority, Checklist, Owner Team, Due Timeline, Status. Note: The Sr. No. column is auto-generated using a formula and is NOT populated by the workflow. Wait Node: Increase/decrease delay based on API rate limits Add-ons Add Slack or Email alerts for high-priority updates Store all updates (not just actionable ones) for audit trails Add duplicate detection using GUID or link Integrate