Amazon Affiliate Marketing Automation

Who this is for

This workflow is for Amazon affiliate marketers and social media managers who want to quickly turn product links into engaging Facebook posts with AI-generated captions and images — fully automated.

What this workflow does

This workflow starts every time a new Product Link is added to a connected Google Sheet. It then:

Extracts the ASIN** from the product link. Fetches product details** from Amazon using RapidAPI. Generates a short, scroll-stopping Facebook caption** with OpenRouter AI. Creates a product image prompt** and sends it to Google Gemini for high-quality image generation. Uploads the creative directly to Facebook** via the Facebook Graph API. Marks the Google Sheet row** as “Done ✅” after posting.

The Facebook post includes:

Product image (AI-enhanced) Short, benefit-focused caption with emojis Affiliate link

Setup

To set this template up, follow the sticky notes inside the workflow and:

Google Sheets → Connect your sheet and ensure the columns “Product Link” & “Facebook Upload” exist. RapidAPI → Add your API key in the “Amazon Product Details” node. OpenRouter → Add credentials for caption generation. Google Gemini → Add your API key for image generation. Facebook Graph API → Connect your Facebook account for posting.

How to customize this workflow to your needs

Change the Facebook caption prompt to match your tone or branding. Adjust the AI image generation prompt to fit your preferred photography style. Modify the Google Sheet update logic if you want to track additional info (e.g., posting date, engagement stats). Switch Facebook posting to Instagram or another platform by replacing the final API call.