How to return a Google Sheet cell’s value which has been created recently?

I am about to ad frequently rows to a google spreadsheet. The rows are added at the bottom.

I want to return the value for example column A and search for the recently added value at the bottom and return/Copy this to a different spreadsheet.

How do i use the lookup method the right way?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Unfortunately i need to use google sheets. I could drop in a delete request for old rows. Thanks for the advice.



Userlevel 6
Badge +7

Wouldnt advise you to use google sheet here. After 20 lines you will have limits in Zapier. 

Check Airtable & Zapier (Airtable & Zapier = AMAZING)