How to Automate Facebook Image Posting from Google Sheets Using Pabbly Connect

[sonuku]

Hello,

I have uploaded 100 images to Google Drive and created a Google Sheet containing all the shareable links. I want to automate the process of posting these images one by one on Facebook every hour with the same caption.

Here are my requirements:

1. The workflow should pick one image at a time from the Google Sheet.
2. Once an image is posted, the next image should be used in the following hour.
3. No image should repeat until all images are posted.
4. After all 100 images are posted, the process should restart from the beginning.

I’m especially looking for guidance on how to properly connect Google Sheets so that it fetches the next available row without repeating.

Could anyone please guide me on how to set up this workflow in Pabbly Connect?

 

[Preeti Paryani]

Hello @sonuku,

You can refer to this tutorial for step-by-step guidance on achieving your use case. You can just add an addition step named delay just after the iterator for delaying the posts by an hour.