Skip to main content

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?

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.