Create, update, and look up Notion contacts by email

Lets any app or form add, update, or find Notion contacts using email as the unique identifier automatically.

How the work actually flows

It branches. Exactly one path is taken.

Pattern: Exclusive Choice (4) · Simple Merge (5)

flowchart TD trig>"contact request received"]:::trig s0["check for existing contact by email"]:::svc s1["return result to requester"]:::task trig --> s0 gx{"× what action was requested"}:::gate s0 --> gx p00["create new contact"]:::task gx -->|"create"| p00 p10["update contact fields"]:::task gx -->|"update"| p10 p20["retrieve contact details"]:::task gx -->|"lookup"| p20 jn{"○ return result"}:::gate p00 --> jn p10 --> jn p20 --> jn jn --> s1 out[/"accurate contact record maintained"/]:::out pay{{"no manual duplicate checking"}}:::pay s1 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceOne path onlyPaths rejoinResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Email AutomationSpreadsheet & Database OpsAPI & Webhook Integration
Connects
Notion

The problem it solves

Your contact list lives in Notion, but every new contact or update means someone opening the database and manually checking whether that person already exists. It's easy to create duplicates or overwrite the wrong record by hand.

Who it fits

A small business or sales team that manages leads and customers in a Notion database.

How it works

  1. A form, app, or manual request sends a contact's details along with an action: create, update, or look up
  2. The system checks Notion for an existing contact using their email address
  3. For a new contact, it creates a row only if one doesn't already exist
  4. For an update or lookup, it finds the matching contact automatically, no manual searching
  5. You receive a confirmation or the contact's current details back
What you get

One clean contact record per customer

Every lead or customer gets added, updated, or found in your Notion database using their email, so records never duplicate.

What you get

An accurate, duplicate-free Notion contact record, created, updated, or retrieved automatically.

What you need

A Notion account with an API integration connected to your contacts database.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Back to the AI Playbook