Seller Sessions artwork

Amazon API Data Pipelines & AI Design Workflows — Broad Match Show

Seller Sessions · with Adam Heist · April 17, 2026 · 45 min

Summary

This episode reveals how Amazon sellers can create powerful data pipelines using Amazon APIs (SP & Ads) connected to AWS and Claude Code for real-time data analysis, no developer required. It also details an 8-step AI-powered design workflow to generate conversion-tested assets from inspiration to final product, helping sellers streamline creative processes and leverage AI effectively while understanding its limitations.

Key takeaways

Themes

amazon & marketplacesai & automationanalytics & attributionbrand & content

Topics covered

amazon sp api integrationamazon ads api integrationaws database for sellersclaude code for data analysisai design workflowai limitations in ecommercecli for api integrationautomated asset generation

Episode description

In this Broad Match Show, Danny McMillan and Adam Heist cover two of the most practical AI frontiers for Amazon sellers right now: getting direct API access to your Seller Central data and building a fully automated design workflow from inspiration through to live assets. Adam breaks down how he connected Amazon's SP API and Ads API to an AWS database and wired Claude Code directly to it — giving him real-time, queryable access to years of business data across any metric. No developer required. Danny walks through his 8-step system that takes a seller from a TikTok scroll to a finished, conversion-tested design with brand consistency baked in. Both share hard-won lessons on where AI gets you (the 70–85% mark) and where the human still needs to step in — plus a candid look at what's changing at Seller Sessions Live on May 9th. Key Topics Amazon API data pipeline — SP API + Ads API → AWS database → Claude Code for real-time analysis 8-step AI design workflow — Inspiration capture, memory/photo brain, brand system, mood board, asset generation, build, and quality gate CLI vs MCP — Why CLIs are becoming the cleaner integration path for tools like Google Workspace Seller Sessions Live (May 9th) — New modular format, no sponsors, £5,000 fine system for service providers pitching Health check-in — Adam on fitness goals; Danny on resolving a high ferritin (iron overload) diagnosis Timestamps [00:00] Welcome and introductions [01:10]

Related episodes

Frequently asked about this episode

What does this episode say about amazon & marketplaces?
Implement a real-time data pipeline by connecting Amazon's SP and Ads APIs to an AWS database and integrating Claude Code for direct querying of performance metrics, eliminating the need for a developer.
What does this episode say about ai & automation?
Adopt an 8-step AI-powered design workflow, beginning with inspiration capture and progressing through brand system definition, mood boarding, asset generation, and a quality gate, to produce conversion-tested designs efficiently.
What does this episode say about analytics & attribution?
Recognize that AI can achieve 70-85% of data analysis and design tasks, but strategic human oversight and creative judgment remain crucial for optimizing results and ensuring brand consistency.
What does this episode say about brand & content?
Explore CLIs for cleaner tool integrations, as they offer a more direct and developer-friendly approach compared to traditional methods, drawing parallels with Google Workspace's integration paths.
What does this episode say about amazon & marketplaces?
Leverage AI for asset generation and creative tasks, but always incorporate a "quality gate" to ensure brand consistency and conversion effectiveness, understanding AI’s current limitations in achieving 100% perfection.

Listen