AI Social Media Caption Creator: Automate Content Generation from Airtable

How it works

This n8n workflow automates social media caption generation. It starts by fetching data from an Airtable base ('Redaktionsplan 2025 - E&P Reisen', table 'Redaktionsplanung') using the Get Airtable Record Data node. This data, specifically the Briefing field, is then fed into an AI Agent (powered by Langchain and OpenAI's GPT-4o model). The AI agent is prompted to act as an expert caption creator, using a detailed system message that guides it to analyze the briefing, retrieve background information about the target audience (if available via a tool, though not explicitly shown in the provided snippet), and generate a creative, audience-oriented, and memorable caption with a clear Call-to-Action (CTA). The generated caption is then formatted using the Format Fields node into a SoMe Text field. Finally, the Post Caption into Airtable Record node updates a different Airtable table ('Redaktionsplanung') with the generated caption in the SoMe_Text_KI field, linked to the original record by its ID. A Wait 1 Minute node is included, possibly for rate limiting or to ensure data propagation, though its placement before data fetching suggests a potential workflow optimization opportunity.