Format date strange behaviours and bad row selection

[nybblegroup-finance]

Describe the problem/error/question

I have a simple Google Form with a related Google Sheet and I’m trying to use the Google Sheets trigger with mixed behaviours.

1. Using the Row Added option is including the Header column as part of the response data.
2. Using the Row Added or Updated does not include the Header column as part of the data, but all dates are incorrectly formatted as numbers while they are not with the Add Row option.

This seems to be a bug and I would like to avoid workaround code.

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

[

{

“Marca temporal”: 45657.68458149306,

“Dirección de correo electrónico”: “[email protected]”,

“Invoice Date”: 45650,

“Invoice”: “https://drive.google.com/open?id=1mSweDx-asd”,

“Company”: “DDFF a S.A.”,

“Notes”: “Notas”

}

]

Information on your n8n setup

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