Generate weekly Pinterest content opportunity briefs with Apify, OpenAI and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI and Google Sheets. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- 1. Set Your Research Niche (Edit Fields (Set)): sets 6 fields: niche, searches, locale…
- Build FetchCat Research Input (Code): runs custom JavaScript code
- 2. Collect Pinterest Results with FetchCat (HTTP Request): calls api.apify.com (POST)
- Normalize and Deduplicate Pins (Code): runs custom JavaScript code
- Build Research Evidence (Code): runs custom JavaScript code
- 3. Analyze Content Landscape and Opportunities (OpenAI): uses OpenAI
- Keep Only Supplied Evidence Citations (Code): runs custom JavaScript code
- Validate Evidence and Build Report (Code): runs custom JavaScript code
- Prepare Pin Rows (Code): runs custom JavaScript code
- 4. Save Source Pins (Google Sheets): append or update
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview Research a Pinterest niche with FetchCat's Pinterest Search Scraper, preserve every source pin in Google Sheets, and use one evidence-controlled OpenAI call to identify recurring themes, underrepresented angles, and five production-ready…