Get a daily email of EU sustainability stories without manual work. At 08:30 the system pulls new articles, filters them with AI, and builds a clean digest. Your audience gets timely news in one message.

First, a scheduled check visits the European Commission news page and collects article blocks. HTML parsing pulls title, link, image, type, date, read time, and a short description. A date rule keeps only fresh items. Each article goes through an OpenAI classifier that returns true or false for sustainability. The result is added to the article and saved to Google Sheets for logging and reuse. The sheet then feeds a code step that creates a styled HTML email, which Gmail sends to your list.

Connect Gmail, Google Sheets, and OpenAI, then point the sheet and selectors to your needs. Expect to cut curation from hours to minutes and keep a simple record of what you sent. Great for daily or weekly roundups for clients, internal briefings, or advisory updates. You can adjust the schedule time, filters, and email branding in minutes.

• Daily schedule at 08:30 that runs without human input
• HTTP request pulls fresh content from the EU news site
• HTML extraction collects title, link, image, date, type, read time, and description
• If rule keeps only articles within your chosen date window
• Batch loop processes each article one by one for stable handling
• OpenAI classifier with a structured parser returns a clean true or false
• Set and Merge steps attach the sustainability flag to each article
• Google Sheets append stores every result for history and reuse
• Filtered Google Sheets read pulls only sustainability items for the digest
• Code step builds a branded HTML email and Gmail sends it to your list

• Reduce manual curation from 90 minutes to 10 minutes per day
• Automate up to 80% of copy paste and formatting work
• Improve topic accuracy with a strict true or false AI check
• Handle dozens of articles each morning without extra staff
• Create a simple audit trail in Google Sheets for reporting
• Connect OpenAI, Google Sheets, and Gmail in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Gmail, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Open the Schedule Trigger and confirm your time zone and the 08:30 run time. Adjust if you want a different hour.
4. In the HTTP Request node, keep the default EU news URL or replace it with your preferred source that lists articles publicly.
5. Review the HTML extractor nodes. Make sure the selectors match the page structure. If parsing returns empty values, check the CSS selectors and update them.
6. Open the If node and set your date filter so only recent articles pass. Use the extracted date field and your preferred comparison rule.
7. Double click the OpenAI Chat Model node. In the credential dropdown, click Create new credential, then add your OpenAI API key. Select your model and save.
8. Double click the Google Sheets nodes. In the credential dropdown, click Create new credential, choose Google Sheets OAuth, and follow the on screen steps. Select your spreadsheet and the correct sheet tab.
9. In the Record Results node, map fields to columns like date, title, link, type, description, image, read_time, and sustainability. Run a quick test to confirm a new row appears.
10. Open the Get Sustainability News node and set a filter where sustainability equals true so only qualified items feed the email.
11. Open the Code step that builds the email. Update branding, colors, and intro text as needed. Save and preview the output using an Execute Node test.
12. Configure the Gmail node. In the credential dropdown, click Create new credential and complete OAuth. Set From and To addresses. Send a test email to yourself.
13. Validation: Run the flow once manually. Check the sheet for new rows, confirm the email body shows the listed articles, and verify links open correctly.
14. Troubleshooting: If no articles appear, recheck selectors. If the AI returns null, simplify the prompt. If duplicates show, tighten the date rule. After testing, enable the schedule and activate the workflow.