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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.