The thing is that I’m trying to build something like a Google Sheets automation where I could tick a checkbox or select an option from a dropdown to trigger an automation.
But after setting up the sheets with the tickbox and dropdown, when I send data to it, instead if the data starting at the first row, it goes all the way down and adds at the point below where the tickbox or dropdown formatting ended.
Please help. How can I fix this? Are there any videos you’d recommend for me to solve this?
You can easily append the value in the drop down from the presets that you have configured in the drop down.
So if you have preset drop down values like : Done, Pending, Action Required.
You can literally send the value that you want the drop should be in, In words from n8n.
If you want the drop down to show “Done” you can send the done value from n8n and then have another automation trigger from that status change.
I believe your issue is about the output data shows up in the wrong location (cells). You may want check your workflow configuration again to see if the output field reference to the desired output location in the spreadsheet.
If you can share your workflow, that’d be very helpful for further investigation.
@darlington_onuegbu welcome to the n8n community!
which spreadsheet field is the reference for the first processing?
another point, empty boxes take up the space of empty cells, so n8n understands it as “range used”. a workaround would be to use a “raw data” sheet without formatting to receive automatic inserts and another formatted/visual sheet for manual operation
Did the issue get resolved ? or are you facing any other issue with this.
Let me know if you’re facing anymore difficulties implementing that logic.
Thanks
For the checkbox column, the issue is usually the same as the dropdown: if the target sheet already has checkbox validation copied far down, Google Sheets treats those cells as part of the used range, so n8n appends after that block.
The clean setup is two tabs: `raw_input` where n8n appends plain rows, and a visible working tab that references `raw_input` and has the checkbox/dropdown UI. If you need one tab only, keep the checkbox validation only on rows that already exist, then apply it to the new row after the append step.
Quick check: is your Google Sheets append node writing into the same formatted tab, or into a separate raw tab?
