Google Sheets Rows & Repitition

Hi :waving_hand:,

I am automating my social media.

I have built the data for my Facebook posts in a Google Sheet.

I would like to run a new row of my Google Sheet each time the scenario is run. Then repeat the list when I run out of rows.

How can I get this up in my scenario?

Thanks
AK

1 Like

Hey @Heritage_Mobility :waving_hand:

Here’s a simple way you can manage this Problem:

  1. Add a “Status” column to your sheet

    • This will help track which posts have already gone out.
  2. Search only the unposted rows

    • Use the Search Rows module at the beginning of your scenario.
    • Add a filter so it only pulls rows where the Status column is empty.
  3. Post the content

    • Use the data from that row (like text or image link) to publish your Facebook post.
  4. Update the status after posting

    • Once the post goes live, use the Update Row module to mark that row as “Posted”.
  5. Add a router to manage the full cycle

    • Add a condition that checks if the total number of rows equals the number of “Posted” rows.
    • If yes, reset the sheet by clearing the Status column — so it can loop through the posts again.

Best regards,
Digipanda Consulting Pvt. Ltd
@digiPanda_Automation

Welcome to the Make community!

For more information, also see these discussions on similar threads:

You can search this forum for existing answers, and also use the documentation in the Help Centre to get to a solution faster, and also help keep the forum organised. Thanks for your cooperation!

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

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!