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. An n8n automation workflow template by Usman Liaqat.

Categories

Tags

Capabilities

• 8 nodes
• 133 views