Google Sheets doubts

I am created a flow that researched the keyword, generated a post and insert into website.

But right now I am running 1 keyword(row) each time. As I need to erase the keyword from cell A2 and insert new one.

What I am trying to accomplish is:

I want to run the automation/flow 10 times without repeat the cell/row

Example:
Run cell A2 after completion run A3 and so on…

How can I do that?

image

Hello,

You can try Watch Changes module in Google Sheets, it is designed to track changes made to sheet.

Hope this points you in the right direction, thanks.

2 Likes

Hi @Beginner and welcome to the Make forum!

You could add a repeater at the start followed by a Get a Cell module.

The repeater will give you your row number. Set the initial value to “2” as you have a column header (“Keyword”):

In the Get Cell module, use the i value to get the row

Then carry on with your scenario.

Hope that helps :slight_smile:

3 Likes