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.

 

[Luv]

Hello @sonuku

Kindly share the screenshots from your Facebook posts so that we can check further.

Looking forward to your positive response.

 

[sonuku]

what you will get to know in Facebook screenshot .?

Check my workflow

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @sonuku,

As per the workflow task history, it appears that the posts are being created using a single URL. Could you please share the post URL that was created with multiple URLs due to the workflow? This will help us investigate the issue further.

 

[sonuku]

See the task history , see the timing all task executing on the same time .

see the all images repeating , I cannot share the link. these pages are blocked in India

.

 

[Preeti Paryani]

Hello @sonuku,

Would you be available for a Google Meet so we can assist you more effectively? Please let us know a convenient time slot between Monday and Friday, either between 11:00 AM - 1:00 PM IST or 4:00 PM - 5:00 PM IST.

 

[sonuku]

04-04-2025 11:00am

 

[Preeti Paryani]

We have provided you with the meet link in the following thread - https://forum.pabbly.com/threads/pabbly-connect-workflow-stops-and-doesnt-comment-on-facebook.27941.

 

[sonuku]

As we discussed in meeting with you I have made the workflow according to you , it worked fine for a day , now It is taking 4 hours sometime 2 hours between the posting time on Facebook page. it also missing the post from google sheet.

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @sonuku,

Thank you for reaching out.

As per the task history, the delay between the posts appears to be around one hour. However, to further investigate and determine if the delay is exceeding the expected time, could you please share the following:

• Any unique identifiers (such as post IDs or timestamps) that we can use to verify the delay
• Screenshots showing the delay
• File URLs or any relevant logs that can help us review the issue more effectively

Once we have this information, we’ll be able to look into the matter in more detail and assist you further.

 

[sonuku]

Facebook page workflow : https://connect.pabbly.com/workflow...YU2sIHAcDAFZRIgYfACxdXl0nAE1RKgNgADNdAwAoUzI#

Facebook page post Link between gap:

https://www.facebook.com/photo/?fbid=690115560068230&set=pb.100072093765482.-2207520000

between gap 4 hours

Log into Facebook

Log into Facebook to start sharing and connecting with your friends, family, and people you know.

www.facebook.com

between gap 4 hours

Log into Facebook

Log into Facebook to start sharing and connecting with your friends, family, and people you know.

www.facebook.com

after this workflow works fine post hourly.


I have set this workflow with 3 pages and with same google sheet. when these images which is shown in link post every pages has 4 hours gap posting , after this it works fine . I means In this gap these are some images in google sheet what they are not being posted . I have checked all these images which is missing to post , they are public and have checked in incognito mode also.

 

[Preeti Paryani]

Hello @sonuku,

It appears that the workflow is not set up as per the suggested configuration. To assist you more effectively, could you please share the workflow URL that is designated for posting content on your Facebook page titled "Law of Attraction"?

Once I have the correct URL, I’ll be able to review the setup and guide you accordingly.

Facebook page workflow : https://connect.pabbly.com/workflow...YU2sIHAcDAFZRIgYfACxdXl0nAE1RKgNgADNdAwAoUzI#

Current Workflow setup :

Suggested workflow:

 

[sonuku]

By mistake I sent you wrong workflow , I have set up already workflow what you have suggested.

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @sonuku,

Please refer to the attached video for a detailed explanation regarding the missing posts.

google_screen_recording_2025-04-07T10-33_44.142Z.webm

drive.google.com