Im wanting to lookup a specific row that is the 3rd row up from the last row in a google sheet. So for example, if the last value input into a row is in row 10, I want to look up what the data is that is 3 rows up from this, so in row 7, in a specific column. Is this possible?
Question
How do I lookup a specific row (3rd from the last) in a Google Sheet using Zapier?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
You would likely have to use the GSheet API to do that.
https://developers.google.com/sheets/api/guides/concepts
ZapConnect 2026 is coming
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.