Question

Unable to recognize "Status Field" in the Notion database in my Zap.

  • 12 August 2023
  • 9 replies
  • 857 views

Userlevel 1

Im trying to send a slack message when a Notion database item is set to done. But apparently Zapier doesnt recognize the Status field? 
 

Can anyone think of a workaround for this?


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

9 replies

Userlevel 7
Badge +14

HI @Shane_M 

Good question.

You may have to configure some Notion automation to set another field value that can be used as the trigger.

 

I can't see all fields

The following Notion field types are not supported:

  • Files and media
  • Formulas
  • Relations
  • Rollups
  • Status

If you have fields that belong to one of these field types, they won't appear in Zapier.

Userlevel 1

Thanks Troy. Any would that automation take place in Zapier as well? Or would it have to be set up in Notion?

Userlevel 7
Badge +14

@Shane_M 

It would likely have to be configured in Notion.

Userlevel 1

The weird thing is I see other Status properties in the Zap test. For example. 
 

 

Userlevel 7
Badge +14

@Shane_M 

Which Notion Zap trigger/action does that screenshot come from?

Showing a screenshot with full detailed context will help.

Userlevel 1

The events is “update database item” then I have a filter to look for a specific Status. 

 

https://www.loom.com/share/2b0a1299d4b44e1999de4d6ef9cc7eed

Userlevel 1

it’s weird because the correct property shows up in the Filter (ie Status)
 

But it’s not pulling the data from the notion side of things. But again, I do see multiple status properties in the Notion test data (Prv Status = a rollup of the previous task status & ‘R4 Prj Status’ which is a rollup of the status of the project the task is a part of). 

 

I just dont see the main status property of that particular task itself. Though “filters” does seem to recognize it. 

Here is the Test Data from the notion trigger:

 

title

Choose 2-3 people for him to recommend

object

page

id

90f0657c-276b-448f-baff-f234536ded8c|2023-08-18T17:04:00.000Z

created_time

2023-07-01T00:32:00.000Z

last_edited_time

2023-08-18T17:04:00.000Z

created_by

object

user

id

8a0b8bc3-b0c5-4b75-811d-5d6c6e98750e

last_edited_by

object

user

id

8a0b8bc3-b0c5-4b75-811d-5d6c6e98750e

cover

icon

type

external

external

url

https://www.notion.so/icons/arrow-northeast_gray.svg

parent

type

database_id

database_id

a1bf680c-5655-482b-9015-e713b42b4a28

archived

false

properties

F4 Prv Status

type

string

string

In Progress

Overview

PB Clients

Created by

object

user

id

8a0b8bc3-b0c5-4b75-811d-5d6c6e98750e

name

Shane Martin

avatar_url

https://s3-us-west-2.amazonaws.com/public.notion-static.com/856afe54-d18e-41c6-b5c6-397a7b0f97fd/Shane-Headshot-2.jpg

type

person

person

email

shane@weareleanmean.com

F4 Warn any

type

string

string

F4 Blocked date

type

boolean

boolean

true

F4 End date

type

date

date

start

2023-09-07

end

time_zone

R4 Prv Status

1

type

status

status

id

in-progress

name

In Progress

color

blue

R4 Prj Status

1

type

status

status

id

in-progress

name

In Progress

color

purple

Previous task

1

c9ff9112-df02-4f02-be01-68c3c7d4f717

Reviewer

Warning

type

string

string

F4 Active date

type

date

date

start

2023-08-31

end

2023-09-07

time_zone

Created time

2023-07-01T00:32:00.000Z

Next task

1

edc69204-4638-4a31-bce3-81a93a4ed018

R4 Client

1

type

title

title

1

type

text

text

content

Eric Partaker

link

annotations

bold

false

italic

false

strikethrough

false

underline

false

code

false

color

default

plain_text

Eric Partaker

href

Task name

Choose 2-3 people for him to recommend

Tags

Assignee

Date

start

2023-08-31

end

2023-09-07

time_zone

Sub-tasks

Parent-task

1

531f5e0c-38f6-4a86-bd27-387d00dc82b2

Phase

Phase 1

Month

Is Blocking

Blocked By

Client

1

d956e977-5013-402f-b7c4-625ef8aa595b

url

https://www.notion.so/Choose-2-3-people-for-him-to-recommend-90f0657c276b448fbafff234536ded8c

public_url

https://shanemartin.notion.site/Choose-2-3-people-for-him-to-recommend-90f0657c276b448fbafff234536ded8c

page_id

90f0657c-276b-448f-baff-f234536ded8c

Duplicate to edit

Continue with selected record

ver. f6d4cd74

Client Comms > Completed Task Notification | Zapier

 

 

 

Userlevel 7
Badge +14

@Shane_M 

Have you tried turning the Zap ON and testing?

Then check your Zap Runs to see the DATA IN/OUT for each Zap step.

https://zapier.com/app/history/

Userlevel 7
Badge +14

@Shane_M 

In the Zap Run, for the Notion trigger DATA OUT, do you see the Status field and value?

If not, then that’s why the Filter step is not passing.

And may be related to the originally documentation that Status field type is not supported.

 

I can't see all fields

The following Notion field types are not supported:

  • Files and media
  • Formulas
  • Relations
  • Rollups
  • Status

If you have fields that belong to one of these field types, they won't appear in Zapier.