n8n Amazon Affiliate Marketing Automation Workflow

This n8n workflow automates the process of generating and publishing Amazon affiliate product posts to a Facebook page, leveraging AI to create engaging content. It's designed to help affiliate marketers efficiently manage their social media presence and promote products.

What it does

This workflow streamlines your Amazon affiliate marketing efforts by:

1. Triggering from Google Sheets: It starts by monitoring a specified Google Sheet for new or updated product entries.
2. Generating Product Content with AI: For each new product, an AI Agent (powered by OpenRouter Chat Model) is used to generate engaging content suitable for a social media post.
3. Making an Amazon API Request: It then uses an HTTP Request node to interact with the Amazon Product Advertising API (or a similar affiliate API) to fetch product details, including affiliate links and images.
4. Preparing Content for Facebook: The generated AI content and Amazon product details are combined and formatted into a cohesive post.
5. Publishing to Facebook: The final post, including the product image and affiliate link, is published to a designated Facebook page using the Facebook Graph API.
6. Storing Binary Data (Optional/Helper): A "Convert to File" node is present, which might be used for handling binary data like images, potentially converting them for upload or storage.
7. Implementing Delays: A "Wait" node is included to introduce pauses between operations, which can be useful for respecting API rate limits or scheduling posts.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Google Sheets Account: Configured with a sheet containing your product data.
• Amazon Product Advertising API Account: Or access to a similar affiliate product API that can provide product details and affiliate links.
• OpenRouter Account: For the AI Agent to function, you'll need an OpenRouter API key and potentially access to specific chat models.
• Facebook Page: A Facebook page where the affiliate posts will be published.
• Facebook Graph API Credentials: An access token with the necessary permissions to post to your Facebook page.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Google Sheets Trigger:
   • Set up the "Google Sheets Trigger" node to monitor your desired Google Sheet for new rows or updates.
   • Provide the necessary Google Sheets credentials.
3. Configure AI Agent:
   • Set up the "AI Agent" node with your OpenRouter credentials.
   • Ensure the "OpenRouter Chat Model" node is configured with your OpenRouter API key and the desired model.
   • Adjust the prompt to guide the AI in generating suitable marketing copy for your products.
4. Configure HTTP Request:
   • Set up the "HTTP Request" node to call the Amazon Product Advertising API (or your chosen affiliate API).
   • Ensure proper authentication (e.g., API keys, signatures) and parameter mapping to fetch product details using data from Google Sheets.
5. Configure Facebook Graph API:
   • Set up the "Facebook Graph API" node with your Facebook credentials and page ID.
   • Map the output from the AI Agent and HTTP Request nodes to create the post content, including the generated text, product image URL, and affiliate link.
6. Review and Activate:
   • Inspect all nodes to ensure data mapping and configurations are correct.
   • Test the workflow with sample data.
   • Activate the workflow to start automating your Amazon affiliate marketing posts.