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.

Hi there, 

I’m trying to build a zap that will pick a single use link from a spread sheet and send it to a new user.

New user are created in a spreadsheet which trigger the zap, but I can’t figure out a way to zapier to go pick a the link in a second spreadsheet to add it in an email.

The sequence will be: user create in a spreadsheet A,  zapier get’s single use link in spreadsheet B, and add it to an email ( user, email from spreadsheet A) and delete the used single use link from spreadsheet B.

For some reason zapier want to to search a value, but I only need to get the link line by line. 

 

Any help would be much appreciated.

 

Thanks

Luc

Hi @LucJ 

You can use “Get many spreadsheet rows” to get the values of the second spreadsheet without having to search anything. Your 2nd spreadsheet must have a header row.

I don’t exactly know how your sheets are formatted, if you can attach screenshots that’ll make it easier to understand.

Thanks you Robschmidt,

 

Works great. Last little thing, when I delete row in the spreadsheet it just leave a blank space,  As I only want to retrieve the first line and delete afterward, the whole content will need to shift up. Deleting the row, not just the data.

Delete row doesn’t seem to have this fonction

 

Thanks

 

I found this code that does what I want, but not sure if it’s possible to implement it in Zapier.

Other option would be to find the first row with data from the bottom and search and replace by a blank space, not sure either what to use for that.

 

So I found my solution using this post: 

1- Trigger New spreadsheet row

2- find the first empty line using google sheet expresion ( adding Blank Row if line empty)  Formula: =ArrayFormula(IF(ISBLANK(A2:A),"Blank Row",Row(A2:A)))

3- in python I substrat 1 to the result to find the first line with my link

4- Get line data

5- send this email

6- delete the line in in number 5

 

 

Terms & Conditions