AI Tweet Generation & Archiving Agent (OpenAI & Airtable)

Unlock Effortless Tweet Creation with this AI Agent

This AI Agent automates the generation of short, engaging tweets. It starts by randomly selecting a hashtag from a list you define. Then, it uses OpenAI's language models to craft a tweet (under 100 characters) incorporating that hashtag. Finally, the generated tweet and its corresponding hashtag are automatically saved to an Airtable base, creating an organized backlog for your social media content calendar. It's perfect for solopreneurs, marketers, and founders looking to streamline their content creation process and maintain a consistent online presence with minimal manual input.

Key Features & Benefits

• AI-Powered Content Generation: Leverages OpenAI (specifically text-davinci-001 as configured, adaptable to newer models) to create relevant and concise tweet copy.
• Dynamic Hashtag Selection: Randomly picks from a customizable list of hashtags, ensuring variety in your generated content.
• Automated Archiving to Airtable: Seamlessly saves each generated tweet and its hashtag to your specified Airtable base for easy tracking, review, and scheduling.
• Time-Saving Automation: Drastically reduces the manual effort involved in brainstorming, drafting, and organizing tweet ideas.
• Simple Customization: Easily update the list of hashtags in the 'FunctionItem' node and tweak the OpenAI prompt or model parameters in the 'HTTP Request' node directly within n8n.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key. The workflow is configured for the text-davinci-001 model via the legacy completions API; ensure your key supports this or update the 'HTTP Request' node to use a newer model (e.g., gpt-3.5-turbo, gpt-4) and the Chat Completions API for better quality and future compatibility.
• Airtable account and API Key.
• An Airtable Base with a table. The workflow uses placeholder ID appOaG8kEA8FAABOr and table name main. You'll need to update these with your actual Base ID and table name. The table must have fields to store 'Hashtag' (Text) and 'Content' (Text or Long Text).

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure the 'HTTP Request' node for OpenAI: a. In the 'HTTP Request' node settings, find the 'Credential for Header Auth' field. b. Select your existing OpenAI API credential. If you don't have one, create a new 'Header Auth' credential in n8n: Name it (e.g., 'OpenAI API Key'), add a header with 'Name': Authorization, and 'Value': Bearer YOUR_OPENAI_API_KEY. Then, select this newly created credential in the node.
4. Configure the 'FunctionItem' node: a. Open the 'FunctionItem' node. In the functionCode panel, modify the Hashtags array with your desired list of hashtags (e.g., const Hashtags = ["#AI", "#automation", "#YourProduct"];).
5. Configure the 'Airtable' node: a. Select your Airtable API credential or create a new one in n8n if you haven't already. b. Update the 'Application ID' field with your Airtable Base ID. c. Update the 'Table' field with the name of your target table within that Base. d. Ensure your Airtable table has columns named 'Hashtag' and 'Content' (or names that match what you've configured in the 'Set' node). By default, the 'Set' node prepares fields named 'Hashtag' and 'Content'.
6. (Recommended) Review and update the 'HTTP Request' node for OpenAI model: a. The current configuration uses https://api.openai.com/v1/engines/text-davinci-001/completions and a specific JSON body for text-davinci-001. b. For improved results and to use newer models like gpt-3.5-turbo or gpt-4, you'll need to change the 'URL' to https://api.openai.com/v1/chat/completions and update the 'Body Parameters' (JSON) to match the Chat Completions API format (e.g., including a model field and a messages array).
7. Activate the workflow. To test, manually trigger it by clicking 'Execute Workflow' on the 'On clicking 'execute'' node.