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.