Order emails to a Notion database

Extracts order details from Gmail and syncs them to a Notion database. This n8n template monitors a Gmail inbox for new emails and identifies order-related messages such as confirmations, shipping notifications and delivery updates. Order details, including order number, items, prices, status and delivery information, are extracted with Google Gemini or OpenAI and a structured output parser. The workflow searches the Notion database before writing, then creates or updates the matching record, and only modifies a record when the order status changes. It suits people who follow orders from several online shops. The page states that a self-hosted n8n instance is required.

n8nRead on 2026-11-164 steps

Steps

  1. Trigger: Email monitoring of the Gmail inboxGmail
  2. Smart classification identifies order-related emails
    Confirmations, shipping notifications, delivery updates.
  3. Intelligent extraction parses order details
    Google Gemini AI or OpenAI.
  4. Output: Database synchronization creates or updates Notion recordsNotion

Limits

  • Requires a self-hosted instance.
  • The Notion database must follow the schema given on the page.

What it does well

  • Searches existing records before creating a new one.
  • Updates a record only when the order status changes.

Before you import

Needs a Gmail account with IMAP access, a Google Gemini or OpenAI API key, and a Notion database with the schema given on the page.

Similar templates