Automation workflow · 2025 · n8n automation, Integrations
Amazon-to-Pinterest content automation
A scheduled enrichment and publishing pipeline using Google Sheets as a transparent, retry-safe operational queue.
Problem
Affiliate content requires repetitive extraction, copy generation, image preparation, publishing, and status tracking.
My role
Workflow design, scraping, local-LLM integration, image handling, and Pinterest publishing
Stack
How the work moves
- Step 01Sheet queueEligible product rows
- Step 02EnrichmentScrape + local LLM JSON
- Step 03Media2:3 image + Drive archive
- Step 04PublishPinterest API + confirmed status
The business problem
Affiliate publishing repeats the same fragile sequence: find a product, extract reliable details, write platform-specific copy, prepare media, publish, and remember what succeeded.
Workflow design
Google Sheets acts as a visible queue. The enrichment workflow selects rows with a product URL but no completed data, extracts the ASIN, scrapes the page, selects the best image, and asks a local Mistral model for JSON-only title and description output.
The publishing workflow prepares a 2:3 image, archives it in Drive, and calls the Pinterest API. A row changes state only after Pinterest confirms creation, keeping failed work retryable and avoiding intentional duplicate publication.