A zero-cost, self-hostable stack to automate social media using visual workflows and AI.
Track social media performance and website analytics to inform content decisions.
Analyze performance data and generate optimized Instagram captions and content ideas.
Design Instagram graphics and carousels.
Connect Metabase, ChatGPT, and Instagram to automate the posting schedule.
n8n has native Advanced AI nodes specifically designed to route data to OpenAI's API for decision making.
n8n can trigger workflows based on Metabase alerts or pull data via HTTP requests to feed into ChatGPT.
This stack leverages open-source and free-tier tools to meet your self-hosted preference and startup budget. n8n acts as the central visual automation engine, pulling data from Metabase, using ChatGPT to make content decisions, and orchestrating Instagram posts using Canva-generated assets.