AutomationMart
Home/Browse/Add, update, and fetch contacts from a Notion database by email
n8n

Add, update, and fetch contacts from a Notion database by email

n8nn8n12 modulesv1.0
NotionWebflow

Overview Store, update, and retrieve contacts in a Notion database by sending a JSON payload to an n8n workflow. Email is used as the unique identifier — no Notion page IDs required. ✨ What this workflow does The workflow has three actions, controlled by a single action field in the payload: - Create — checks if a contact with that email already exists. Blocks the request if it does. Creates a new row in Notion if it does not. - Update — finds the contact by email automatically and updates their

At a glance

Add, update, and fetch contacts from a Notion database by email is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion, Webflow. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Notion, Webflow
Modules
12
Price
Free
Version
v1.0
Add, update, and fetch contacts from a Notion database by email workflow diagram

About this workflow

Overview Store, update, and retrieve contacts in a Notion database by sending a JSON payload to an n8n workflow. Email is used as the unique identifier — no Notion page IDs required. ✨ What this workflow does The workflow has three actions, controlled by a single action field in the payload: - Create — checks if a contact with that email already exists. Blocks the request if it does. Creates a new row in Notion if it does not. - Update — finds the contact by email automatically and updates their details. No Notion page ID needed. - Get — searches Notion by email and returns the contact's details. 🔧 Requirements - An n8n instance (cloud or self-hosted) - A Notion account with an API integration token - A Notion database with these columns: | Column | Notion type | |--------|-------------| | Name | Title | | Email | Email | | Phone | Phone number | | Status | Select — suggested options: Lead, Contacted, Qualified, Customer, Closed | | Notes | Text | ⚙️ Setup 1. Create a Notion integration — go to notion.so/my-integrations, create a new integration, and copy the token. 2. Add credentials in n8n — go to Credentials → New → Notion API → paste your token → save. 3. Connect your database — in Notion, open your database → click ... top right → Connections → select your integration. 4. Select your database in n8n — open each Notion node in the workflow and pick your database from the dropdown. 5. Test — use the Manual Trigger with the sample payloads below to confirm each branch works. 6. Go live — replace the Manual Trigger with a Webhook node. Send POST requests to the generated URL from any app or form. 📚 Sample payloads Use these in the Manual Trigger to test each action: Create a contact: Update a contact: Fetch a contact: 🖥 Connect a frontend This workflow works as a backend API. Any frontend can send POST requests to the Webhook URL and display the response — no direct Notion API connection needed in the frontend. What n8n handles so your frontend does not have to: - Checks for duplicate emails before creating a contact - Finds the correct Notion row by email before updating — no page ID management - Returns structured JSON responses for success and error states To wire up a frontend: replace the Manual Trigger with a Webhook node, point your form or dashboard at the Webhook URL, and read the JSON response to show feedback to the user. Works with React, Vue, plain HTML, or no-code tools like Webflow or Bubble. 💡 Notes - status values are case-sensitive — send Lead not lead. - Every contact must have a unique email address. The create action blocks duplicates. - The update action returns an error if the email is not found — run create first. - The get action returns one contact per email lookup.

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

Retrieve Stripe customers for new Webflow orders

Every time a new order is created in Webflow, Make will automatically retrieve all Stripe customers.

Free

Notion MCP + Webhook Response to Flowise AI

Receives a webhook, queries your Notion workspace for a specific question, and sends the response back to the original webhook sender. This scenario was originally designed as part of a Flowise AI - Notion MCP demo. - simosme.com

Free

Summarize youtube videos from transcript for social media

YouTube Video Summarizer for Social Media Turn any YouTube video into a short, structured summary using AI — perfect for content creators, marketers, or social media managers. --- 🔧 What We Built We created a no-code automation in n8n that: - Accepts a YouTube Video ID via a form - Fetches the video transcript using an external API - Summarizes the transcript using AI (Google Gemini) - Automatically saves the summary to Google Docs for team use --- 🧩 Flow Overview | Step |

Free

Automatic pantry inventory management with Notion and email notifications

Pantry Soft-Stock Refill — Notion Thresholds → Grocery List + Email What it does (the vibe) Your pantry’s calm concierge. Each evening it checks your Notion Pantry for items at or below your Reorder Level, adds tidy rows to Grocery List, and sends a pretty summary email you can shop from. ✨🛒 Perfect for Moms, home managers, and founders who want a kitchen that quietly manages itself—no last-minute “we’re out!” moments. Requirements n8n with Notion + Email credentials connected Two Notion datab

Free

Automate image portfolio organization with GPT-4o Vision, Google Drive and Notion

Overview This template is ideal for photographers, graphic designers, and creative professionals who manage large volumes of visual assets. It is also perfect for Digital Asset Managers looking for a customizable, automated solution to organize files without manual tagging. What it does When a new image is uploaded to a designated "Inbox" folder in Google Drive, the workflow performs the following actions: - AI Analysis: Uses GPT-4o to analyze the image content, generating a descript

Free

Auto-respond to Gmail enquiries using GPT-4o, Dumpling AI & LangChain agent

Who is this for? This workflow is perfect for customer support teams, sales departments, or solopreneurs who receive frequent email enquiries and want to automate the initial response process using AI. If you spend too much time answering similar questions, this system helps respond faster and more intelligently—without writing a single line of code. --- What problem is this workflow solving? Manually responding to repeated customer enquiries slows productivity and increases delay.

Free

Sync new Shopify products to Odoo products

Seamlessly sync newly created Shopify products into Odoo with this smart, no-code n8n workflow. Automatically checks for duplicates and creates new products only when needed – fully compatible with standard Odoo setup. 🚀 Key Features: Trigger-based Automation: Starts instantly when a new product is created in Shopify Duplicate Check: Searches for an existing product in Odoo using Shopify’s product SKU as the Internal Reference (Default Code) Smart Condition Logic: If a matching product is found,

Free

Upload Google Drive files to an InfraNodus graph

This template can be used to upload the files in your Google drive to an InfraNodus knowledge graph. The InfraNodus graph will then reveal the main topics and ideas in your collection of documents and show the content gaps in them. You can also use the built-in AI to converse with the documents. You can also access the InfraNodus Graphs via its GraphRAG API to re-use them in your other n8n workflows for high-quality content retrieval and knowledge base optimization. The template showcases the u

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