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

🚀 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 |