Updating pipedrive deals based on excel spreadsheet

Hi,

I’m trying to create my first scenario: when a row is added or updated in an excel spreadsheet, a date property on the related deal should be updated in pipedrive.

What I’ve managed to do so far:

  • connect excel & pipedrive to make.com
  • map the deal_id and date column between pipedrive and excel

However, when running the automation, I’m getting this error: BundleValidationError Validation failed for 2 parameter(s). Invalid number in parameter ‘id’. Invalid date in parameter

How can I solve this? The deal_id is stored in number format (e. g. 1234) and the date is stored in date format in excel (e. g. 01.01.2025).