# Get Cell Module not retrieving specific cell **URL:** \ **Category:** Questions\ **Tags:** error, google-sheets, functions\ **Created:** [April 10, 2025, 1:05am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178 "2025-04-10T01:05:58Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Ed\_Henderson](https://avatars.discourse-cdn.com/v4/letter/e/a88e57/32.png) [@Ed\_Henderson](https://community.make.com/u/Ed_Henderson)\ **Post date:** [April 10, 2025, 1:05am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/1 "2025-04-10T01:05:58Z")
Hello Makers, I’m attempting to pull a title from a Google spread sheet each time my repeater triggers. I’m using the iterator from the Repeater but it’s crashing-out every time. I want the Google Sheets Module Action to retrievee values from cells `A1`, `A2`, `A3`, etc., one at a time during each iteration. 1. I start the repeater. 2. I using the number to select my video. 3. I use the same number to specify what cell I want. 4. I Run-Once the GSM to see what output the cell generates (I’m thinking it will be A and the number) 5. I get an error. Here’s my full flow: ![Screenshot 2025-04-09 at 9.05.17 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/8/f890dd2591f955c75c7b821676ed53dc3216f25c.png) Ideally I’d like to get multiple cells from the sheet, but just trying to get one to work. I tried using the GSM (Watch Rows) at the beginning of the flow, but that keep pulling just the first record. Your help is GREATLY appreciated. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [April 10, 2025, 1:49am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/2 "2025-04-10T01:49:04Z")
The `{{ }}` around your `i` variable isn’t valid. Remove it. Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![Ed\_Henderson](https://avatars.discourse-cdn.com/v4/letter/e/a88e57/32.png) [@Ed\_Henderson](https://community.make.com/u/Ed_Henderson)\ **Post date:** [April 10, 2025, 1:53am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/3 "2025-04-10T01:53:39Z")
Like this? ![Screenshot 2025-04-09 at 9.52.20 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/f/bf14560d5e9c3dc627c8c4a771c0798ec7ff043f.jpeg) Still kicking out errors ![Screenshot 2025-04-09 at 9.52.39 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/4/345f0cf5f7b1992175cedc5ba7839048aaa69e07.png) Thoughts? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [April 10, 2025, 2:03am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/4 "2025-04-10T02:03:33Z")
> [@Ed\_Henderson](#): > > I want the Google Sheets Module Action to retrievee values from cells `A1`, `A2`, `A3`, etc., one at a time during each iteration. Instead of using a Repeater module, you can also just use the Google Sheets “ **Search Rows** ” module together with an **Iterator** — > Returns results matching the given criteria. For more information, see [https://www.make.com/en/integrations/google-sheets](https://www.make.com/en/integrations/google-sheets), and [https://www.make.com/en/help/app/google-sheets](https://www.make.com/en/help/app/google-sheets) in the help centre. ![Screenshot_2025-04-10_100456](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/e/fe783d9d61f9f7237a71e6c82e1455c11848f931.png) This way you can just map the value of the Iterator. ![Screenshot_2025-04-10_100443](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/e/7e5ac5761dad2d8473ae2fd5a60e03c8d2c5c216.png) Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![Ed\_Henderson](https://avatars.discourse-cdn.com/v4/letter/e/a88e57/32.png) [@Ed\_Henderson](https://community.make.com/u/Ed_Henderson)\ **Post date:** [April 10, 2025, 10:49pm UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/5 "2025-04-10T22:49:51Z")
I’ll give this a shot ---
**Author:** ![Ed\_Henderson](https://avatars.discourse-cdn.com/v4/letter/e/a88e57/32.png) [@Ed\_Henderson](https://community.make.com/u/Ed_Henderson)\ **Post date:** [April 11, 2025, 12:43am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/6 "2025-04-11T00:43:15Z")
Ok. Making some headway. Thank you for your support. Head row should be an entry into the array. ![Screenshot 2025-04-10 at 8.26.40 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2ba0ccebbe7bf48d5f591cc44fc368f7d23639fa.png) This is what I have set in the iterator ![Screenshot 2025-04-10 at 8.28.04 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/d/ad6809f554ac9864962a3bd60c3049ae185e5916.jpeg) When i run it, it’s adding each cell, and not a whole row to the bundle. ![Screenshot 2025-04-10 at 8.29.05 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/2/920c38932cd3bdf41f77309a02eb628a2a81817c.jpeg) I’m using the iterator bundle number to increment my video names. Thats working but it starts back at 1 after 4. (see operation 5) ![Screenshot 2025-04-10 at 8.40.01 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/4/b44ecbc0d7b32ec9cb9b7f92dba983aa4b9dc824.jpeg) ![Screenshot 2025-04-10 at 8.30.19 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/3/634541f9e8b029086a46c2f50d4b6b95eec8fe9b.jpeg) Which then screws up the YT. Adding the wrong title number and description ![Screenshot 2025-04-10 at 8.31.27 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/0/f0b1f9d4b712c0175f4603b904911049144a9693.jpeg) ![Screenshot 2025-04-10 at 8.30.52 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/7/075e4e3709c3a52f88ecddaf929a5d0ba9088c87.jpeg) I hope I explained what’s happening correctly ---
**Author:** ![Ed\_Henderson](https://avatars.discourse-cdn.com/v4/letter/e/a88e57/32.png) [@Ed\_Henderson](https://community.make.com/u/Ed_Henderson)\ **Post date:** [April 11, 2025, 1:47am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/7 "2025-04-11T01:47:32Z")
Hey, I got it to work using a simpler method. Works like a charm. Using Watch rows running every min to schedule my posts from my spreadsheet. Thanks for your help. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [April 11, 2025, 5:21am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/8 "2025-04-11T05:21:37Z")
No problem, glad I could help! 1. If anyone has a new question in the future, please **start a new thread**. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely. 2. The [Make Community guidelines](https://community.make.com/t/make-community-the-ultimate-topic/11682) encourages users to try to **mark helpful replies as solutions** to help keep the Community organized. This marks the topic as solved, so that: - others can _save time_ when catching up with the latest activity here, and - allows others to _quickly jump to the solution_ if they come across the same problem To do this, simply **click the checkbox** at the bottom of the post that answers your question: ![Screenshot_2023-10-04_161049](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png) 3. Don’t forget to like and **bookmark** this topic so you can get back to it easily in future! Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### Getting Started - [Help Centre](https://www.make.com/en/help) | [Tutorials](https://help.make.com/create-your-first-scenario) – Make “Manual” - search for help here first - [Make Academy](https://academy.make.com) – Basics 101: Learn Make properly to get your money’s worth ### Help Centre Basics - [Mapping](https://help.make.com/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://help.make.com/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://help.make.com/flow-control#VhcUm) - **Date Format** : [tokens for `parseDate`](https://help.make.com/tokens-for-datetime-parsing) | [tokens for `formatDate`](https://help.make.com/tokens-for-datetime-formatting) - [HTTP modules](https://apps.make.com/http) – Make a request, Get (download) a file - [Webhooks](https://help.make.com/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [Text Parser module](https://help.make.com/text-parser) - Use pattern matching to extract the text you want - [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**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:** [April 25, 2025, 2:01am UTC](https://community.make.com/t/get-cell-module-not-retrieving-specific-cell/78178/9 "2025-04-25T02:01:41Z")