facebook post based on categorical columns in google sheet

[tisaigon]

Hi,
Can i create Post more automatically from Google Sheet To Facebook?
Eg:
i have 3 columns (See screenshot)
Media type = Image or Video

Channel ID​

FB Type = Group/Facebook​

​

How can i set workflow :

A/ If channel id = 12345 Post to Facebook A, if channel id = 54321 Post to Facebook B
B/ If Media type = Image , use "Create Image Post" . If Media type = "Video" , use "Create Video Post"
C/ If FB type = Group => Create Post to Group. If Fb type = Fanpage => Create Post to Fanpage

Thank you so much

 

[Pabblymember11]

Hey @tisaigon

Can you please tell us the workflow where you have tried the same so that we can look into it?

 

[tisaigon]

@Supreme I want to select facebook page/group based on "ChannelID" of Google sheet.
My flow:

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

My google sheet:

Facebook post; facebook fanpage, facebook group, facebook content

New No,Posted Status,Post ID,Content,Media Link,Channel ID,Posted Time,Thời điểm tạo từ Podio Qua Google Sheet,Approved Status,Scheduled time,Page or Group,Channel Name,Media Type,FROM Podio Link,Podio Item ID Posted,111260241415031_254532903777039,ab de test test 4555 y666 666 test 333 trai tim...

docs.google.com

 

[Pabblymember11]

Hey @tisaigon

You can use the Lookup Table action step to manage to select the Channel Id of the Facebook Page/Group.

And to post the media file according to the file type you can use the Router action step.

 

[tisaigon]

@Supreme thank you. How can i delete row eg "Facebook status" = "DONE", after a content in this row posted? Or set delete this Google Sheet one time per week? But same workFlow because use same webbook.

 

[Pabblymember11]

You can refer to the following thread for help deleting the rows from your Google Sheets if necessary.

Please give it a try and let us know if it works for you.

Copy Paste value if condition is true in Google Sheet

Hi, So I have 3 columns, ABC. I want the row values of A & B to be copied to another sheet and added to an already existing range of data, if the value in C is True. Not able to figure out how to do this effectively. Any help appreciated. Regards, Sourav

forum.pabbly.com