Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Optimise Amazon Ads Reports with OpenAI

When you run it, it reads Amazon Ads XLSX and CSV reports from Google Drive, has OpenAI analyse them and emails recommendations via Gmail.

Import it free Sign in to open it

What it does

## Upgrade! 🚀 Apply for an Amazon Advertising API developer account to unlock full automation: Generate reports programmatically via the Reports API Fetch report files directly into n8n using HTTP or custom nodes Eliminate email + Drive dependency entirely 🔗 https://advertising.amazon.com/API/docs/en-us/ Once approved, you can schedule report generation and download all required data securely and automatically. Double click to edit me. Guide

The steps

  1. List Files
  2. OpenAI Chat Model
  3. is XLSX
  4. Get File
  5. Merge XLSX and CSV
  6. Format Data
  7. Set fileName
  8. Preserve File Name
  9. Email Optimizations
  10. Extract XLSX Data
  11. Extract CSV Data
  12. Preserve CSV File Name
  13. When clicking ‘Test workflow’
  14. Email Options

15 steps in total.

Similar automations

Reports, Analytics & DashboardsOptimize Amazon Ads Reports with OpenAI and Email Results21 stepsContent Writing & GenerationCreate Meta Video and Image Ads from Drive with OpenAI and Gemini49 stepsSocial Media PublishingUpload Video and Image Ads to Meta from Sheets34 stepsFiles & Cloud StorageAmazon Ads AI Optimization16 steps