Get Cell Module not retrieving specific cell

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:

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.

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 will save you lots of time and frustration using Make.

Like this?

Still kicking out errors

Thoughts?

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, and https://www.make.com/en/help/app/google-sheets in the help centre.

This way you can just map the value of the Iterator.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

I’ll give this a shot

Ok. Making some headway. Thank you for your support.

Head row should be an entry into the array.

This is what I have set in the iterator

When i run it, it’s adding each cell, and not a whole row to the bundle.

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)


Which then screws up the YT. Adding the wrong title number and description


I hope I explained what’s happening correctly

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.

2 Likes

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 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

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 Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.