I am using the event Create Spreadsheet row to add a row into a Google Sheet. It appears to be inserting new a row, whch breaks cell references in other tabs. I would like to put the new row into the existing blank row at the bottom of a sheet vs. inserting a new blank row. Is that possible?
Best answer by Troy Tessalone
To lookup an existing row you need to use a lookup column and a lookup value.
EXAMPLE
Then when updating the GSheet row, change USED = YES
+14Hi
Zap actions steps:
+14
To lookup an existing row you need to use a lookup column and a lookup value.
EXAMPLE
Then when updating the GSheet row, change USED = YES
Thank you! That lookup and update approach worked. Hopefully someday we will get an enhancement to update into the first blank line so we can skip the lookup
+6That’s amazing
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
