Google Sheets trigger node reads date as number

[fxholl]

I have a Google sheet trigger node that reads from a spreadsheet from a landing page.

Out of nowhere, the trigger started reading the timestamp information as a number:

for instance, the date “30/04/2024 13:56:44”:

is read as “45412.58106481482” in n8n:

I need to transform this date or number to timestamp in Brazil timezone, but the current code doesn´t seem to handle the timestamp as a number:

Any suggestion?

Information on your n8n setup

• n8n version: 1.36.4
• Database (default: SQLite): sqlite
• n8n EXECUTIONS_PROCESS setting (default: own, main): main
• Running n8n via (Docker, npm, n8n cloud, desktop app): docker
• Operating system: ubuntu

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[aya]

Hi @fxholl
I think the series of numbers is how Google Sheet stores the dates internally. If you want to make sure that the dates are shown as dates, try setting

Options > Output Formatting > Date Formatting = Formatted Text like so:

hope that helps!

[fxholl]

I just found another solution: I formatted the date column in Google spreadsheet text instead of number or date, and it seems to have fixed the issue.