https://discord.gg/botpress logo
Append Values insert a row at the end of the Sprea...
# 🤝help
c
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
Hey @crooked-optician-22559 😄
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