Amazon Affiliate Marketing Automation with AI Image & Facebook Posting

Overview

This workflow automates Amazon affiliate marketing by generating AI-powered product images and Facebook captions, then posting directly to Facebook and tracking progress in Google Sheets. When a new product link is added to a Google Sheet, the workflow extracts the ASIN, fetches product details from Amazon via RapidAPI, uses OpenRouter (Gemini 2.0 Flash) to create a compelling Facebook caption and an image generation prompt, uploads the product photo to Google Gemini's generative AI service to produce a new enhanced image, and finally posts the image with caption to Facebook. It then updates the sheet to mark the row as "Done ✅". Perfect for affiliate marketers who want to scale their content creation and posting with zero manual effort.

Node-by-Node Breakdown

1. Google Sheets Trigger (OAuth2) — Triggers the workflow whenever a new row is added to a specified Google Sheet. Configured to watch "Sheet1" in the document "Affiliate Automation". Expects columns: "Product Link" and "Facebook Upload".

2. asin number (OpenRouter / API Key) — An AI agent (using Google Gemini 2.0 Flash via OpenRouter) that extracts the ASIN number from the Amazon product URL provided in the new sheet row. The prompt instructs: "You only have to give the asin number from this amazon product url".

3. Amazon Product Details (Header Auth — RapidAPI Key) — Sends an HTTP GET request to the RapidAPI endpoint https://real-time-amazon-data.p.rapidapi.com/product-details?asin={{ $json.output }}&country=US. Uses two headers: x-rapidapi-host and x-rapidapi-key (configured with YOUR_API_KEY placeholder). Retrieves product title, description, image URL, etc.

4. FB caption (OpenRouter / API Key) — An AI agent that generates a short, engaging Facebook caption using the product title and a product feature. The prompt includes instructions to add the affiliate link (with tag ?tag=rakin114-20). Outputs only the final caption.

5. Image Prompt Generate (OpenRouter / API Key) — An AI agent that creates a concise prompt for AI image generation. It instructs to include a human model (if wearable/usable) and cinematic grain. Outputs the prompt inside double quotes.

6. Product Image (No Auth) — Simple HTTP GET request to fetch the original product photo from Amazon (URL from step 3). No authentication needed.

7. Image Upload To Server (API Key — Google Gemini) — Uploads the product photo binary to Google Gemini's file upload API (https://generativelanguage.googleapis.com/upload/v1beta/files?key=YOUR_API_KEY). Uses POST method with binaryData content and headers for upload commands (X-Goog-Upload-Command, X-Goog-Upload-Header-Content-Length, etc.). Returns a file URI.

8. OpenRouter Chat Model (API Key) — A language model node (Google Gemini 2.0 Flash) that is connected to the Image Prompt Generate agent to provide the AI model.

9. OpenRouter Chat Model1 (API Key) — Same model connected to the FB caption agent.

10. OpenRouter Chat Model2 (API Key) — Same model connected to the asin number agent.

11. ai image generator (API Key — Google Gemini) — Sends a POST request to Google Gemini's content generation API (https://generativelanguage.googleapis.com/v1beta/models/gemini-2.0-flash-exp:generateContent?key=YOUR_API_KEY). The JSON body includes the uploaded file URI and the generated prompt. Set to return both text and image (responseModalities: ["Text", "Image"]).

12. Convert to File (Internal) — Converts the base64-encoded image from the Gemini response into a binary file that can be posted to Facebook.

13. Wait (No Auth) — Pauses for 10 seconds before posting to Facebook (to ensure the image is ready).

14. Facebook Graph API (OAuth2) — Posts the generated image to the authenticated Facebook user's profile (me/photos). Uses the caption from the FB caption node as a query parameter message. Sends binary data from the converted file.

15. Google Sheets (OAuth2) — Updates the same Google Sheet row by matching the "Product Link" column and setting the "Facebook Upload" column to "Done ✅".

Setup Instructions

1. Google Sheets: Create a Google Sheet with at least two columns: "Product Link" and "Facebook Upload". Connect your Google account in the Google Sheets Trigger and Google Sheets nodes (OAuth2).
2. RapidAPI: Sign up at RapidAPI and subscribe to the "Real-Time Amazon Data" API. Copy your API key and replace YOUR_API_KEY in the Amazon Product Details node's header parameters.
3. OpenRouter: Create an account at OpenRouter and get an API key. Create a credential in n8n named "OpenRouter" and select it in the three OpenRouter nodes.
4. Google Gemini API: Get a free API key from Google AI Studio. Replace YOUR_API_KEY in the Image Upload To Server and ai image generator nodes (both use the same key).
5. Facebook Graph API: Create a Facebook App and generate a Page Access Token or User Access Token with publish_photo permission. Connect it in the Facebook Graph API node (OAuth2).

Once all credentials are set, add an Amazon product URL (e.g., https://www.amazon.com/dp/B0XXXXXXX) to the "Product Link" column of the sheet. The workflow will trigger automatically and handle the rest.

Use Cases & Variations

• Multi-platform posting: Add additional nodes (e.g., Twitter, Instagram, Pinterest) after the Wait node to cross-post the same image and caption.
• Different affiliate tags: Modify the affiliate link suffix in the FB caption prompt to use your own tag.
• Custom image styles: Edit the prompt in Image Prompt Generate to change the aesthetic (e.g., "flat lay", "minimalist", "lifestyle scene").
• Scheduling: Instead of a Google Sheets trigger, use a Schedule Trigger to run daily and pull from a list of ASINs in a Google Sheet.
• Content approval: Add a Manual Approval node (e.g., Telegram or email) before posting to Facebook.

{
  "id": "EPSFcDt1f8LdRzZU",
  "meta": {
    "instanceId": "061ca141d020a6e1355b8c7fe05f92a699e37e92079ad2e150a506ee8bbe9e11"
  },
  "name": "Amazon Affiliate Marketing Automation",
  "tags": [],
  "nodes": [
    {
      "id": "7c77fce7-01ef-4ab9-898c-f4378cfb12fb",
      "name": "Amazon Product Details",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1248,
        144
      ],
      "parameters": {
        "url": "=https://real-time-amazon-data.p.rapidapi.com/product-details?asin={{ $json.output }}&country=US",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "x-rapidapi-host",
              "value": "real-time-amazon-data.p.rapidapi.com"
            },
            {
              "name": "x-rapidapi-key",
              "value": "YOUR_API_KEY"
            },
            {
              "name": "country",
              "value": "US"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "0a1dc175-1109-475c-908d-f13c4876e5c1",
      "name": "Product Image",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -576,
        496
      ],
      "parameters": {
        "url": "={{ $('Amazon Product Details').item.json.data.product_photo }}",
        "options": {}
// ... truncated (copy to see full JSON)