How to send dates to Google Sheets as dates and not strings?

Hello! When I send dates to Google Sheets even to date-formatted columns and with correct format, they come as strings. When I apply date formatting to the column, they transform to dates.

Here the date is read just came in the same formatting, but wasn’t transformed to the date type yet:
image

Can I do this automatically?

Hey @artildo, you can configure the Google Sheets node in n8n to treat your values like they would be when manually entered by setting Value Input Mode to User Entered:

This should then result in Google Sheets automatically applying the formatting, similar to what happens if you enter a date manually in the respective column.

@MutedJam thank you!