scheduled weekly GBP or FB post from gsheet approved/disapproved column once per week, if disapproved move to next until reach approved and post.

[Joz]

Hello, I'm trying to get the workflow to post a weekly approved social media post from google sheet. Currently it keeps repeating the same approved post. How do I get it to advance rows one by one... AND if a row is disapproved... how do I get it to move forward until it hits an approved row, only publish that row until the following week?

please see the video for clarity. thank you for your help!

workflow is currently...

the filter is for approved or disapproved.
not shown is the next step which is the posting step.

Google Business Profile Posting Workflow Automation troubleshooting

I'm sharing a video about automating my Google Business Profile workflow. I need a system that processes only approved rows, moving to the next if it hits a disapproved one, progressing one row at a time. The key is to ensure it operates weekly, publishing only approved posts each week.

www.loom.com

 

[ArshilAhmad]

Hi @Joz,

You can try setting up your workflow in this manner to achieve your use case.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

Note: You need to be willing to change the status of your post from 'Approved' to something else once it's posted. If not, then the use case you are trying to achieve is not possible. The 'Update Cell Value' step will be used to change the status from 'Approved' to something else.

For example: In Week 1, Row 3 will be posted, and once it's posted, its status will be changed to something else, so that it isn't recognized in the lookup for the next week.

 

[Joz]

that makes sense... it's a very good idea thank you!
Thank you so much... it works perfect now!