Fill in a Google Form for a new listing and get Instagram, Facebook, LinkedIn, and X posts written for the listing's buyer profile, emailed to you and logged in Google Sheets
An n8n template by Hassan turns a new listing into social posts for four platforms. The agent fills in a Google Form with the address, price, bedrooms, bathrooms, property type, key features, target buyer profile, and anything else to highlight. A Google Sheets trigger picks up the form response, and Google Gemini writes four platform-specific posts in one call: an Instagram caption with 20 to 25 hashtags, a Facebook post that ends with an engagement question, a LinkedIn post written as professional market commentary, and an X post under 240 characters, plus a suggested image caption. The template adjusts tone to the buyer profile the agent picked (data-driven for investors, sophisticated for luxury, encouraging for first-time buyers). All four posts arrive in one formatted Gmail email, every post set is logged to Google Sheets as an archive, and posting straight to a Facebook Page and Instagram Business account through the Meta Graph API is optional and off until the agent adds Meta credentials.
At a glance
- Tools used
- n8nGoogle GeminiGoogle FormsGoogle SheetsGmailMeta Graph API
- Category
- Marketing & content
- Audience
- agent, listing coordinator
- Difficulty
- Light tech setup
- Source
- Generate real estate listing social posts with Google Gemini and Gmail
Hassan (n8n creator) · n8n template · Sep 12, 2026 - First step
- Create a Google Form with the listing fields, point the n8n Google Sheets trigger at the sheet that collects the form responses, connect Gmail and a Gemini API key, set AGENT_NAME and AGENT_EMAIL in the configuration step, and submit one real listing to review the four posts before turning on Meta posting.
Compliance note: Targeting posts by buyer profile can drift into fair housing steering, so describe the property rather than the buyer, review every post before it goes out, include your brokerage name and license details where your state's advertising rules require them, and get the seller's permission before posting the listing.
Suggested prompt
Written by this directory, inspired by the source. Replace the [bracketed] parts.
Write four social posts for this listing using only the facts below: an Instagram caption (under 150 words, then 20 hashtags about the property type, city, and neighbourhood), a Facebook post that ends with one question about the home, a LinkedIn post of three short paragraphs that connects the listing to one local market fact I provide, and an X post under 240 characters with the price and the address. Describe the property and its features, never the kind of person who should buy it, and do not use words like 'perfect for families', 'ideal for young professionals', or 'exclusive'. Listing facts: [paste]. Local market fact: [paste]
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.