# Add a value to my Zapier action, then lookup for row in spreadsheet

**URL:** <https://community.glideapps.com/t/add-a-value-to-my-zapier-action-then-lookup-for-row-in-spreadsheet/10566>\
**Category:** Ask for Help\
**Created:** [June 9, 2020, 8:05am UTC](https://community.glideapps.com/t/add-a-value-to-my-zapier-action-then-lookup-for-row-in-spreadsheet/10566 "2020-06-09T08:05:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Clement\_YEROCHEWSKI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clement_yerochewski/32/8500_2.png) [@Clement\_YEROCHEWSKI](https://community.glideapps.com/u/Clement_YEROCHEWSKI)\
**Post date:** [June 9, 2020, 8:05am UTC](https://community.glideapps.com/t/add-a-value-to-my-zapier-action-then-lookup-for-row-in-spreadsheet/10566/1 "2020-06-09T08:05:43Z")

</div>

Hello,

Where is my mistake ? I am trying to send a value to my Zap via Glide, but it either doesn’t seem to work or I am missing a step/understanding.

I would like to send an email to Zapier via a Glide Action, lookup for this email in my spreadsheet where the column “in progress” is set to TRUE then update the column “in progress” from the row found to FALSE.

I just cannot make the lookup work using the email form the glide action, or I just don’t understand how to make this work.

Here is how my Zapier is setup:

- New Zapier from Glide Action  
 ![Screenshot 2020-06-09 at 09.59.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9ca413292453ec06da25c6d243064342198cc701.png)  
 ![Screenshot 2020-06-09 at 09.50.21](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/23d5aa6175dbf8eb7b49daf14240ce32536b1419.png)
- Look up for row in spreadsheet  
 ![Screenshot 2020-06-09 at 09.50.56](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0a98d4cff651d874e60558969f7b7d75f92fbfd0.png)
- Update row in spreadsheet  
 ![Screenshot 2020-06-09 at 10.02.51](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f55ccf6c0126d8450af871d41af3b67167d61673.png)

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![Madaleno](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/madaleno/32/7177_2.png) [@Madaleno](https://community.glideapps.com/u/Madaleno)\
**Post date:** [June 9, 2020, 1:39pm UTC](https://community.glideapps.com/t/add-a-value-to-my-zapier-action-then-lookup-for-row-in-spreadsheet/10566/2 "2020-06-09T13:39:51Z")

</div>

Try selecting this (in the update row), I have an identical zap and wasn’t working until I selected row this way.

 ![Captura de pantalla 2020-06-09 a las 15.36.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f516d7b0c60eff3dad0cba87df9110038d0ea14c.png)

---

<div class="post-metadata">

**Author:** ![Clement\_YEROCHEWSKI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/clement_yerochewski/32/8500_2.png) [@Clement\_YEROCHEWSKI](https://community.glideapps.com/u/Clement_YEROCHEWSKI)\
**Post date:** [June 9, 2020, 6:42pm UTC](https://community.glideapps.com/t/add-a-value-to-my-zapier-action-then-lookup-for-row-in-spreadsheet/10566/3 "2020-06-09T18:42:08Z")

</div>

Thanks for your answer, but after trying to have the value directly in the zap, the one I am tryingt o match for the to lookup, it works. using Val1 from Glide doesn’t work, I am sending [test@email.com](mailto:test@email.com) via Glide as Value 1, which is the owner, doesn’t work and I cannot debug, writing that same email instead of using value 1 from glide works.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 8, 2024, 6:04am UTC](https://community.glideapps.com/t/add-a-value-to-my-zapier-action-then-lookup-for-row-in-spreadsheet/10566/4 "2024-05-08T06:04:27Z")

</div>