Rollup and Formula Fields Missing in Notion Automations

Features
1

Hey everyone,

I’ve been running into an issue while working with Notion and Make.com automations, and I’m curious if anyone else has experienced this.

When I run an automation that interacts with a Notion database, I noticed that fields for rollups or formulas don’t get sent with the rest of the data in the output. For example, here’s what my database looks like in Notion:

  • Name: Text field (works fine, gets sent)
  • Status: Select field (also works)
  • Client ID: Formula field (doesn’t show up in the automation output)
  • Total Revenue: Rollup field (also missing in the output)

Here’s a snippet of the output bundle from Make.com (simplified for clarity):

json

Code kopieren

{
  "Name": "Project A",
  "Status": "In Progress",
  "Client ID": "",
  "Total Revenue": null
}

The formula and rollup fields are either empty or null, even though they’re calculated properly in Notion itself.

Has anyone else dealt with this? Is there a workaround or something I’m missing? I’ve tried reconfiguring the automation and double-checking my Notion properties, but it seems like this is a limitation in how Notion sends data.

Any tips or insights would be greatly appreciated! :blush:

Thanks!

3

Hi Carlo,
It is true that formulas and rollups can be unreliable sometimes via the API in my experience. First, however, I would double check that your Connection has access to the related database that’s the source of the rollup and/or formula properties.

If that still doesn’t work, it’s best to directly retrieve those values from the source database by using “search objects” or “get database item” depending on your specific use case

4

This topic developed into this → Notion Layout Destroying Automations - #2 by Simo