Back to Templates

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

Created by

Created by: Usman Liaqat || usmanliaqat

Usman Liaqat

Last update

Last update 13 hours ago

Share


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