OpenAI + n8n Social Media Automation VPS Setup Connecting accounts - making posts

Setup Fully Automated AI Social Media Marketing System (n8n + OpenAI + MySQL + Facebook + Instagram) Description: I own a real estate portal and am looking for an experienced automation specialist to build and deploy a fully automated AI-powered social media posting system on my VPS. The goal is for the system to automatically pull new property listings from my MySQL database, generate social media content using AI, and publish posts to Facebook and Instagram without manual intervention. Current Setup - Linux VPS server - MySQL database containing property listings - Facebook Business Page - Instagram Business Account - OpenAI API key available (or can be created) Scope of Work 1. Install & Configure n8n - Install n8n on my VPS - Configure secure access - Ensure workflows survive server reboots - Document login details and setup 2. Connect MySQL Database Create connection to existing MySQL database. The workflow should retrieve: - Property title - Price - Location - Bedrooms - Description - Images - Property URL 3. OpenAI Integration Use OpenAI API to automatically generate: - Facebook posts - Instagram captions - Relevant hashtags - Calls to action Requirements: - Human-like writing - No duplicate content - Optimized for engagement and click-throughs - Real estate focused 4. Facebook Automation Automatically: - Publish property posts - Include image(s) - Include generated captions - Include property link 5. Instagram Automation Automatically: - Publish property images - Generate captions - Add hashtags - Include property link where possible 6. Workflow Logic System should: - Run on a schedule (e.g. every 2 hours) - Avoid posting duplicate listings - Mark listings as posted - Include error handling and logging Nice To Have - Pinterest integration - Threads integration - TikTok automation - LinkedIn automation - AI property scoring (only posting best listings) - Weekly performance reporting - AI-generated property reels/videos Deliverables - Fully working system deployed on VPS - All workflows tested - Documentation provided - Short video walkthrough explaining how everything works - Ability for me to modify prompts later Required Experience Please apply only if you have experience with: - n8n - OpenAI API - MySQL - Meta/Facebook API - Instagram API - Automation workflows When applying, please provide: 1. Examples of similar projects 2. Estimated timeline 3. Whether you recommend n8n, Make.com, or another solution Potential for ongoing work: Yes. I plan to expand this into Pinterest, Threads, TikTok, LinkedIn, lead generation, and additional AI automations in the future.