Question

How can I update a specific Notion database item that triggered a Zap?

  • 16 October 2023
  • 1 reply
  • 730 views

I’ve been waiting for over a year for this feature ever since Notion acquired Automate.io. Would love to know if there’s any way to do it in Zapier or if I ultimately have to go to another automation tool.

What I want to do is: As an action I want to update a property in the specific item in a Notion database that triggered the Zap. Here’s an example: 

When I update the status of a database item to "done" in Notion, create a new folder in Google Drive with the name of the item in step 1, and update the Notion item from step 1 with the link to the Google Drive folder from step 2.

In Automate it was easy to chose the “trigger item” in an action whereas it seems you can only choose a specific database item by name in Zapier. 

Hope this is possible. Thanks in advance!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +6

Hi there @frederikvester,

Welcome to the Community! 🎉

I have recreated your desired workflow, and here’s how I achieved it:

  1. Trigger: Notion - Updated Database - I have created a “Select” property named “Status” in Notion so that we can use that to our Filter step:
    2623718b1239c9ff62370650ac4ac6f2.png
    (view larger
     
  2. Action: Filter by Zapier - We’re going to use the “Status” “Select” property from the trigger for the Zap to only continue if the “Status” is “Done”. Like so:
    5f4d1807db5bcfb9c7326267d2837465.png
    (view larger)
     
  3. Action: Google Drive - Create Folder - Map the “Title” or “Name” data from the trigger to the “File Name” field. Like so:
    2cc84708f7809c0d7db2d6405f4e607e.png
    (view larger)
     
  4. Action: Notion - Find Database Item - We’re going to need to add the “Find Database Item” step for us to fetch the Item ID and Database ID. Like so:
    8e27b4c1a38d85a062e87bd890a542fb.png
    (view larger)
     
  5. Action: Notion - Update Database Item - We’re going to map the Database ID from the Find Database Item step to the “Database” field and the same with the Item ID, and we’re going to map the Folder link to the “URL” field. Like so:
    b63f4f3927e6fe52316a0c642a0242a0.png
    (view larger)

Here’s the result of this Zap:

ea4d11c8a6a1e090ed3080d2de0ff5cc.gif
(view larger)

Zap run:
bedd8d9f6eea0ab76584fb84d17359a4.png
(view larger)
1fefb58c95d90ac73c0d8d27e779788f.png
(view larger)

Do you think this could work for you? Please let me know! 😊