JoacoMaurtua
JoacoMaurtua6mo ago

google sheet

Hello community, I am implementing a node to send answers from my form to a google sheets sheet, I have already managed to get the answers to my table, the problem is that each answer overwrites the previous one, instead of the table starts to fill downwards each answer replaces the previous one in the cells, does anyone know how I can solve this?
Solution:
After the first row is added, you can skip it, or define different ranges. https://developers.google.com/sheets/api/guides/concepts#cell
No description
Jump to solution
4 Replies
JoacoMaurtua
JoacoMaurtua6mo ago
This is my node:
No description
Gaurav Chadha
Gaurav Chadha6mo ago
Hi @JoacoMaurtua, you can avoid the Cell Number field, let it be empty to avoid the data being overwritten on the same cell.
JoacoMaurtua
JoacoMaurtua6mo ago
But how would I know the node where to start writing the data?
Solution
Gaurav Chadha
Gaurav Chadha6mo ago
After the first row is added, you can skip it, or define different ranges. https://developers.google.com/sheets/api/guides/concepts#cell
No description