Score automotive editorial prospects with WooCommerce, Google Sheets, and OpenAI

by Tangma Craftsman ✓ · 0 views · created 2026-09-30 · Market Research, AI Summarization

What this workflow does

This workflow has 17 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls tangmacraftsman.com, tangmacraftsmans.com and api.openai.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Fetch EU Products (HTTP Request): calls tangmacraftsman.com (GET)
2. Normalize EU Products (Code): runs custom JavaScript code
3. Fetch NA Products (HTTP Request): calls tangmacraftsmans.com (GET)
4. Normalize NA Products (Code): runs custom JavaScript code
5. Read Prospects from Sheets (Google Sheets): read
6. Match Product to Prospect (Code): runs custom JavaScript code
7. If: checks a condition and branches into true / false
8. Fetch Editorial Page (HTTP Request): calls an HTTP API
9. Format Skipped Prospect Data (Code): runs custom JavaScript code
10. Parse Page Metadata (Code): runs custom JavaScript code

…plus 6 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: tangmacraftsman.com, tangmacraftsmans.com, api.openai.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if

From the author

Quick Overview This manual workflow reads pending editorial prospects from Google Sheets, matches each one to a published WooCommerce product from an EU or NA store, fetches the prospect page metadata, scores editorial relevance with OpenAI, and upserts a…

View the original on n8n.io → Check your own copy