Auto Generate & Post LinkedIn Content for Amazon Sellers with GPT-4o & Apify

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:

UserName

jon-derkits

---

posts Table:

Description

Image

InfluencerUsername

InfluencerPost

InfluencerPostCreatedAt

Status

Amazon Listing Optimization...

[Drive Link]

jon-derkits

[LinkedIn URL]

2025-06-18 19:30:01

In review

Status field options:

• In review
• Approved
• Posted
• Rejected

---

Example LinkedIn Visuals

Caption

Image

Boost Your Amazon ROI! <br> Data-driven strategies are your secret weapon...

View Image

Boost Sales with 5–10% Higher Conversions! <br> Utilize Enhanced Brand Content and Smart PPC...

View Image

Grow Your Amazon Business <br> WeSpark – Amazon Consulting Agency...

View Image

Amazon Growth Strategies <br> Embrace the power of smart optimization...

View Image

---

✅ Best For:

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

---