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:
- 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.
- 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.
- 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.
- 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.
- 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.
- 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).