Different outputs when running node by node and all at once

Questions
1

I am having an issue where when I test my workflow node by node, or manually run each node individually, I will get date outputs for my Google Sheet that are not in quotes. This is the intended output. When I run the entire workflow, either manually triggering it or letting the time trigger run, the output dates are in quotes, which is not the desired format. This is the same situation anytime more than one node is run.

The input data is a SQL query in Snowflake that returns the correct data format (I have previously done this process manually with no issues). Below is the Append node for Google Sheets.

2

Hello, Andrew!

In this case, it would be helpful for you to provide the complete flow for a better analysis of data input and output. One suggestion is to use an n8n expression to ensure the output will always be without quotes, using “replace.”

Example of an expression:

{{ $(‘nodeName’).item.json.dataFieldName.replaceAll(‘"’,‘’) }}

The expression must be placed in the append node of Google Sheets, in the field that fills in that place in your spreadsheet.

I hope this helps!

1 Like