Send daily Google Alerts AI digest with GPT-4.1-mini and Gmail
Quick overview This workflow runs daily to fetch multiple Google Alerts RSS feeds, uses OpenAI GPT-4.1-mini to score and summarize each alert with sentiment and recommended actions, then compiles the most relevant ite...
Template notes
Quick overview This workflow runs daily to fetch multiple Google Alerts RSS feeds, uses OpenAI GPT-4.1-mini to score and summarize each alert with sentiment and recommended actions, then compiles the most relevant items into a branded HTML digest and sends it via Gmail.
How it works 1. Runs every 24 hours on a schedule. 2. Loads a list of Google Alerts RSS feed URLs (with a name and category for each) and fetches each feed as XML. 3. Parses each feed’s Atom entries from the last 48 hours and extracts the title, link, summary, published date, and feed metadata. 4. Skips any feeds that have no recent entries. 5. Sends each parsed alert to OpenAI (GPT-4.1-mini) to generate a relevance score (1–10), one-sentence insight, sentiment, and recommended action. 6. Keeps only alerts with a relevance score of 4 or higher, aggregates them into a single list, and builds a grouped, sorted HTML email digest. 7. Sends the HTML digest email via Gmail with a subject line that reflects the number of relevant alerts.
Setup 1. Get your Google Alerts RSS feed URL. Go to google.com/alerts, find an existing alert, click the RSS icon at the bottom, and copy the feed URL. 2. Open node 2. Code — Set Alert Feed URLs and replace YOURALERTNAME with a descriptive name for the alert, replace YOURGOOGLEALERTSRSSURL with the RSS URL you just copied, and set the category value to any label you want (for example Brand Monitoring or Competitor Intelligence). To add more feeds, duplicate the object inside the array following the commented examples in the code.
3. Open the OpenAI — GPT-4.1-mini Model step and connect your OpenAI API credential.
4. Open node 11. Gmail — Send Digest Email, connect your Gmail OAuth2 credential, and replace REPLACEWITHYOUREMAIL@example.com with your actual email address.
5. Open node 10. Code — Build HTML Email Digest and find YOURBRANDNAME near the bottom of the code in the footer line — replace it with your company or personal name.
6. Activate the workflow. It will run automatically every 24 hours. To test immediately, use the manual Execute option on node 1. Schedule — Every 24 Hours.
Requirements - Active n8n instance (self-hosted or cloud) - One or more Google Alerts set up at google.com/alerts with RSS feed enabled - OpenAI account with GPT-4.1-mini API access - Gmail account connected via OAuth2 for sending the digest - No additional accounts or API keys required — Google Alerts RSS feeds are publicly accessible