Templates / Generate Shopify review outreach drafts with Apify, Hunter, GPT-4o and Gmail

Generate Shopify review outreach drafts with Apify, Hunter, GPT-4o and Gmail

Unknown

by Jitesh Dugar ✓ · 39 views · created 2026-06-09 · Lead Generation, Multimodal AI

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 18 nodes and runs on a schedule (every day at 10:00). Along the way it connects OpenAI Chat Model, Google Sheets, Hunter and Gmail and 2 more. It also calls google.serper.dev over HTTP.

How it runs

Trigger: On a schedule (every day at 10:00).

Set Target App URLs (Code): runs custom JavaScript code
Scrape Shopify Reviews (Apify): run actor and get dataset
Remove Duplicate Reviews (Remove Duplicates): removes duplicate items
Filter: keeps only the items that match a condition
Process Each Review (Loop Over Items (Split in Batches)): loops over the items in batches
Check Existing Reviews (Google Sheets): uses Google Sheets
If: checks a condition and branches into true / false
Log New Review (Google Sheets): append
Alert New Review Detected (Slack): uses Slack
Search Google for Website (HTTP Request): calls google.serper.dev (POST)

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

Services it uses

OpenAI Chat Model Google Sheets Hunter Gmail SlackApify (community)

HTTP calls to: google.serper.dev

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Scrape Shopify Reviews).

Nodes used (14)

OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
Google Sheetsn8n-nodes-base.googleSheets
Coden8n-nodes-base.code
Huntern8n-nodes-base.hunter
Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
Filtern8n-nodes-base.filter
Schedule Triggern8n-nodes-base.scheduleTrigger
Apify@apify/n8n-nodes-apify.apify
Remove Duplicatesn8n-nodes-base.removeDuplicates
Ifn8n-nodes-base.if
HTTP Requestn8n-nodes-base.httpRequest
Gmailn8n-nodes-base.gmail
Slackn8n-nodes-base.slack

From the author

Quick Overview This workflow runs daily to scrape competitor Shopify app reviews via Apify, logs and deduplicates new low-rated reviews in Google Sheets, looks up the reviewer’s website with Serper, enriches contacts with Hunter, generates a personalized…
Excerpt from Jitesh Dugar's description on n8n.io.

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

Generate Shopify review outreach drafts with Apify, Hunter, GPT-4o and Gmail

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (14)

From the author

Get the weekly “what broke” email