AI-Powered Sustainability Newsletter with GPT-4o, Gmail & Sheets
Automates daily curation of EU sustainability news using web scraping and GPT-4o, stores in Google Sheets, and sends HTML newsletters via Gmail for marketing.
This n8n workflow triggers every morning to scrape the latest articles from the EU Commission News Portal. It leverages OpenAI's GPT-4o to intelligently classify and filter articles for sustainability relevance, ensuring only the most pertinent content is selected. Results are logged in a Google Sheet for easy tracking and analysis.
Next, it generates a professional HTML email digest featuring article titles, AI-generated summaries, and images. The newsletter is then automatically sent via Gmai
Platform
n8n
Category
IT & Development
Price
$19.99
Creator
Jordi Faber
Sustainability
Newsletter
Marketing
OpenAI
GPT-4o
Web Scraping
Google Sheets
Gmail
Automation
AI
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.