AutomationMart
Home/Browse/Generate Shopify review outreach drafts with Apify, Hunter, GPT-4o and Gmail
n8n

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

n8nn8n18 modulesv1.0
ShopifyGmailSlackGoogle SheetsOpenAI

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 outreach email with OpenAI, saves it as a Gmail draft, and alerts in Slack. How it works 1. Runs every day on a schedule. 2. Scrapes recent reviews from a set of Shopify app review URLs using an Apify actor, removes duplicate review IDs,

At a glance

Generate Shopify review outreach drafts with Apify, Hunter, GPT-4o and Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Shopify, Gmail, Slack, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Shopify, Gmail, Slack, Google Sheets, OpenAI
Modules
18
Price
Free
Version
v1.0
Generate Shopify review outreach drafts with Apify, Hunter, GPT-4o and Gmail workflow diagram

About this workflow

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 outreach email with OpenAI, saves it as a Gmail draft, and alerts in Slack. How it works 1. Runs every day on a schedule. 2. Scrapes recent reviews from a set of Shopify app review URLs using an Apify actor, removes duplicate review IDs, and keeps only reviews with a rating of 4 or less. 3. Processes each review one at a time and checks Google Sheets to see whether the Review ID already exists. 4. For new reviews, appends the review details to Google Sheets and posts a “new review detected” alert to a Slack channel. 5. Searches Google via the Serper API for the reviewer’s official website, extracts a clean domain from the top result, and uses Hunter to find a contact email. 6. Uses OpenAI to draft a short personalized outreach email based on the review, saves it as a Gmail draft, updates the corresponding Google Sheets row with contact details and the draft, and posts a “draft ready” alert to Slack. Setup 1. Connect credentials for Apify, Google Sheets, Serper (HTTP Header Auth API key), Hunter, OpenAI, Gmail, and Slack. 2. Update the list of competitor Shopify review page URLs and the Apify actor input settings (for example, maxItems) to match what you want to monitor. 3. Point the Google Sheets nodes to your spreadsheet and ensure it includes columns like Review ID, Date, Rating, Review Text, Competitor URL, Reviewer Domain, Website, Contact Name, Contact Title, Contact Email, Status, and Draft-Email. 4. Select the Slack channel where both “new review” and “draft ready” messages should be posted. 5. Ensure your Gmail account is authorized and able to create drafts addressed to the email returned by Hunter.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create Shopify customers from new submitted forms in ConvertBox

Every time a new form is submitted in ConvertBox, Make will automatically create a new customer in Shopify.

Free

Save Shopify orders in Airtable

Every time there is a new Shopify order, it will be recorded into Airtable. Here is the table used in this scenario. You can also use this template to keep track of your products.

Free

Reverse Email Lookup for Google Ads leads

Every time someone submits your Google Ads Lead Form, this template automatically sends their email to FullEnrich's Reverse Email Lookup to identify the person behind it — turning a personal email (Gmail, Yahoo…) into a full B2B profile with work email, phone number, LinkedIn URL, company, and job title. To set up this template, you will need: - A Google Ads account with an active Lead Form asset - A FullEnrich account and API key (find it in your FullEnrich dashboard under Settings) Once set up

Free

Insert new rows with data from Google Sheets to a location specified by index in a document in Google Docs

When new rows are added to Google Sheets spreadsheet, the corresponding data are sent as new rows to Google Docs document. Here, you can specify the start of a list by index, so the newest rows appear as first.

Free

Add a recipient to a Thanks.io mailing list from a new paid Shopify order

Every time a new paid Shopify order is created, Make will automatically add a recipient to a Thanks.io mailing list.

Free

Fetch All Shopify Orders (Handles 250-Limit Loop)

Who Is This For? E-commerce managers, data analysts, and n8n beginners who need a hands-off way to pull all Shopify orders—even stores with thousands of orders—into Google Sheets for reporting or BI. What Problem Does It Solve? Shopify’s GraphQL API only returns up to 250 orders per call, forcing you to manually manage cursors and loops. This template handles the “get next 250” logic for you, so you never miss an order. What This Workflow Does 1. Schedule Trigger – Runs at your chosen cadence

Free

Generate workflow JSON files from webhook prompts using Azure OpenAI GPT-4o-mini

Description Automate the creation of production-ready n8n workflows using AI 🤖. This template receives a plain-text automation idea via webhook, processes it with Azure OpenAI, and instantly generates a fully valid, import-ready n8n workflow JSON file. The automation sanitizes the prompt, enforces strict JSON validation, and returns a downloadable workflow file in seconds. Perfect for building scalable automation tools, SaaS workflow builders, or internal AI workflow generators ⏱️📤. Wha

Free

Re-engage HubSpot leads using Azure OpenAI GPT-4o, Gmail and Slack

Description This workflow automates daily re-engagement for HubSpot leads that were previously paused due to timing. It runs every 24 hours, fetches recent leads with activity data, and filters only those marked as “bad timing,” ensuring active opportunities are not disturbed. Qualified leads are processed in batches, and an AI agent generates a short, polite follow-up email designed to reopen the conversation without sounding salesy. Instead of sending automatically, the workflow creates a Gma

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free