AutomationMart
Home/Browse/Personalized email automation using Google Docs, Pinecone, GPT-4o and Gmail
n8n

Personalized email automation using Google Docs, Pinecone, GPT-4o and Gmail

n8nn8n18 modulesv1.0
GmailNotionOpenAI

What Problem Does This Solve? πŸ› οΈ This workflow automates the process of extracting information from a Google Doc, storing it in a Pinecone vector database, and using it to personalize and send emails based on user input via chat. It eliminates the manual steps of gathering recipient data, writing messages, and dispatching emails providing a fully automated, intelligent communication system. Perfect for teams that need to: Maintain dynamic contact lists Personalize bulk or contextual e

At a glance

Personalized email automation using Google Docs, Pinecone, GPT-4o and Gmail is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects Gmail, Notion, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Notion, OpenAI
Modules
18
Price
Free
Version
v1.0
Personalized email automation using Google Docs, Pinecone, GPT-4o and Gmail workflow diagram

About this workflow

What Problem Does This Solve? πŸ› οΈ This workflow automates the process of extracting information from a Google Doc, storing it in a Pinecone vector database, and using it to personalize and send emails based on user input via chat. It eliminates the manual steps of gathering recipient data, writing messages, and dispatching emails providing a fully automated, intelligent communication system. Perfect for teams that need to: Maintain dynamic contact lists Personalize bulk or contextual email outreach Use chat interfaces to trigger intelligent email actions --- Target Audience: Sales teams, marketing departments, HR staff, startup founders, or anyone looking to automate AI-powered communication workflows. --- What Does It Do? 🌟 Extracts content from a Google Docs document (e.g., a list of contacts or structured notes) Splits, embeds, and stores that content in Pinecone for semantic search Listens for incoming chat messages using n8n's chatTrigger Uses LangChain agents with OpenAI to: Search Pinecone for contextually relevant information (e.g., email addresses) Compose personalized emails based on instructions Sends emails using the Gmail API, triggered dynamically from the AI output --- Key Features πŸ“‹ Google Docs integration for live document data Embedding & vector search with Pinecone for AI lookups Custom LangChain agents with tool calling logic (search + send) Full support for OpenAI models (GPT-4o) Personalized email generation with dynamic name and message filling Modular design: plug-and-play with other tools like CRMs, Notion, etc. --- Setup Instructions Prerequisites n8n Instance: Self-hosted or cloud instance Google Docs Account: For reading input content Pinecone Account: For storing document data semantically OpenAI Account: For generating embeddings and messages Gmail Account: With Gmail OAuth2 credentials for sending emails --- Installation Steps πŸ“¦ 1. Import the Workflow Import the provided JSON files into your n8n instance. 2.Configure Credentials Go to n8n > Credentials, and set up: Google Docs API OpenAI API Pinecone API Gmail OAuth2 3. Set Your Pinecone Index & Namespace Ensure you have a working Pinecone index (e.g., n8ndocs) and namespace (e.g., docsmail). 4. Test the Full Flow Run the Google Docs β†’ Pinecone embedding workflow to prepare data. Send a message to the chatTrigger endpoint (e.g., "Send an offer to User"). Check the execution log to verify correct tool usage and Gmail delivery. --- How It Works πŸ” 1. Data Preparation: Google Doc content is fetched and chunked. OpenAI embeddings are created. Data is stored in Pinecone under a specific namespace. 2. Chat Trigger: A webhook captures chat input. The LangChain agent interprets the user request. The agent uses two tools: Vectorstoremails: Retrieves relevant emails via Pinecone vector search sendmail: Uses an internal n8n sub-workflow to send Gmail messages 3. Mail Generation & Delivery: Email is personalized using recipient info (name/email from Pinecone) Message follows a clean, friendly format with clear subject and closing Delivered via Gmail integration

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

Save new Gmail attachments to lexoffice

Save new Gmail attachments to lexoffice Every time you receive a new email in Gmail with an attachment, Make will save that attachment in lexoffice.

Free

Scrape business leads from Google Maps using OpenAI and Google Sheets

Google Maps Data Extraction Workflow for Lead Generation This workflow is ideal for sales teams, marketers, entrepreneurs, and researchers looking to efficiently gather detailed business information from Google Maps for: - Lead generation - Market analysis - Competitive research --- Who Is This Workflow For? - Sales professionals aiming to build targeted contact lists - Marketers looking for local

Free

Send a Gmail email confirmation and 2 follow-up emails for a new Wix form submission - part 1

Every time a visitor fills out a Wix form on your site, Make will automatically send an email confirmation, a follow-up email the following day, and another one a week later (email is sent using Gmail). This template is divided into 2 parts. In the first part, you retrieve the form submission data and send an email. In the second one, you're sending 2 follow-ups. You can find the second part [here](https://www.make.com/en/integration/5707-send-a-gmail-email-confirmation-and-2-follow-up-emails-f

Free

CallForge - 05 - Gong.io call analysis with Azure AI & CRM sync

CallForge - AI Sales Call Processing & Insights Extraction Automate sales call analysis with AI-powered insights for sales, marketing, and product teams. Who is This For? This workflow is designed for: βœ… Sales teams looking to extract structured insights from Gong call transcripts. βœ… Marketing professionals seeking AI-driven customer pain points & content strategy. βœ… Product teams needing feedback from sales calls to prioritize feature development. πŸ” What Problem Does This Workflow Solve?

Free

Monitor Slack group channels and generate responses with Perplexity AI and OpenAI's assistant and Google Docs

Monitor Slack group messages and generate AI-driven responses with Perplexity AI and 2 OpenAI's assistant prompts, then insert the result as a paragraph in Google Docs for streamlined communication management.

Free

Extract and save new articles to Google Sheets using OpenAI and HTML conversion

Automatically extract new articles from RSS feeds, convert HTML to text, summarize with OpenAI, and save to Google Sheets for easy access.

Free

Send personalized daily learning emails for women using GPT-4o and Gmail

Description Most learning newsletters send the same email to everyone. This workflow does the opposite β€” every subscriber gets a completely different email every single day, personalized to their topic interest, learning phase, and how far they've come in their journey. Built specifically for women's skill development programs, coaching platforms, and edtech creators who want to deliver real personalized learning at scale without manually writing hundreds of emails. You manage the content librar

Free

News research and sentiment analysis AI agent with Gemini and SearXNG

This n8n workflow operates as a two-agent system where each agent has a specialized task. The process flows from initial user input to a final analysis, with a seamless handoff between the agents. How it works 1. The Chat Trigger The entire process begins when you send a message using n8n's chat interface. This message serves as the initial prompt or query for the system. 2. The Research Agent Takes Over The user's message is first sent to the Research Agent. This agent's job is to understa

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