AutomationMart
Home/Browse/Automated email assistant for suppliers using OpenAI and Google Sheets
n8n

Automated email assistant for suppliers using OpenAI and Google Sheets

n8nn8n9 modulesv1.0
GmailGoogle SheetsOpenAI

Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. How It Works The user makes a request (e.g., “Send an email to my fruit supplier asking for a quote on 1 crate of mangoes.”). Workflow: 1. The AI agent searches for the supplier in a Google Sheets database. 2. It automatically drafts the email using OpenAI (with the

At a glance

Automated email assistant for suppliers using OpenAI and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, OpenAI
Modules
9
Price
Free
Version
v1.0
Automated email assistant for suppliers using OpenAI and Google Sheets workflow diagram

About this workflow

Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. How It Works The user makes a request (e.g., “Send an email to my fruit supplier asking for a quote on 1 crate of mangoes.”). Workflow: 1. The AI agent searches for the supplier in a Google Sheets database. 2. It automatically drafts the email using OpenAI (with the tone and style you define). 3. It sends the email using your Gmail account connected through n8n. This assistant uses: - Google Sheets to manage your suppliers (name and email). - OpenAI to generate clear, natural messages. - MCP (client-server logic) to handle request processing. - Gmail as the sending channel for automated emails. Setup Instructions 1. Create a Google Sheets document with the supplier name and email, like this: |Supplier name|Email| |-|-| |Proveedor de frutas Alvarez|fruteriaalvarez@alvarez.com| 2. Connect your Google Sheets and Gmail accounts within n8n. 3. Add your OpenAI API key. Test the automation by chatting with the integrated assistant. It will generate and send the email automatically to the indicated supplier. Requirements - OpenAI API key to generate email content. - Gmail account connected via OAuth2. - Google Sheets document with your supplier database. - n8n instance (cloud or self-hosted). Customization Adjust the OpenAI prompt to make the email tone more formal, casual, or technical. Add custom fields to your supplier sheet (location, notes, special conditions). Replace Google Sheets with a real database like Supabase or PostgreSQL for greater scalability.

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

Add new Podio tasks to a Google Sheets spreadsheet as a new row

Every time a new task is created in a selected Podio workspace, Make will automatically add it to a specified Google Sheets spreadsheet as a new row. The template uses this [example spreadsheet](https://goo.gl/x4D69C).

Free

Generate SEO-optimized PWA website with Google Gemini and deploy to S3

Generate SEO-Optimized PWA Website with AI and Deploy to S3 Who's it for This workflow is designed for agencies, freelancers, and businesses who want to generate production-ready static websites with built-in SEO optimization and PWA (Progressive Web App) capabilities — all without manual coding. It is best suited for users who need landing pages, portfolios, event pages, or client microsites that are mobile-friendly, SEO-optimized, and installable as apps on any device. What it does This workfl

Free

Upload CSV files to AWS S3 from Google Sheets content

Automatically upload Google Sheets data as CSV files to AWS S3, streamlining data management and storage across platforms with this Make template.

Free

🛠️ Transform JSON to XML for Enhanced AI Prompt Formatting

Overview This template provides a powerful and configurable utility to convert JSON data into a clean, well-structured XML format. It is designed for developers, data analysts, and n8n users who need to interface with legacy systems, generate structured reports, or prepare data for consumption by Large Language Models (LLMs), which often exhibit improved understanding and parsing with XML-formatted input. Use Cases This workflow is ideal for solving several common data transformation problems:

Free

Filter and delete rows in Google Sheets based on specific criteria

Automatically filter and delete rows in Google Sheets based on specific criteria, streamlining data management and ensuring your spreadsheets remain organized and relevant.

Free

Complete business WhatsApp AI-powered RAG chatbot using OpenAI

The provided workflow in n8n is designed to create a Business WhatsApp AI RAG (Retrieval-Augmented Generation) Chatbot. --- How it works: 1. Webhook Setup: The workflow begins by setting up webhooks for verification and response. The Verify webhook receives GET requests and sends back a verification code, while the Respond webhook handles incoming POST requests from Meta regarding WhatsApp messages. 2. Message Handling: Once a message is received, the workflow checks if the inc

Free

Turn YouTube meeting recordings into Notion notes with AI Agent, deAPI & Slack

Who is this for? - Teams who upload meeting recordings to YouTube (unlisted or private) and want automated notes - Project managers who need to track action items across recurring meetings - Remote teams who want searchable, structured meeting notes in Notion - Content teams repurposing recorded calls into documentation What problem does this solve? Meeting notes are either rushed, incomplete, or never written at all. This workflow removes that bottleneck — upload a recording to YouTube

Free

Automate bank statement and invoice reconciliation with GPT and Google Sheets

Manual Trigger Workflow starts manually to initiate the reconciliation process on demand. 📄 Fetch Invoices & Bank Statements Retrieves invoice data and bank statement data from Google Sheets for comparison. 🔀 Merge Data Combines both datasets into a single structured dataset for processing. 🧩 Format Payload for AI Function node prepares and structures the merged data into a clean JSON payload for AI analysis. 🤖 AI Reconciliation AI Agent analyzes the invoice and bank statement data to identify m

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