Google sheets outputting null

Questions
1

Hi there,

I am building a flow where I’m reading all rows from a google sheet and where I want to insert the data in another sheet.

When reading the cells, the preview is showing values but then when writing the data, it says it’s NULL. Any idea why this is happening?

image
image1730×1253 99.5 KB

3

Hi @Ricky_Wolff :wave:

Could you use ctrl/cmd + A then ctrl/cmd + C to copy your workflow, and then paste it over here between two sets of three backticks (```) so we can take a closer look? If you can give us a sample Google sheet with example data, that would help, too.

Can you also answer the following:

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

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