🎬 Auto generate & post LinkedIn content for Amazon sellers with GPT-4o & Apify

⚡ 530 views · 🎬 Content Creation & Video

💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.

Description

How it works

This powerful automation turns LinkedIn influencer activity into high performing Amazon seller content, fully hands-off. It runs in two phases:

1. AI Content Generator

   • Retrieves influencer usernames from Airtable
   • Scrapes their most recent LinkedIn post via Apify
   • Uses OpenAI (GPT-4o) to generate original Amazon focused post content
   • Generates a branded LinkedIn image using AI (WeSpark visual identity)
   • Saves content & image link to Google Drive
   • Creates a record in Airtable with Status = In review

2. Scheduled Publisher

   • Every day at 4 PM, one post from Airtable with Status = Approved is:

     • Downloaded from Drive
     • Published on LinkedIn
     • Marked as Posted in Airtable

⚙️ Set Up Steps

• Time to set up: 15–20 minutes

• Create two Airtable tables:

  • influencers with UserName (LinkedIn usernames only)

  • posts with fields:

    • Description (text)
    • Image (Drive link)
    • InfluencerUsername
    • InfluencerPost
    • InfluencerPostCreatedAt
    • Status (In review, Approved, Posted, Rejected)

• Add Google Drive OAuth2 credentials for saving & downloading images

• Configure OpenAI GPT-4o key (for text + image generation)

• Set up Apify LinkedIn scraper and add header credentials

• Link your LinkedIn account (company or personal profile)

Workflow Phases

1. AI Generator (Triggered manually)

• Loops over influencer usernames

• Scrapes latest LinkedIn post

• Skips if already stored

• Uses GPT-4o to:

  • Rewrite the post uniquely for Amazon sellers
  • Generate JSON with text + image prompt

• Saves AI-generated image to Google Drive

• Logs post to Airtable with In review status

2. Daily Publisher (Scheduled)

• Runs every day at 4 PM
• Filters Airtable for Status = Approved
• Picks 1 record, downloads image from Drive
• Publishes to LinkedIn
• Updates Airtable status to Posted

Airtable Setup Example

influencers Table:

posts Table:

Status field options:

• In review
• Approved
• Posted
• Rejected

Example LinkedIn Visuals

✅ Best For:

• Amazon agencies and FBA consultants
• B2B SaaS tools targeting eCommerce
• LinkedIn ghostwriters and creators
• Content marketing teams for Amazon sellers

🔗 Nodes Used

Airtable, HTTP Request, Google Drive, LinkedIn, Schedule Trigger, AI Agent

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup