Generate real estate listing social posts with Google Gemini and Gmail

by Hassan ✓ · 23 views · created 2026-09-12 · Social Media, Multimodal AI

What this workflow does

This AI workflow has 14 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, Google Gemini, Gmail and Facebook Graph API.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. Extract Listing Details (Code): runs custom JavaScript code
2. Configuration (Edit Fields (Set)): sets 7 fields: AGENT_NAME, AGENT_EMAIL, POST_TO_FACEBOOK…
3. Generate Social Posts (Google Gemini): uses Google Gemini
4. Parse AI Output (Code): runs custom JavaScript code
5. Send Posts to Agent (Gmail): uses Gmail
6. Log to Post History (Google Sheets): append
7. Post to Facebook? (If): checks a condition and branches into true / false
8. Post to Facebook Page (Facebook Graph API): uses Facebook Graph API
9. Post to Instagram? (If): checks a condition and branches into true / false
10. Update Sheets Facebook Posted Flag (Google Sheets): update

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsGoogle GeminiGmailFacebook Graph API

Before you upgrade to n8n 3.0

Nodes used (10)

• Webhookn8n-nodes-base.webhook
• Google Sheets Triggern8n-nodes-base.googleSheetsTrigger
• Coden8n-nodes-base.code
• Edit Fields (Set)n8n-nodes-base.set
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Gmailn8n-nodes-base.gmail
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Facebook Graph APIn8n-nodes-base.facebookGraphApi
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview Turn every new listing into four ready-to-post social media captions in 30 seconds. Fill in a Google Form with your listing details, and Gemini AI generates platform-specific posts for Instagram, Facebook, LinkedIn, and X — each tailored to…

View the original on n8n.io → Check your own copy