AutomationMart
Home/Browse/Newsletter summarization & briefing with Gmail, AI, Google Sheets & Email
n8n

Newsletter summarization & briefing with Gmail, AI, Google Sheets & Email

n8nn8n12 modulesv1.0
GmailGoogle SheetsOpenAIGemini

Your inbox is overflowing with daily newsletters: Public Affairs, ESG, Legal, Finance, you name it. You want to stay informed, but reading 10 emails every morning? Impossible. What if you could get one single digest summarizing everything that matters, automatically? ❌ No more copy-pasting text into ChatGPT ❌ No more scrolling through endless email threads ✅ Just one smart, structured daily briefing in your inbox Who Is This For Public Affairs Teams: Stay ahead of political and regulato

At a glance

Newsletter summarization & briefing with Gmail, AI, Google Sheets & Email is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, OpenAI, Gemini
Modules
12
Price
Free
Version
v1.0
Newsletter summarization & briefing with Gmail, AI, Google Sheets & Email workflow diagram

About this workflow

Your inbox is overflowing with daily newsletters: Public Affairs, ESG, Legal, Finance, you name it. You want to stay informed, but reading 10 emails every morning? Impossible. What if you could get one single digest summarizing everything that matters, automatically? ❌ No more copy-pasting text into ChatGPT ❌ No more scrolling through endless email threads ✅ Just one smart, structured daily briefing in your inbox Who Is This For Public Affairs Teams: Stay ahead of political and regulatory updates—without drowning in emails. Executives & Analysts: Get daily summaries of key insights from multiple newsletters. Marketing, Legal, or ESG Departments: Repurpose this workflow for your own content sources. How It Works 1. Gmail collects all newsletters from the day (based on sender or label). 2. HTML noise and formatting are stripped automatically. 3. Long texts are split into chunks and logged in Google Sheets. 4. An AI Agent (Gemini or OpenAI) summarizes all content into one clean daily digest. 5. The workflow structures the summary into an HTML email and sends it to your chosen recipients. Setup Guide • You’ll need Gmail and Google Sheets credentials. • Add your own AI Model (e.g., Gemini or OpenAI) with an API key. • Adjust the prompt inside the “Public Affairs Consultant” node to fit your topic (e.g., Legal, Finance, ESG, Marketing). • Customize the email subject and design inside the “Structure HTML-Mail” node. • Optional: Use Memory3 to let the AI learn your preferred tone and style over time. Cost & Runtime Runs once per day. Typical cost: $0.10–0.30 per run (depending on model and input length). Average runtime: <2 minutes.

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 a Website by CloudConvert and upload the output files to Google Drive

Get URLs of websites in Google Sheets and make captures of them in CloudConvert. Upload the output files to Google Drive.

Free

Create and send messages using Claude to ChatGPT audio generation and send via HTTP

Automate message creation and audio generation by integrating Claude and ChatGPT. Send personalized messages with audio content effortlessly to your app via HTTP.

Free

Add new Encharge people to a Google Sheets spreadsheet

Every time a new person has been added to Encharge, Make will automatically add a new row to a specified Google Sheets spreadsheet. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1p3MrBOGK6kW3EavnQtgjEw9QKZB00qBzrJX7RUVOFrU/edit?usp=sharing).

Free

AI Shopify product descriptions: GPT-4o Vision + Claude + Analytics

Complete AI Product Description Generator Transforms product images into high-converting copy with GPT-4o Vision + Claude 3.5 The Shopify AI Product Description Factory is a production-grade n8n workflow that converts product images and metadata into refined, SEO-aware descriptions—fully automated and region-agnostic. It blends GPT-4o vision for visible attribute extraction, Claude 3.5 Sonnet for premium copy, Perplexity research for verified brand context, Google Sheets for orchestrati

Free

Turn any website into an AI support chatbot with OpenAI and Pinecone

Complete AI support system using website data (RAG pipeline) This template provides a full end-to-end Retrieval-Augmented Generation (RAG) system using n8n. It includes two connected workflows: 1. A data ingestion pipeline that crawls a website and stores its content in a vector database. 2. A customer support chatbot that retrieves this knowledge and answers user queries in real time. Together, these workflows allow you to turn any public website into an intelligent AI-powered support assistant

Free

Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets

This n8n workflow monitors pharmacy inventory stored in a Google Sheet, checks daily for low stock or near-expiry medicines, and sends alerts to the pharmacist via email, ensuring timely restocking and waste prevention. Why Use It This workflow automates inventory management for pharmacies, reducing the risk of stockouts or expired medicines, saving time, minimizing losses, and ensuring compliance with safety standards by providing proactive alerts. How to Import It 1. Download the W

Free

Create an image enhancement API endpoint with Nero AI Business API

How it works This template uses the n8n AI agent node as an orchestrating agent that decides which tool (knowledge graph) to use based on the user's prompt. How to use - Create an account and apply for an API key on - Fill your key into the Create task and Query task status nodes. - Select an AI service and modify Create task node parameters, the API doc: - Execute the workflow so that the webhook starts listening. - Make a test request by postman or other tools, the test URL from the Webhook

Free

Automate stale deal follow-ups in Salesforce with GPT-5.1, email, Slack & tasks

How it works - Runs every morning at 8:00 using the Schedule Trigger. - Sets a staledays value and queries Salesforce for Opportunities where StageUnchangedDaysc equals that value and the stage is not Closed Won / Closed Lost. - For each “stale” Opportunity, loads full deal details and sends them to an OpenAI model. - The model uses the querysoql tool to pull recent Notes, the primary Contact, and the Opportunity Owner, then returns a single JSON object with: - a persona

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