Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I hope you guys can help with following Zap:

 

Every time I put a video into a specific Dropbox folder I’d like to update a Google Sheets row. The challenge for me is that not a specific row needs to be updated, instead the rows should be updated dynamically. 

 

Here is a screenshot of my Google Sheet: https://imgur.com/a/9PQfMC9

 

Every time a new Dropbox video gets uploaded, the new Dropbox link should be inserted into the next Google Sheets row (“New Dropbox link”). How could that be possible? 

 

I’ve spend hours trying to figure this out. Maybe someone could point me into the right direction.

 

Thank you so much!

Try this action: GSheets - Lookup Row (search for “New Dropbox link”)

 

Try this action: GSheets - Lookup Row (search for “New Dropbox link”)

 

I already tried to use “Lookup Spreadsheet Row”. Could not manage it properly.

How can “Lookup Spreadsheet Row” work if I have lots of different rows with “New Dropbox link” inside my Google Sheet? See https://imgur.com/a/lyZsEm3. How can I define that the new Dropbox link should be put underneath an existing Dropbox link?

How can “Lookup Spreadsheet Row” work if I have lots of different rows with “New Dropbox link” inside my Google Sheet? How can I define that the new Dropbox link should be put underneath an existing Dropbox link?

In the GSheets Lookup Row action step settings, there is the option to search top>down OR bottom>up.

This behavior will find the first matching row depending on the direction.

 

 

I tried that already, but the problem is that I don’t know what to put inside “Lookup value”: 

 

Here I share with you the Zap: https://zapier.com/shared/34466ebd1a7fd0df340cd415264ef89f35962728

Lookup Value would be “New Dropbox link” (assuming “New Dropbox link” is the value in all the cells you want updated)

@Likamundi are you trying to add the link to an existing row or you want to add a new row and only fill the dropbox link?

@Troy Tessalone You were very helpful to me, thank you so much! I figured it our so far how to make it work.  

 

@Nate I wanted to add the link to an existing row. Now everything seems to work fine. Thanks!

@Likamundi wonderful! 

Terms & Conditions