This powerful automation turns LinkedIn influencer activity into high performing Amazon seller content, fully hands-off. It runs in two phases:
AI Content Generator
Status = In review
Scheduled Publisher
Every day at 4 PM, one post from Airtable with Status = Approved
is:
Posted
in AirtableTime 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)
Loops over influencer usernames
Scrapes latest LinkedIn post
Skips if already stored
Uses GPT-4o to:
Saves AI-generated image to Google Drive
Logs post to Airtable with In review
status
Status = Approved
Posted
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
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 |