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.
Get 50 AI Prompts for Real Estate Agents, free
Subscribe to the Daily 5 and download the 48-page PDF right away. The prompts help with:
- Getting more leads from the contacts already in your CRM
- Faster follow-up, so no text or inquiry goes unanswered
- Less time on listing descriptions, paperwork, and showing instructions
- Copy-paste prompts tested by working agents, brokers, and landlords
- Five new real-world AI use cases every weekday morning in the Daily 5
Confirm by email. Unsubscribe in one click. Review every AI draft for accuracy and fair housing compliance before you send it.