New Gsheet sheet and update it

I have a usecase that looks very simple but that I don’t manage to do.

I use a webhook to retrieve information from responses to Tally surveys.
When the webhook triggers, I reformat the JSON to extract the questions and answers from the surveys.
I then want, for each new survey, to create a new Google Sheet document that has the questions in the first column and the corresponding answers in the second column.
What I can’t manage to do is to add data to an empty sheet.

Information on your n8n setup

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

I had a workaround which was to use Google drive node to create a gsheet by copying an existing doc.

So problème solved.

1 Like

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