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:
Jump to solution
After the first row is added, you can skip it, or define different ranges. https://developers.google.com/sheets/api/guides/concepts#cell
Google for Developers
Google Sheets API Overview | Google for Developers
4 Replies
This is my node:
Hi @JoacoMaurtua, you can avoid the Cell Number field, let it be empty to avoid the data being overwritten on the same cell.
But how would I know the node where to start writing the data?
Solution
After the first row is added, you can skip it, or define different ranges. https://developers.google.com/sheets/api/guides/concepts#cell
Google for Developers
Google Sheets API Overview | Google for Developers