Create and post real estate listing videos to Facebook, Instagram, and TikTok with Airtable, OpenAI, and Orshot

Description

Quick overview This workflow watches listing status changes in Airtable, renders a branded vertical real estate video in Orshot from the listing and agent details, publishes the MP4 to Instagram and TikTok, and writes the video URL and post time back to the Airtable record. How it works Triggers when the Airtable “Status Updated” field changes for a listing record. Extracts and formats listing details, features, photos, and agent information from the Airtable record to match the Orshot template fields. Routes the record based on the listing Status, sending “Just Listed” to a listing reel render and “Sold” to a just-sold render. Calls Orshot to render the selected studio template and waits for the MP4 output URL. Publishes the rendered video to the selected Instagram and TikTok accounts in Orshot with a status-based caption. Updates the original Airtable record with the published video URL and the post time. Setup Create Airtable personal access token credentials in n8n, then select your base and table in the Airtable trigger and update steps. In Airtable, add a “Status Updated” Last modified time field that watches the Status field, and add “Video URL” and “Posted At” fields to store outputs. Add Orshot credentials in n8n, copy the listing reel template and the Just Sold template into your Orshot workspace, and pick each one in its Orshot render step. Connect your Instagram Business and TikTok accounts in Orshot under Social accounts, then pick them in the publish step. Ensure your Airtable field names (Address, City, Price, Beds, Baths, Square Feet, Acres, Features, Photos, and agent fields) match the mappings used in the workflow or update the field references accordingly. Requirements Orshot account on a plan with video renders and social publishing Airtable base with one record per listing, including a Photos attachment field Instagram Business and TikTok accounts connected in Orshot Customization Add Switch outputs for Open House or Price Improved videos Swap the Airtable trigger for Google Sheets if your listings live in a sheet Turn on Save as Draft in the publish step to review each reel before it goes live Additional info Full walkthrough with a live preview of the template: Real estate listing videos with Orshot. An n8n automation workflow template by Orshot.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• airtable
• gmail
• code
• openai

Capabilities

• 4 nodes

Information