Automated Amazon Ads Optimization via AI and Reports

This n8n workflow automates the process of analyzing Amazon Ads performance reports, generating optimization insights with AI, and emailing the results. It begins by listing report files in a designated Google Drive folder, then downloads and classifies them based on filename patterns into XLSX or CSV formats. The workflow extracts relevant data from each file, merges and formats this data, and then feeds it into an OpenAI GPT-4 model which provides detailed performance recommendations. Finally, it compiles these insights into an email sent to specified recipients. This automation is ideal for digital marketers managing Amazon ad campaigns, enabling timely, AI-enhanced adjustments based on the latest reports without manual intervention.