Marketing & content

When a listing's status changes to Just Listed or Sold in Airtable, a branded vertical video renders from the listing photos and details, AI writes the hook and caption, and the video posts to Instagram and TikTok with the link saved back to the listing record

An n8n template published by Orshot watches an Airtable listings table for changes to the Status field. It pulls the address, price, beds, baths, square feet, features, photos, and agent details from the record, and an OpenAI model (gpt-4o-mini) writes the hook and captions. Just Listed records go to a 9:16 listing reel template (five scenes covering status and price, stats, features, open house, and an agent card), and Sold records go to a Just Sold template. Orshot renders the MP4, publishes it to the Instagram Business and TikTok accounts connected in Orshot with a status-based caption, and the workflow writes the video URL and post time back to the Airtable record. The template notes that Save as Draft can be turned on to review each reel before it goes live.

At a glance

Tools used
n8nOrshotOpenAIAirtableInstagramTikTok
Category
Marketing & content
Audience
listing agent, team lead, marketing coordinator
Difficulty
Builder
Source
Create and post real estate listing videos with Airtable, OpenAI, and Orshot
Orshot (n8n creator) · n8n template · Oct 1, 2026
First step
Copy the listing reel and Just Sold templates into Orshot, turn on Save as Draft in the publish step, and change one past listing's status in Airtable to see the rendered reel and caption before anything posts.

Compliance note: Include your brokerage name and any license disclosures your state requires in each video and caption, get the seller's consent before posting listing photos, and only post a Just Sold price after closing if your MLS rules allow it.

Suggested prompt

Written by this directory, inspired by the source. Replace the [bracketed] parts.

Write a short hook (under 8 words) and an Instagram and TikTok caption for a [Just Listed / Just Sold] video. Use only these listing facts: [address, city, price, beds, baths, square feet, top three features, open house date and time if any, agent name and brokerage]. Name the specific features, such as 'renovated kitchen with quartz counters', not vague praise. Do not describe the neighborhood's people, schools ranking, or safety, and do not add facts that are not listed. End the caption with the brokerage name and 3 to 5 local hashtags. Return JSON with hook and caption.

Share on X Read the source

← All use cases