You’re offline. This is a read only version of the page.
Hello all,
I'm trying to set up an automation that triggers when an email is received with an order number in the subject line.
I then need to get rows, and then update another column for the row where the order number matches the email reference.
My problem is that the Google Sheet is huge, with over 20,400 rows and growing all the time. Most of the rows aren't needed for this automation, just the last 400 or so.
How can I do the Get Rows and Update Rows functions for Google Sheets, but only look in the last 400 rows of data?
#1
stampcoin
91
#2
Michael E. Gernaey
70
Super User 2025 Season 1
#3
David_MA
48
Super User 2025 Season 1
Share
Report
All responses (
Answers (