How to Automate Notion Database Updates with Make.com (Step-by-Step)

Why Automate Notion Databases (and When Manual Updates Fail)

Notion is one of the most flexible productivity tools available, with over 30 million users as of 2024. But flexibility cuts both ways. A database with 10 properties and 200 rows requires hundreds of individual updates every week if you're managing it manually.

The Hidden Cost of Manual Upkeep

Manual database management introduces three specific failure points:

1. Human error — Copy-paste mistakes, wrong status values, and forgotten rows are nearly inevitable at scale.

2. Lag time — When a deal closes in your CRM, that status change doesn't instantly appear in your Notion project tracker unless someone goes and updates it.

3. Context switching — Moving between apps to sync data breaks focus. Studies by the American Psychological Association found task-switching costs can reduce productivity by up to 40%.

Automation eliminates all three. With Make.com, you define the logic once, and every update happens in real time—accurately, instantly, and without anyone touching a keyboard.

When Automation Makes the Most Sense

You're ready for automation when:

• The same data lives in two or more tools (e.g., a form, a spreadsheet, and a Notion database)

• You update the same Notion property more than 10 times per week

• A delay in updating a record has caused a real problem (missed follow-up, stale status, wrong priority)

Setting Up Your Make.com Scenario for Notion

Before building your first automation, you need two things: a Make.com account and a Notion integration token.

Step 1: Create a Make.com Account

Go to Make.com and sign up for a free account. The free tier includes 1,000 operations per month—enough to automate a small database or test your setup before committing to a paid plan.

Step 2: Create a Notion Integration

1. Go to https://www.notion.so/my-integrations

2. Click New Integration

3. Name it (e.g., "Make.com Sync") and select the workspace it should access

4. Copy the Internal Integration Token—you'll need this in Make.com

Step 3: Share Your Database with the Integration

In Notion, open the database you want to automate:

1. Click the ... menu in the top-right corner

2. Select Connections → Add connections

3. Find your integration by name and confirm

Without this step, Make.com will return a "page not found" error even with a valid token.

Step 4: Connect Notion to Make.com

1. In Make.com, create a new scenario

2. Add a Notion module (search for "Notion" in the module library)

3. When prompted to create a connection, select API Key and paste your integration token

4. Name the connection and save it

Make.com will verify the token immediately. If it fails, double-check that the integration is shared with the correct database.

Step-by-Step: Trigger, Filter, and Update Notion Records Automatically

Now let's build a real scenario. This example automatically updates a Notion project database whenever a task is marked complete in a Google Form submission—a common use case for teams tracking deliverables.

Step 1: Choose Your Trigger

The trigger is the event that starts your automation. Common triggers for Notion workflows include:

• Google Forms / Typeform — New form submission creates or updates a Notion record

• Gmail / Outlook — New email matching a filter updates a Notion row

• Webhook — Any external app sends data to Make.com

• Schedule — Make.com runs the scenario on a fixed interval (every hour, daily, etc.)

For this example, select Google Forms → Watch Responses as your trigger module.

Step 2: Map Your Data

1. After configuring your trigger, add a Notion module: Update a Database Item

2. Select the database you shared in the setup steps

3. Map each form field to the corresponding Notion property:

• Form field "Project Name" → Notion Name (title property)

• Form field "Status" → Notion Status select property

• Form field "Assignee" → Notion Person property

• Submission timestamp → Notion Last Updated date property

Make.com's visual mapper shows all available Notion properties automatically once your database is connected.

Step 3: Add a Filter (Optional but Recommended)

Filters prevent unnecessary operations. For example, only update Notion if the form submission status equals "Complete":

1. Click the connection line between your trigger and Notion module

2. Select Add a Filter

3. Set condition: Status → Equal to → Complete

This saves operations and keeps your Notion database clean.

Step 4: Handle "Create or Update" Logic

One common challenge: should the scenario create a new Notion page or update an existing one?

Use Make.com's Search Objects module before your update step:

1. Add Notion → Search Database Items before the update module

2. Search for a record where the title matches the incoming form data

3. Add a Router module with two paths:

• Path A: Record found → Update a Database Item

• Path B: Record not found → Create a Database Item

This pattern is called "upsert" logic and is essential for any CRM or project tracking automation.

Step 5: Test and Activate

1. Click Run Once to test with a single real record

2. Verify the Notion database updated correctly

3. Check the execution log in Make.com for any errors

4. Toggle the scenario to Active when everything looks right

Make.com logs every execution with input/output data, making it easy to debug if something goes wrong later.

Common Use Cases: CRM Updates, Project Tracking, and Content Calendars

CRM Updates

Connect your lead capture form (Typeform, Tally, or a website form via webhook) to a Notion CRM database. Every new lead gets a row automatically with name, email, source, and a default status of "New Lead." When a deal closes in a separate sales tool, a webhook updates that row's status to "Won" or "Lost" in real time.

Project Tracking

Link your project management tool (Asana, Linear, or GitHub Issues) to a Notion project tracker. When a task moves to "Done" in your primary tool, Make.com mirrors that change in Notion—keeping stakeholders who live in Notion always up to date without requiring your developers to touch it.

Content Calendars

This is one of the highest-ROI use cases. Connect your content planning spreadsheet or Airtable base to a Notion editorial calendar. When a content piece is approved in your spreadsheet, Make.com creates the Notion page with all metadata (title, target keyword, publish date, assignee) already filled in. Writers can start immediately without waiting for manual setup.

Automated Status Rollups

Make.com can also run on a schedule to audit your Notion database. For example, every morning at 8 AM, a scenario checks all project rows where the due date has passed and the status is still "In Progress"—and automatically changes the status to "Overdue." This kind of proactive maintenance is impossible to do reliably by hand.

Conclusion

Automatic Notion database updates are one of the fastest ways to cut operational overhead in a growing team or solo operation. Make.com's visual builder makes the setup accessible to anyone—you don't need to write a single line of code to build workflows that would otherwise take a developer hours to create.

Start with one high-friction update you make every week. Build the automation, test it, and watch it run. Once you see how much time it saves, you'll wonder why you ever did it manually.

Ready to automate your Notion workspace? Create a free Make.com account and connect your first Notion database in under 15 minutes.

Frequently Asked Questions

Does Make.com have a native Notion integration?

Yes. Make.com has a built-in Notion module that supports all major operations: searching databases, creating pages, updating properties, and appending content to blocks. No custom API code is required.

Is the free Make.com plan enough to automate Notion?

For light use, yes. The free plan includes 1,000 operations per month and supports 2 active scenarios. If you're running multiple automations or processing high volumes (hundreds of form submissions per day), a paid plan starting at $9/month provides 10,000 operations and unlimited active scenarios.

Can Make.com update Notion properties in bulk?

Not in a single operation, but you can use Make.com's iterator module to loop through an array of records and update each one sequentially. This approach works well for batch updates triggered on a schedule.

What's the difference between Make.com and Zapier for Notion automation?

Both platforms integrate with Notion, but Make.com offers more advanced logic (routers, iterators, error handlers) at a lower price point. Zapier's interface is simpler for basic automations, but Make.com handles complex multi-step workflows better. For "upsert" logic (create or update), Make.com is significantly more capable.

How do I avoid hitting Notion's API rate limit?

Notion's API allows 3 requests per second per integration. Make.com scenarios that process large batches can hit this limit. To avoid errors, add a Sleep module (set to 500ms) between Notion operations in high-volume scenarios, or switch to Make.com's built-in error handling to automatically retry failed requests.