facebook post based on categorical columns in google sheet
Status: Closed · Asked by ti saigon on · 0 views
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
Attachments
Hey @tisaigon
Can you please tell us the workflow where you have tried the same so that we can look into it?
@Supreme I want to select facebook page/group based on "ChannelID" of Google sheet.
My flow:
https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZkMDYzMjA0MzY1MjZkNTUzMSI_3D_pc
My google sheet:
https://docs.google.com/spreadsheets/d/1cbPDPQC7XqGcj5FRqd_epTKdNQS3JX0RuqwrB3nn_f0/edit#gid=0
Hey @tisaigon
You can use the Lookup Table action step to manage to select the Channel Id of the Facebook Page/Group.
youtube.com/watch?v=0umsoycOlfo
And to post the media file according to the file type you can use the Router action step.
@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.
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.