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

  • 19 July 2021
  • 2 replies

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

Userlevel 7
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) 


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