Collect and moderate Shopify photo reviews with GPT-4o, Judge.me, and WhatsApp
Go to Workflow
Rahul Joshi
Description
Quick overview
This workflow pulls recently delivered Shopify orders on a daily schedule, sends WhatsApp and Gmail review requests with an n8n form link, moderates submitted text and photos with OpenAI, publishes approved reviews to Judge.me, and saves ad-consented UGC to Google Drive with Slack notifications.
How it works
Runs every day at 11 AM (cron) and sets timing rules such as when to ask, when to remind, and the daily send limit.
Queries Shopify for recently fulfilled orders, cross-checks a Google Sheets log to avoid duplicate requests, and builds a queue of first-time asks and eligible reminders.
Sends a WhatsApp message and a Gmail email containing a unique review-form link, then logs each request (or marks reminders) in the Google Sheets “Review Requests” tab.
Receives the customer’s n8n form submission (rating, text, optional photos, and ad consent), validates the request token against Google Sheets, and blocks reused or invalid links.
Sends the review text and uploaded images to OpenAI (GPT-4o) to detect issues like screenshots/stock images, personal info, profanity, and spam, and then selects which photos are approved and which are ad-worthy.
Uploads approved review photos to Google Drive and makes them publicly accessible so they can be referenced as image URLs, and copies ad-worthy photos to a separate Google Drive UGC folder while logging them to the “UGC Library” sheet and alerting Slack.
Posts publishable reviews to Judge.me (or flags them in Slack for manual moderation), updates the request status in Google Sheets, and sends either a WhatsApp thank-you for 4–5 star reviews or an AI-written recovery reply plus a Slack alert for 1–3 star reviews.
Setup
Create/collect credentials for Shopify Admin API (X-Shopify-Access-Token header auth), Judge.me API token (api_token query auth), OpenAI, Google Sheets, Google Drive, Gmail, Slack, and WhatsApp Business Cloud.
In Google Sheets, create tabs named “Review Requests” and “UGC Library”, then paste your spreadsheet ID anywhere it shows REPLACE_WITH_GOOGLE_SHEET_ID.
Create two Google Drive folders (review photos and ads UGC) and replace REPLACE_WITH_REVIEW_PHOTOS_FOLDER_ID and REPLACE_WITH_ADS_UGC_FOLDER_ID.
Replace the WhatsApp phoneNumberId and Slack channel ID placeholders, and update the shop domain, store name, and form URL (your n8n domain/path) in the configuration step.
Ensure Shopify orders include delivered timestamps (fulfillments.deliveredAt) and optionally tag orders with no-review to exclude them, then run a test execution and submit a test form response to confirm publishing and logging.
This workflow was created by Rahul Joshi and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.