Personalized Email Automation using Google Docs, Pinecone, GPT-4o and Gmail

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:

Vectorstore_mails: Retrieves relevant emails via Pinecone vector search

send_mail: 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