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.
Steps
- Trigger: Email monitoring of the Gmail inboxGmail
- Smart classification identifies order-related emails
Confirmations, shipping notifications, delivery updates. - Intelligent extraction parses order details
Google Gemini AI or OpenAI. - 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
Inventory check: Notion vs Airtable
Also for scheduling and ops, 13 steps.
Meeting action items to Asana tasks
Also for scheduling and ops, 9 steps.
Calendly meeting prep briefs by email
Also for scheduling and ops, 7 steps.
Gmail and Notion: 5 templates compared
Same two apps, different steps.
Copy records between apps
Other templates that do this task.