# Zapier fails to trigger after deleting a sheet row **URL:** \ **Category:** Ask for Help\ **Created:** [November 9, 2021, 2:41pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261 "2021-11-09T14:41:36Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 9, 2021, 2:41pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/1 "2021-11-09T14:41:36Z")
Hello everyone, Hope I am not double posting on this fabulous Forum (I have already learned so much thanks to you guys). My issue is as follow : - I have an action triggered by a button “delete event” ![Picture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b9968ad298fc1ee2f2540a2185ff31f41f4e07b.png) - this action is supposed to delete the spreadsheet row and send a zap trigger to find/delete the event created by another zap - Unfortunately, when the zap is triggered : the event cannot be found on the spreadsheet. I have the feeling it has been deleted in the spreadhsheet before the zap gets triggered. Would you know a way around ? I was thinking of triggering the row deletion with a zap, however i heard, it creates a blank row. My formulas are ARRAY based. Thanks a lot ! ---
**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:** [November 9, 2021, 3:39pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/2 "2021-11-09T15:39:31Z")
If your Zap is deleting the row, why do you also need the delete row Glide action? Sounds like you’re trying to delete the same row twice. As far as the holes in your spreadsheet goes, that will definitely happen when you use the Glide Delete Row action. Not sure about Zapier (I don’t use it), but I suspect not. ---
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 9, 2021, 3:52pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/3 "2021-11-09T15:52:57Z")
Thanks a lot for your reply, My zap is (supposedly) deleting the google calendar event only The action delets the row in the google sheet. ---
**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:** [November 9, 2021, 3:56pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/4 "2021-11-09T15:56:41Z")
ah, I see. Apologies, my bad. I didn’t read properly. Only thing I can suggest is going with your idea of doing both with Zapier. Have you tried that? ---
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 9, 2021, 4:29pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/5 "2021-11-09T16:29:29Z")
First of all, I have to tell that I was wrong thinking that triggering a delete row with zapier would destroy my ARRAYFORMULA. ![Picture4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa0340ec81ccf7d15cff0aa0596b50860568e597.png) It looks like the path to follow then. However, here is my issue now : THe Zap halted : The google Calendar Find Step reports an error now. The app returned “Not Found”. ![Picture5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/195371be491666c19765ff1bb4397e52bd81c536.png) ![Picture6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e6950de85e7192cdd8b30dc9cdfed0f393726baa.png) The row deletion completed but not the calendar one due to missing Item. Is this the same source of the issue ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 9, 2021, 11:06pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/6 "2021-11-09T23:06:08Z")
How are you telling Zapier to search for the event? What criteria did you use? ---
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 10, 2021, 5:59pm UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/7 "2021-11-10T17:59:53Z")
Hello ! Sorry for my late reply, I use a Find event step indeed : ![Picture4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa0340ec81ccf7d15cff0aa0596b50860568e597.png) I use the first cell of my colum (Brew name) to look for the event ![Capture d’écran 2021-11-11 005240](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c4dccf66f04bba0c6f49e7e7e6038d9c7d4a6650.png) then I use the name of the event from google calendar (found by zapier). However in the test phase, i realize that I have the following error message : We’re having trouble loading ‘Event’ data (The app returned “Not Found”.) ![Capture d’écran 2021-11-11 005840](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bc514c8395c86e0e1a9a5a0d77ea0c2e4dde8588.png) It is weird because the event exists in the calendar : ![Capture d’écran 2021-11-11 005923](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43b2eb949c8be27ee6bc6d6e4eb0e0949b2b7038.png) 🧐 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 11, 2021, 12:09am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/8 "2021-11-11T00:09:18Z")
Shouldn’t you be able to choose the event from the search step? What’s your “description” field there linked to? ---
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 11, 2021, 2:31am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/9 "2021-11-11T02:31:45Z")
Hi ! Normally yes, I put the field “Name of the event” as value 1 in the field. However, it fails to find it ![Picture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/9788172a520d2b146f5332f1be9cb10f234ff798.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 11, 2021, 9:34am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/10 "2021-11-11T09:34:39Z")
I mean what does the dropdown in the delete event step show when you click on it? ---
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 12, 2021, 4:19am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/11 "2021-11-12T04:19:19Z")
Sure, Here it is : ![Capture d’écran 2021-11-12 101521](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab93ce176752b719c6aa26201e5d1c85d56426ba.png) Thanks a lot for your help ! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 12, 2021, 9:36am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/12 "2021-11-12T09:36:26Z")
When you click the “Event” tab instead of the “Custom” do you have an option to choose from the event found in the second step? ---
**Author:** ![Thomas\_Punty](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_punty/32/32382_2.png) [@Thomas\_Punty](https://community.glideapps.com/u/Thomas_Punty)\ **Post date:** [November 12, 2021, 9:55am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/13 "2021-11-12T09:55:42Z")
Unfortunately not despite the fact that all the steps test cleared successfully. ![Capture d’écran 2021-11-12 165431](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01ece1f86984e11e262b7c8dde1f7e312ce00e2f.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 12, 2021, 10:48am UTC](https://community.glideapps.com/t/zapier-fails-to-trigger-after-deleting-a-sheet-row/34261/14 "2021-11-12T10:48:36Z")
This is weird. I would try running a test from the 2nd module downwards and check again if you can actually select from the screenshot above. Else I have no further input…