Hi
,
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 
Here’s a simple way you can manage this Problem:
-
Add a “Status” column to your sheet
- This will help track which posts have already gone out.
-
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.
-
Post the content
- Use the data from that row (like text or image link) to publish your Facebook post.
-
Update the status after posting
- Once the post goes live, use the Update Row module to mark that row as “Posted”.
-
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!