Powered by
Append Values insert a row at the end of the Sprea...
# 🤝help
c
crooked-optician-22559
03/03/2026, 12:56 AM
Hi everyone! I'm having an issue with the Google Sheets "Append Values" card. Problem: The card is inserting data in row 100000 instead of the next available row after existing data. Context: My sheet has a Google Sheets Table defined on it I tried removing the table format using "Delete table" but the Append Values card still inserts at row 100000 The sheet only has 3 rows of data (rows 2-4) plus a header row What I've tried: Deleting empty rows manually The Append Values card configuration Start Column = A, Major Dimension = ROWS, Values = single array with all columns Is there a way to force Append Values to insert right after the last row with data? Or should I use a different card/approach for this use case? Any help appreciated, thanks! 🙏
https://cdn.discordapp.com/attachments/1478194374293848186/1478194374536855633/image.png?ex=69a7834a&is=69a631ca&hm=182c23c395c9543248e05d37d9e68cf2181cfd5e1b66a4e3adf21f621a0c1987&
https://cdn.discordapp.com/attachments/1478194374293848186/1478194375002558607/image.png?ex=69a7834a&is=69a631ca&hm=f3b2b538688e292ef85b0ec8707f740b1d31b432a52be602b72f9c8df9bd666c&
https://cdn.discordapp.com/attachments/1478194374293848186/1478194375313064168/image.png?ex=69a7834a&is=69a631ca&hm=904919f7fdd7b3840d50a6f4200b13ae69eb9abb75d157a5aaf3a9d2f181cab0&
l
loud-crowd-60573
03/03/2026, 3:45 PM
Hey
@crooked-optician-22559
😄
loud-crowd-60573
03/03/2026, 4:11 PM
https://cdn.discordapp.com/attachments/1478194374293848186/1478424472745808116/image.png?ex=69a85996&is=69a70816&hm=f7ab56a6f09c5c01cb8bef929496097a382f074c5d7ec99293e3667958e695f7&
loud-crowd-60573
03/03/2026, 4:11 PM
Ah I see, you are just giving the range of A, you need to set limits in your range A2:B2 for example
2
Views
Previous
Next