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.

 

[sonuku]

Please explain triggers and action event name . mainly I am facing the issue in google sheet . I have the google sheet in which all sharable link form google drive .

please tell me how to set google sheet and there event. how to take next sharable links for every trigger and update sheet.

 

[Preeti Paryani]

Hello @sonuku,

To set up this workflow, please follow the steps below:

1. Set up the trigger as "Schedule by Pabbly" to run the workflow at the required time.
2. Add the "Google Sheets: Get Rows" action to retrieve rows from Google Sheets in advanced format. Turn off the Simple Response option and capture the response.
3. Add an Iterator and map the array from Step 2 to process each row individually.
4. Add a Delay of 1 hour.
5. Create a Post on Facebook using the retrieved data.

This setup will help you access the shareable link from Google Sheets one at a time.

 

[sonuku]

Please check this workflow for the 15 minutes trigger. If this is right workflow tell me how can I repeat this sheet.

Pabbly

connect.pabbly.com

why we are using the delay in this , when we can schedule every hour this event .

 

[Preeti Paryani]

Hello @sonuku,

Upon reviewing your workflow, it appears to be set up correctly and should help you achieve your use case.

Since an Iterator is being used, the workflow will process each row in Google Sheets individually. To ensure smooth execution, a delay of one hour has been added between each row's processing.

 

[sonuku]

It is not functioning correctly.

• On the first trigger, it uploads one image to Facebook.
• On the second trigger, it uploads two images to Facebook.
• On the third trigger, it uploads three images to Facebook.

For example, when it triggers for the third time, it takes images from the first, second, and third rows and uploads them together.