Google sheet to Facebook post with condition status

[tisaigon]

Hi,
My desired flow is:
In Google Sheet, check column "Approved Status" = OK, will post facebook schedule
After Posted, copy this row to other sheet and set column "Post Status" = Posted and get Post ID/Post link (if any)
How can i do it?
Thank you

 

[Pabblymember11]

Hey @tisaigon

It appears for your use case it might require at least 2 trigger columns to satisfy your 3 conditions and from Google sheets, you can only trigger one workflow at a time.

So, I am afraid to say that your use case is not possible.

 

[tisaigon]

@Supreme thank you for your reply.
How can i do first condition:
In Google Sheet, check column "Approved Status" = OK, will post facebook schedule, if "Approved Status" != OK, do not post. Thank you

 

[Pabblymember11]

Hey @tisaigon

The situation which you are trying to achieve in the automation is currently not possible. Since the workflow will not cancel the scheduled task in future executions.

 

[tisaigon]

@Supreme understand.
Currently, I have the phenomenon of creating many duplicate posts.
I think that is probably the reason why 1 line in Google Sheet after posting facebook is still left in that sheet, so it is posted again.
Please advise me an effective solution to not be like that again
Thank you

 

[Pabblymember11]

Hey @tisaigon

Can you please tell us at what interval you will be approving or making any changes in the "Approved Status" column?

Also do share your Google Sheets with us, so that we can check the possibility of it.

 

[tisaigon]

Thanks @Supreme
We use Google Sheet All Time, but most 8hAM to 22hPM GMT+7.
My google sheet

Facebook post; facebook fanpage, facebook group, facebook content

New No,Approved Status,Post Status,Time,Channel ID,Type,Content,Image Link,Podio Link 1,OK,Posted,test test test,<a href="https://i.imgur.com/oBX2ur7.jpg">https://i.imgur.com/oBX2ur7.jpg</a> 2,Content content,<a href="https://i.imgur.com/ZE8HMqh.png">https://i.imgur.com/ZE8HMqh.png</a> 3

docs.google.com

If any, after one post/row posted to facebook, this Status changed to "Posted"
I hope I don't have duplicate posts on fb anymore
Please help
thanks.

 

[Pabblymember11]

Hey @tisaigon

I am afraid to say that in your use case is not possible to double-trigger the same column from Google Sheets.

 

[tisaigon]

Thanks @Supreme . How can other guys avoid duplication Post to facebook? manual delete rows in sheet or ? Thanks

 

[tisaigon]

@Supreme can i get data after Posted, eg: posted link...Thanks

 

[Pabblymember11]

Hey @tisaigon

You can start storing the post on Facebook first to validate the post later whether it is published or not.

Add the following action step before the Facebook action step to pass the content by validating it first with the help of the Lookup action step.

 

[Pabblymember11]

Hey @tisaigon

You can start storing the post on Facebook first to validate the post later whether it is published or not.

View attachment 21943

Add the following action step before the Facebook action step to pass the content by validating it first with the help of the Lookup action step.

View attachment 21944