Finishing a Make/Airtable to Social Media Sequence

I am new to Make/Airtable Automation. I am stuck on setting up a workflow that deposits a video, accompanied by meta data (Title, description, hashtags and links) onto four social media accounts (Yt, Fb, Ig, and Bluesky). It’s felt like chasing squirrels around the yard getting this sequence to work. Looking for help to not only fix what I’ve started but show me how to do it (Probably a short video capture). See the screen capture.

Here’s is the step-by-step:

  1. New Content is Ready to Publish!" (Airtable Start):
  • The scenario constantly watches your Airtable “Publishing” table.
  • When you mark a record as “Go Pub” (ready to publish), the scenario kicks into action.
  1. Get All the Details" (Airtable Data Fetch):
  • Once it finds a “Go Pub” record, it grabs all the important details related to that content from Airtable. This includes things like the video’s Title, Meta description, and Link.
  1. Get the Video File" (Google Drive Download):
  • It then goes to your Google Drive and downloads the actual video file that’s linked to that Airtable record.
  1. Organize the Information" (Set Multiple Variables):
  • This is Module [25]. Its job is to take all the pieces of information it just gathered (the video file, title, meta, link, etc.) and put them into neatly labeled “boxes” (variables) so they are easy to find and use later. Think of it as putting the video file into a “videoFileContent” box, the title into a “title” box, and so on.
  1. Send it Out!" (Router and Social Media Posting):
  • The scenario then uses a “Router” to send the content to different social media platforms.
  • For Facebook: It takes the video file and the information from the “boxes” (title, meta, link) and uses them to create a video post on your Facebook Page.
  • For Instagram, Bluesky, YouTube: It does the same thing, sending the video and relevant details to each platform for posting.
  1. Mark as Done" (Airtable Update):
  • Finally, after attempting to post to each platform, the scenario updates the original record in Airtable, marking that the content has been processed for publishing.

In essence, the entire sequence is an automated pipeline: Airtable (Trigger) → Get Content Details → Get Video File → Organize All Data → Distribute to Social Media → Update Airtable (Completion).

Hello @kaos_theory, welcome to the make Hire a pro section , I would love to work with you on this, you can book a call Here to discuss the project requirements and you can checkout my upwork profile Here

Hi @kaos_theory ! I would love to help you with your scenario.

We are a small team of make.com experts and have developed plenty of complex integrations. This project should not be a challenge to us.

If you are interested we would love to help you, you can schedule a call in here: 30 Min Meeting | Felipe Saucedo | Cal.com or check our website www.aspirity.com

Hey @kaos_theory,

In order to solve bugs in make scenarios (and in any automation process) you have to investigate the error message you get in response to the failed module. Based on this you have to do an update on the settings of the module while sometime we may have to add some steps before the final module.

The most usual reason of failure is on video size and text size where there are some limitations from API. So, please open the red button of that shows the bug reason.

I do co-building sessions where we work live on your workflow together. In this way you get the solution done before the end of the call while you are learning how your system works, and how you can make improvements by your self.

Happy to schedule a 30-min conversation with no commitment and try to solve you challenges live on this call. Here is my calendar link: https://cal.com/dimitrisgoudis/meet-dimitris

Thanks
Yours sincerely,
Dimitris Goudis | 3Nuggets.io

Hi @kaos_theory,

Good to see you on the Make community!

I hope you’re still looking for someone with over two years of hands-on experience, a master’s degree in automation, and Make.com certification, then here I am to get things sorted out.

I’ve resolved similar problems before and can ensure your Make.com to Airtable social media sequence runs smoothly.

Feel free to check my services, connect on LinkedIn or book a quick call to get started.

Looking forward to hear from you soon.

I had written and created video with clickup. This must be helpful. Look here: Social Media posting directly from CRM with Content Calendar

Princy Jain
Make consultant,
For consulting support: Follow up Automated