Skip to main content
Question

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

  • July 19, 2021
  • 2 replies
  • 87 views

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

Wemakefuture
Forum|alt.badge.img+8
  • Zapier Solution Partner
  • July 19, 2021

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

Check Airtable & Zapier (Airtable & Zapier = AMAZING) 

 


  • Author
  • New
  • July 20, 2021

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