Generate Property Investment Reports with GPT-4, SerpAPI, Google Docs & Airtable

How It Works ⚙️

This workflow is a comprehensive, multi-AI-agent system that acts as a virtual property analysis team. It automates the entire process from initial data research to final report delivery.

1. Data Research (AI Agent 1) : The workflow is triggered by an input of a property address. The first AI agent, powered by Google Search , immediately searches the web to gather all relevant public data, including historical sales data, local rental prices, and nearby amenities.
2. Market Analysis (AI Agent 2) : All the raw data from the first agent is consolidated. A second AI agent, powered by OpenAI , then performs a deep, intelligent analysis. It identifies key insights, calculates potential rental yield, and assigns a definitive "Investment Score."
3. Report Generation (AI Agent 3) : A third AI agent, also using OpenAI , takes the structured analysis and writes a professional, persuasive report. The report is then automatically populated into a pre-designed Google Docs template, ensuring a polished and professional look.
4. Database Logging & Delivery : The final report is automatically converted to a PDF and sent to the client via Gmail . Simultaneously, the key findings (address, score, key takeaways) are logged into an Airtable database for quick reference and tracking.

How to Set Up 🛠️

1. Import the Workflow : Copy the provided workflow JSON and import it into your n8n instance.
2. Configure Credentials :
   • Google Search : Add your API Key.
   • OpenAI : Add your API Key.
   • Google Docs : Add your OAuth2 credential.
   • Airtable : Add your API Key and token.
   • Gmail : Add your OAuth2 credential.
3. Customize Workflow Nodes :
   • Node 6 ( Google Docs ) : Create a new Google Doc to serve as your report template. Use placeholders like {{ report_content }} and {{ property_address }} to define where the AI-generated text will go. Then, copy the document ID from the URL and paste it into this node's parameters.
   • Node 7 ( Airtable ) : Replace [YOUR AIRTABLE BASE ID] and Property Reports with your specific Airtable base and table names. Ensure your table has columns that match the data you are sending ( Property Address , Investment Score , etc.).
4. Save & Activate : Once all settings and credentials are configured, save the workflow and click the "Inactive" toggle in the top-right corner to make it live.