Automated Social Media Posting based on Product Data

This tutorial will guide you through setting up an automated workflow in n8n to fetch product data, process images, generate AI-powered content, and post to a Fanpage.

---

Prerequisites

Before starting, ensure you have the following set up:

• An n8n instance installed and running (self-hosted or cloud).
• A Telegram Bot set up with an API token via BotFather
• API key for any AI models you use (OpenAI, Gemini, Claude, DeepSeek…)
• Facebook page API credentials.

Step-by-Step Implementation

1. Get Data from Airtable

Steps:

1. Trigger Workflow:
   • Use a Telegram Trigger to start the workflow manually, or.
   • Use a Schedule Trigger to run the workflow at a set interval.
2. Fetch Data from Airtable:
   • Use first Airtable (Search) to retrieve the prompt for the post. You can insert prompt directly to n8n node.
   • Use second Airtable (Search) to retrieve the product description and image from Airtable.
   • Node Function to process images in the next AI Agent node.

// Get input items
const items = $input.all();

return items.map(item => {
    // Handle array of URLs if they exist
    if (item.json.imageUrls && Array.isArray(item.json.imageUrls)) {
        return {
            json: {
                imageUrls: item.json.imageUrls.map(url => transformAirtableUrl(url))
            }
        };
    }
    
    // Handle Attachments from Airtable
    if (item.json.Attachment && Array.isArray(item.json.Attachment)) {
        return {
            json: {
                imageUrls: item.json.Attachment.map(att => transformAirtableUrl(att.url))
            }
        };
    }
    
    return item;
});

// Helper function to transform Airtable URLs
function transformAirtableUrl(url) {
    if (url && url.includes('airtableusercontent.com')) {
        const baseUrl = url.split('?')[0];
        return baseUrl + '?dl=1';
    }
    return url;
}

---

2. Process Data with AI and Prepare Images

1. Analyze Images with AI:
   • Create AI Agent node, attach your desired AI Model to analyze product images.
   • Retrieve sample data from Airtable with Airtable (Search) node use as reference.
   • Analyze Photos: The AI generates content based on image details and reference data.
2. Prepare and Process Images:
   • Combine Photos with Function node to merge multiple images.

const items = $('Get Data').all();

return items.reduce((acc, item) => {
  let urls = [];
  
  if (item.json.Attachment && Array.isArray(item.json.Attachment)) {
    urls = item.json.Attachment.map(att => ({
      url: att.url
    }));
  }
  
  return acc.concat(urls);
}, []);

1. Loop Over Items node to process each image individually.
2. Facebook Graph API node to prepare images for social media.
3. Edit Fields node to retrieve media information for Facebook.
4. Use Function node to process image information to be ready for post.

// Get message from AI Agent node's output value
const message = $node['Analyze Photos'].json.output;

// Access the nested media_fbid from the json property
const attachedMedia = items.map(item => ({
    "media_fbid": item.json.media_fbid
}));

// Log for verification
console.log('AI Agent Message:', message);
console.log('Final attached_media:', attachedMedia);

return {
    json: {
        message: message,
        published: "true",
        attached_media: attachedMedia
    }
}

---

3. Post to Fanpage and Interact

1. Post Content to Facebook Fanpage:
   • Use the Facebook Graph API node to upload the processed images and AI-generated content.
2. Update Status and Check Unpublished Posts in Airtable:
   • Use the Airtable (Create or Update) node to update status to mark the post as completed.
   • Add Airtable (Search) node to count unpublished posts and send via Telegram.
3. Interact with post:
   • Use HTTP Request node to like and comment your desired information to the post, e.g: Contact information, etc..

https://graph.facebook.com/v22.0/{{ post.id }}/comments
https://graph.facebook.com/v22.0/{{ post.id }}/likes

---

4. Error Handling & Optimization

• For important steps, add a Telegram (Send a text message) node to send log/error.
• Set up retry mechanisms for node failures.

---

Conclusion

This workflow automates content creation, image processing, and social media posting while ensuring logs are sent to Telegram for tracking. By using n8n, you can efficiently manage social media interactions with AI assistance.