Problem with inserting `data` in Google Sheets

I have a problem with n8n and Google Sheets.

Why does n8n insert data as '08/14/2023, instead of 08/14/2023? For example:

Hi @mxcdh, welcome to the community!

My best guess is this might be related to the data format you are using in the respective sheet column.

Depending on what exactly you are doing (as in which version of n8n you are using, how exactly your Google Sheet looks like) it might be enough already to set the Cell Format option to Let Google Sheets format as shown below to prevent this:

In case that’s not it, can you confirm which version of n8n you are currently using, and share an example workflow along with an example Google Sheet using which your problem can be reproduced?

Thank you!

1 Like

Thanks @MutedJam

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.