Date fields between Notion and Google Sheets

[Rebecca_Katz]

I am getting an error “Invalid date in parameter ‘start’.” when trying to update a DB item in Notion. I know Notion is weird/picky about dates when importing from CSV, so I’m assuming that’s where my error is coming from. That said, I could use some help from someone who has been here before me.

Here is my scenario:

1. A new DB item is added in Notion, which sends a webhook to Make.
2. Get that DB item.
3. Update a cell in Google Sheets with one of the properties from the DB item.
   (Formulas in Sheets do their magic. Cell F2 is a date as MM/DD/YYYY. Cell G2 is a date as yyyy-mm-ddTHH:mm:ssZ, which is the format needed to import a date into Notion from CSV and have Notion recognize it as a date.)
4. Update the DB item.

I get the same error on module 5 (update item in Notion) regardless of whether I get cell F2 or G2 in module 4.

These are the outputs in each of the modules, along with the settings for module 5.

Webhook output

Get a DB item output

Module 3 setup

Module 3 output

Module 4 input and output

Module 5 setup

[Simo]

Hi Rebecca,
Try using the “parseDate” function in the module that outputs the error. That’s because a hypothesis is that the dates are strings in the Google Sheets output, and the Notion module requires a date.

I also notice there is “Get a cell [bundle]” mapped in Module 5, which doesn’t look right, since it sounds like you’d like to specifically map cell F2 or G2 from the Sheet to Notion

[Stoyan_Vatov]

Hey Rebecca,

the last screenshot you are mapping the entire output of module 4 as a JSON file. You are not mapping a column value or a date type variable.

[Rebecca_Katz]

This seems to be a regular issue I have! Thank you for pointing it out to me repeatedly. As a Make newbie, I think the actual problem (though stay tuned for another issue I’ve been unable to solve on my own) is that I try to add modules without running the module before them, which means that the correct fields aren’t available to map. Now that I’ve realized this, maybe I’ll be better about remembering to do it going forward?

HOWEVER, now that I’ve mapped the correct item, I’m getting another error. This is the error message:

The “oyEq” item is the date being passed from Notion to Google Sheets between modules 2 and 3.
The “KePs” item is the date being passed back from Google Sheets to Notion between modules 4 and 5.

This is the output from the webhook:

And this is the properties (not property values) in the output from module 2:

I think there is probably something I’m missing in how Make sends data back to Notion (because this isn’t the only scenario where I’m having a problem), but since I’m not sure what it is, I don’t know where to look on my own to find the answer.

[Simo]

Try mapping the “Label” shown in the last screenshot instead of the property ID. I believe Make modules use the Label for properties

[Rebecca_Katz]

I think that’s what I was doing. I get two different errors depending on where I pull the key from.

1. Using webhook output
If I pull from the webhook output as in this screenshot:

I get this error:

2. DB item properties
And when I use the DB item properties:

This is the error I get: