n8n
ecommerce

n8n Ecommerce Pack (Gmail + OpenAI) — 5 Workflows

Automate email processing, sales tracking, and calendar management with 5 n8n workflows.

What This Pack Does

This pack includes five n8n workflows that automate email-driven ecommerce operations using Gmail, OpenAI, and other services. The first workflow extracts and summarizes sales-related emails with OpenAI, then creates sales opportunities in Odoo. The second automatically extracts metadata from new Gmail emails and stores it in Google Sheets for record-keeping. The third labels Gmail messages using OpenAI and the Gmail API to streamline email management. The fourth converts Monoprix delivery emails into Google Calendar events via ChatGPT. The fifth captures sender information from Gmail and stores it in a MySQL database to maintain an up-to-date contact list. Together, these workflows connect Gmail, OpenAI, Odoo, Google Sheets, Google Calendar, and MySQL, enabling automated email processing, data extraction, contact management, and calendar integration for ecommerce teams.

Who It's For

Ecommerce operations managers, sales teams, and customer support staff who handle high volumes of sales-related emails and need to track opportunities, maintain contact lists, and organize delivery schedules. Also useful for small business owners using Odoo, Google Sheets, or MySQL who want to automate repetitive email tasks without manual data entry.

Highlights

  • Summarizes sales emails and creates Odoo opportunities
  • Extracts Gmail metadata to Google Sheets
  • Labels Gmail messages with OpenAI
  • Converts Monoprix delivery emails to calendar events
  • Stores Gmail contacts in MySQL database

Included Workflows(5)

Example Use Case

Imagine a small ecommerce team receives dozens of sales inquiries daily. The first workflow automatically summarizes each email and creates a sales opportunity in Odoo. Meanwhile, the second workflow logs all email metadata into Google Sheets for tracking. When a Monoprix delivery confirmation arrives, the fourth workflow instantly adds the delivery date to the team's shared Google Calendar. The third workflow labels important emails for follow-up, and the fifth workflow captures new customer contacts into MySQL, ensuring no lead is missed.

Primary Integrations

Gmailtrigger
Odoo
@n8n/n8n Nodes Langchain Lmopenai
Stickynote
@n8n/n8n Nodes Langchain Chainsummarization
Code
Set
Googlesheets

Related Packs