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
Run cell A2 after completion run A3 and so on…
How can I do that?
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.
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