AutomationMart
Home/Browse/๐Ÿ—ž๏ธ AI-powered sustainability newsletter for marketing with Gmail, GPT-4o
n8n

๐Ÿ—ž๏ธ AI-powered sustainability newsletter for marketing with Gmail, GPT-4o

n8nn8n16 modulesv1.0
GmailGoogle SheetsOpenAILinkedIn

Tags: Sustainability, Web Scraping, OpenAI, Google Sheets, Newsletter, Marketing Context Hey! Iโ€™m Samir, a Supply Chain Engineer and Data Scientist from Paris, and the founder of LogiGreen Consulting. We use AI, automation, and data to support sustainable business practices for small, medium and large companies. I use this workflow to bring awareness about sustainability and promote my business by delivering automated daily news digests. []( > Promote your business with a fully automated news

At a glance

๐Ÿ—ž๏ธ AI-powered sustainability newsletter for marketing with Gmail, GPT-4o is a ready-made n8n workflow you import as a workflow JSON file โ€” no build required. It connects Gmail, Google Sheets, OpenAI, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, OpenAI, LinkedIn
Modules
16
Price
Free
Version
v1.0
๐Ÿ—ž๏ธ AI-powered sustainability newsletter for marketing with Gmail, GPT-4o workflow diagram

About this workflow

Tags: Sustainability, Web Scraping, OpenAI, Google Sheets, Newsletter, Marketing Context Hey! Iโ€™m Samir, a Supply Chain Engineer and Data Scientist from Paris, and the founder of LogiGreen Consulting. We use AI, automation, and data to support sustainable business practices for small, medium and large companies. I use this workflow to bring awareness about sustainability and promote my business by delivering automated daily news digests. []( > Promote your business with a fully automated newsletter powered by AI! This n8n workflow scrapes articles from the official EU news website and sends a daily curated digest, highlighting only the most relevant sustainability news. ๐Ÿ“ฌ For business inquiries, feel free to connect with me on LinkedIn Who is this template for? This workflow is useful for: - Business owners who want to promote their service or products with a fully automated newsletter - Sustainability professionals staying informed on EU climate news - Consultants and analysts working on CSRD, Green Deal, or ESG initiatives - Corporate communications teams tracking relevant EU activity - Media curators building newsletters What does it do? This n8n workflow: 1. โฐ Triggers automatically every morning 2. ๐ŸŒ Scrapes articles from the EU Commission News Portal 3. ๐Ÿง  Uses OpenAI GPT-4o to classify each article for sustainability relevance 4. ๐Ÿ“„ Stores the results in a Google Sheet for tracking 5. ๐Ÿงพ Generates a beautiful HTML digest email, including titles, summaries, and images 6. ๐Ÿ“ฌ Sends the digest via Gmail to your mailing list How it works []( 1. Trigger at 08:30 every morning 2. Scrape and extract article blocks from the EU news site 3. Use OpenAI to decide if articles are sustainability-related 4. Store relevant entries in Google Sheets 5. Generate HTML email with a professional layout and logo 6. Send the digest via Gmail to a configured recipient list What do I need to get started? Youโ€™ll need: - A Google Sheet connected to your n8n instance - An OpenAI account with GPT-4 or GPT-4o access - A Gmail OAuth credential setup Follow the Guide! Follow the sticky notes inside the workflow or check out my step-by-step tutorial on how to configure and deploy it. []( ๐ŸŽฅ Watch My Tutorial Notes - You can customise the system prompt to adjust how AI classifies โ€œsustainabilityโ€ - Works well for tracking updates relevant to climate action, green transition, and circular economy This workflow was built using n8n version 1.85.4 Submitted: April 24, 2025

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n โ†’ click the menu โ†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Capture leads from forms to Google Sheets and send Gmail reminders

System Overview Workflow Name: New Lead and Reminder System What This System Does: This n8n automation captures new leads from a form submission and automatically: Saves them to a Google Sheet database Sends personalized emails to prospects based on their budget Sends you admin notifications of new leads Reminds you daily about leads you haven't called yet Helps you track which leads have been contacted How It Works - Step by Step: PART 1: NEW LEAD CAPTURE Form Submission Trigger - Someone fills

Free

Import new attachments from Gmail to PowerOffice

Make will watch for new emails received in Gmail and import emails' attachments of specified format to PowerOffice.

Free

Automate Zoom ๐ŸŽฆ user onboarding with OAuth token management and data tables

This workflow automates the management of Zoom OAuth tokens and the creation of new Zoom users through the Zoom API. This workflow automates the process of creating a new Zoom user by first ensuring a valid OAuth access token is available. It is designed to handle the fact that Zoom access tokens are short-lived (1 hour) by using a longer-lived refresh token (90 days) stored in an n8n Data Table. It includes two main phases: 1. Token Generation & Management The workflow initially requests a Zoo

Free

Answer HR questions with GPT-4o-mini, PostgreSQL, Pinecone and ElevenLabs

This template provides a fully functional, enterprise-grade HR chatbot that employees can interact with using plain language in text or voice in any of the 10 supported Indian languages. The bot recognizes the employee's identity, the company they work for, and the relevant HR policies that apply to them. It can access live leave balances directly from your PostgreSQL HR database, search for company-specific HR policy documents stored in Pinecone, and retain conversation history for follow-up q

Free

Personalize an introduction message with ChatGPT for new HubSpot CRM leads and store them on a Google Sheet for review

Optimize your introduction message using ChatGPT, a personalized approach for new HubSpot CRM leads, and save on Google Sheets for easy review and management.

Free

Create ClickUp tasks from new Google Sheets spreadsheet rows

Automatically create new tasks in ClickUp every time there is a new row in Google Sheets. Use this example spreadsheet for a quick and simple setup.

Free

Generate trend-based marketing videos with Seedance AI, Perplexity, and GPT

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ๐ŸŽฌ Seedance Video Marketing AI Agent Description: This AI-powered marketing automation workflow takes a user prompt, researches trending topics, generates a compelling short-form video prompt, and sends it to the Seedance API via Wavespeed to create a ready-to-use video ad โ€” all from a single Telegram message. Built for marketers, founders, and content creators who want to turn trend-based id

Free

Interview Scheduling Automation with Google Sheets, Calendar, Gmail & GPT-4o'

SEO-Optimized Description: Streamline your interview scheduling process with this intelligent n8n automation template powered by Google Calendar, Google Sheets, and GPT-4. This workflow reads candidate information from a spreadsheet, automatically schedules interviews in Google Calendar, and sends personalized interview invitation emailsโ€”all without manual input. What This Template Does: ๐Ÿ“‹ Monitors a Google Sheet for new candidate entries every minute ๐Ÿ•’ Auto-selects the next available

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint โ€” instant download
  • Setup guide PDF included
  • 5 downloads ยท valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

โ‚น2,499/ session
3 hrs ยท video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free