# Cannot Update a row **URL:** \ **Category:** Questions\ **Tags:** google-sheets\ **Created:** [February 1, 2024, 10:38am UTC](https://community.make.com/t/cannot-update-a-row/26126 "2024-02-01T10:38:39Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Caine\_Wai](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@Caine\_Wai](https://community.make.com/u/Caine_Wai)\ **Post date:** [February 1, 2024, 10:38am UTC](https://community.make.com/t/cannot-update-a-row/26126/1 "2024-02-01T10:38:39Z")
[blueprint.json](https://community.make.com/uploads/short-url/32BzbYwkMG6DKZ6qD3aV4s3hI4F.json) (85.6 KB) Hi, I am trying to set up a scenario where once the tracking number is updated, it will trigger 2 actions: 1. Send an email to the recipient informing them of the tracking information (working) 2. Update the “follow-up” column by inserting a Y, so that future runs will not go through those rows where emails have already been sent. I have added a filter in the search row module. ![WeChat截图_20240201183153](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/0/f03e93810c78e48633ec3eed7d57cf295b7e3e75.jpeg) ![WeChat截图_20240201183315](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/e/2ec08f828f04e45ae6aa862f385c4210f1e904e0.jpeg) ![WeChat截图_20240201183306](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/4/a4db5e324f0dc1687078b06ca4bdce6521c7112f.jpeg) The email part works fine but the update row part isn’t working. How can I make it update the row as the scenario goes through the said row? ![WeChat截图_20240201184323](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/2/42e4b31b1daf434a1ff8dd6faa57d3dd90047b5f.jpeg) ![WeChat截图_20240201184340](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/d/dd1610f7857a112953d0811fe73dbdb7b2021322.jpeg) ![WeChat截图_20240201184403](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/1/81534a16007ef5c89cdb5b311bac6c8c6144eb05.jpeg) Below is the output of the Search Rows module: ```auto [ { "0": "Faux Eyelashes+Castor Oil", "1": "Amber Baker", "2": "15407340491", "3": "", "4": "8705 Shane lane apt 216 ", "5": "Spotsylvania ", "6": "Virginia", "7": "22553", "8": "92144902915417509270072112", " __ROW_NUMBER__": 2, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 1 }, { "0": "Faux Eyelashes", "1": "Holly powell", "2": "14345794120", "3": "", "4": "109 Leigh st", "5": "South Boston ", "6": "Virginia", "7": "24592", "8": "92144902915417509270063097", " __ROW_NUMBER__": 5, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 2 }, { "0": "Premium Black Castor Oil", "1": "Rawan Khazil ", "2": "18582648942", "3": "", "4": "3881 Caminito Aguilar, E", "5": "San Diego", "6": "California", "7": "92111", "8": "92144902915417509270063080", " __ROW_NUMBER__": 6, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 3 }, { "0": "Premium Black Castor Oil", "1": "Owen Kiefer", "2": "12672647294", "3": "", "4": "10 Blayze Ct", "5": "Newtown", "6": "Pennsylvania", "7": "18940", "8": "92144902915417509270063073", " __ROW_NUMBER__": 7, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 4 }, { "0": "Faux Eyelashes,", "1": "Viola Golden Flame", "2": "16053809696", "3": "", "4": "1238 Pearl St", "5": "Alameda ", "6": "California", "7": "94501", "8": "92144902915417509270063066", " __ROW_NUMBER__": 8, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 5 }, { "0": "Premium Black Castor Oil", "1": "Jennifer krutsinger", "2": "16186826004", "3": "", "4": "1100 S Washington st ", "5": "Salem", "6": "Illinois", "7": "62881", "8": "92144902915417509270063059", " __ROW_NUMBER__": 9, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 6 }, { "0": "Premium Black Castor Oil", "1": "Tristan Kiperman", "2": "13105604637", "3": "", "4": "1951 Thayer Ave", "5": "Los Angeles", "6": "California", "7": "90025", "8": "92144902915417509270063042", " __ROW_NUMBER__": 10, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 7 }, { "0": "Premium Black Castor Oil", "1": "Rebecca Clayton ", "2": "19855514910", "3": "", "4": "900 mudcut rd. ", "5": "Pine Knot ", "6": "Kentucky", "7": "42635", "8": "92144902915417509270063035", " __ROW_NUMBER__": 11, " __SPREADSHEET_ID__": "1cH__2KqxfzxyGMw7o8bjdD31VnkVl2NVbMRT36saLP8", " __SHEET__": "Sheet1", " __IMTLENGTH__": 8, " __IMTINDEX__": 8 } ] ``` ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [February 1, 2024, 11:09am UTC](https://community.make.com/t/cannot-update-a-row/26126/2 "2024-02-01T11:09:34Z")
Hi @Caine_Wai It seems that in the update module, the Row number column is mapped with ‘5. Follow-up’ which should be a number (Row number). ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/4/d4ddc441173dbb1732dc5339bda3d3420912d904.jpeg) If you require additional assistance, please don’t hesitate to reach out to us. [MSquare Support](https://calendly.com/msquarepro/meeting) Visit us [here](https://www.msquare.pro/) [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ) ---
**Author:** ![Caine\_Wai](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@Caine\_Wai](https://community.make.com/u/Caine_Wai)\ **Post date:** [February 1, 2024, 9:31pm UTC](https://community.make.com/t/cannot-update-a-row/26126/3 "2024-02-01T21:31:55Z")
What I intended was to update rows down that “Follow-up” column corresponding to the “tracking number” found. How should I map that? ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [February 2, 2024, 3:22am UTC](https://community.make.com/t/cannot-update-a-row/26126/4 "2024-02-02T03:22:09Z")
Hi @Caine_Wai If you want to update Follow-up column of the corresponding search row, Map with row number from search module in the Row number field of update module. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/c/5c84351f39b885ebf6203be60c0d4547093711b1.png) If you require additional assistance, please don’t hesitate to reach out to us. [MSquare Support](https://calendly.com/msquarepro/meeting) Visit us [here](https://www.msquare.pro/) [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ) ---
**Author:** ![Ishan](https://avatars.discourse-cdn.com/v4/letter/i/3da27b/32.png) [@Ishan](https://community.make.com/u/Ishan)\ **Post date:** [February 2, 2024, 6:11am UTC](https://community.make.com/t/cannot-update-a-row/26126/5 "2024-02-02T06:11:55Z")
Hey @Caine_Wai , Map the row number as shown in the below image ![Screenshot 2024-02-02 11.40.56](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/b/5b6a5a96f86830e07d4f37769ec4be7d7274c461.png) and other than this everything you are doing is completely fine ! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [May 2, 2024, 5:19am UTC](https://community.make.com/t/cannot-update-a-row/26126/6 "2024-05-02T05:19:03Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.