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

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:

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

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! Data-driven strategies are your secret weapon... | View Image |
| Boost Sales with 5–10% Higher Conversions! Utilize Enhanced Brand Content and Smart PPC... | View Image |
| Grow Your Amazon Business WeSpark – Amazon Consulting Agency... | View Image |
| Amazon Growth Strategies 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