Inserting JSON datatable to google sheets

Questions
1

Hi everyone!

Im a new user trying to insert a json datatable (image 1) into google sheets. At first i tried to use AI Agent with google sheets tool but it only has options to append row and not append table…

next i tried to use “loop over rows” (image 2) but it doesnt seem to work (nothing shows in output when i test it using my JSON input.

How should i approach this problem? appreciate any help

image
image1867×973 160 KB

image
image1837×875 61 KB

2

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:
3

Hi,

Before looping over items, you need multiple “items”. To do this, use Split Out node with key of your array, “output”.

Hope it works.

1 Like