n8n Workflow: Monitor LinkedIn Posts & Create AI Content Digests with OpenAI and Airtable

This n8n workflow automates the process of fetching LinkedIn posts, analyzing them with OpenAI to generate content digests, and storing these digests in Airtable. It's designed to help you keep track of important content, summarize key information, and maintain a structured record of insights.

What it does

This workflow performs the following steps:

1. Triggers on a Schedule: The workflow runs automatically at predefined intervals (e.g., daily, weekly) to check for new LinkedIn posts.
2. Fetches LinkedIn Posts: It makes an HTTP request to a specified LinkedIn API endpoint to retrieve recent posts.
3. Processes Posts in Batches: Each fetched LinkedIn post is processed individually to manage API rate limits and ensure robust processing.
4. Extracts Relevant Data: For each post, it extracts specific fields and prepares them for AI analysis.
5. Generates AI Content Digest:
   • It uses an OpenAI Chat Model (via LangChain) to analyze the content of each LinkedIn post.
   • A "Basic LLM Chain" is employed to structure the interaction with the AI model.
   • A "Structured Output Parser" ensures the AI's response is formatted into a usable JSON structure (e.g., summarizing the post, extracting key topics, sentiment).
6. Stores Digest in Airtable: The AI-generated content digest for each LinkedIn post is then saved as a new record in a designated Airtable base.
7. Handles Errors/No New Posts: If no new posts are found or an error occurs during processing, the workflow gracefully handles these scenarios without halting.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Airtable Account: With a base and table configured to store the content digests (e.g., columns for "Post Title", "Summary", "Key Topics", "Sentiment").
• OpenAI API Key: For accessing the OpenAI Chat Model.
• LinkedIn API Access: An API endpoint and credentials to fetch LinkedIn posts. This workflow uses a generic HTTP Request node, so you'll need to configure it with your specific LinkedIn API details.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Airtable: Set up your Airtable credential with your API key and base ID.
   • OpenAI: Configure your OpenAI credential with your API key.
3. Configure Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency (e.g., every day, once a week).
   • HTTP Request (for LinkedIn): Update the URL, headers (for authentication), and any query parameters to correctly fetch posts from the LinkedIn API.
   • Edit Fields (Set): Review and adjust the fields being set if your LinkedIn API response structure differs, or if you want to extract different data points.
   • Basic LLM Chain & Structured Output Parser: Review the prompts and expected output structure to ensure the AI generates the desired digest format.
   • Airtable: Configure the "Base ID", "Table Name or ID", and map the fields from the AI output to your Airtable columns.
4. Activate the Workflow: Once configured, activate the workflow to start monitoring and generating content digests.