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:
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
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.