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?

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