Hello Make Community,
I am using the Google Sheets Add a Row module and the rows being added are being adding the the top of the sheet instead of the bottom. ie everytime it is inserting into row 2. I have basic headers in row 1, and they are all filled in. I noticed that missing headers caused this issue for others, but this does not seem to be the issue.
Any help would be appreciated.
Thank you!
Welcome to the Make community!
How does your sheet look like?
You have not yet provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any error(s).
To allow others to assist you with your scenario, please provide the following:
Could you please share screenshots of your full scenario? Also include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see what you’re working with to give you the best advice.
You can upload images here using the Upload icon in the text editor:
We would appreciate it if you could upload screenshots here instead of linking to them outside of the forum. This allows us to zoom in on the image when clicked, and prevent tracking cookies from third-party websites.
Thanks for your reply.
There are no errors when the scenario is run, it works really well, this is the only issue.
Screenshot of full scenario attached.
Screenshot of final add a row module attached.
Screenshot output google sheet (blank & basic!).
Hope this helps, let me know if you need any further information.
At this point I’d try to delete and create the module again, and/or delete and create the sheet again.
Thanks for your super quick reply!
I have found the issue…I was keeping column A blank when writing to the sheet, when the next row was written it was jumping above that row.
As soon as I added something to column A of my output the data was adding to the correct rows.
Thanks again for your help!
Lindsey
