Skip to content
FlowHubFluxonLab
C
Email Sendfree

Collect post-purchase product reviews with WooCommerce, Google Sheets, and SMTP

by Business Atlasadapted from n8n official workflow galleryUpdated Aug 2026
RequiresCCodeGoogle SheetsGoogle SheetsHTTP RequestHTTP RequestSend EmailSend Email
Share Post Share
WeWooCommerce Order CompleteWooCommerce Ord…WeWhen External Order ReceivedWhen External O…RTAcknowledge WooCommerce OrderAcknowledge Woo…RTAcknowledge External OrderAcknowledge Ext…CoNormalize WooCommerce OrderNormalize WooCo…CoFormat External Order DataFormat External…CoConfigure ParametersConfigure Param…CoSplit Order by ProductSplit Order by …HRFetch WooCommerce ProductFetch WooCommer…CoAggregate Product DetailsAggregate Produ…Append Form Data to SheetsAppend Form Dat…CoRetrieve Saved DataRetrieve Saved …IfCheck URL Shortening ActiveCheck URL Short…HRShorten URL with Dub.coShorten URL wit…CoAssign Shortened URLAssign Shortene…CoAssign Direct URLAssign Direct U…MeCombine URL DataIfCheck for Delay ActivationCheck for Delay…WaWait 3 Days for ReviewWait 3 Days for…MeAggregate Post-Delay DataAggregate Post-…CoBuild Email HTML ContentBuild Email HTM…ESSend Review EmailSend Review Ema…WeServe Review Form to UserServe Review Fo…Read Form Data for ServingRead Form Data …CoCheck Form Token ValidityCheck Form Toke…IfValidate Form Token StatusValidate Form T…CoGenerate Review Form HTMLGenerate Review…RTReturn Form HTML to BrowserReturn Form HTM…CoGenerate Error ResponseGenerate Error …RTReturn Invalid Link ErrorReturn Invalid …WeAccept Review SubmissionAccept Review S…Retrieve Submission DataRetrieve Submis…CoProcess Submitted ReviewsProcess Submitt…IfValidate Review SubmissionValidate Review…CoSplit Review EntriesSplit Review En…HRUpload Review to WooCommerceUpload Review t…Update Review Completion StatusUpdate Review C…RTReturn Thank You MessageReturn Thank Yo…RTReturn Submission Error ResponseReturn Submissi…1234567891011121314151617181920212223
1/5
FLOWS
STEPS · 23
Starts on an incoming request

Quick overview This workflow sends post-purchase review request emails for WooCommerce orders, stores expiring form links in Google Sheets, optionally shortens links with Dub.co and delays delivery, serves a hosted rating form via n8n webhooks, and submits collected reviews back to WooCommerce. How it works Receives an order completion event via a WooCommerce webhook or an external POST webhook and returns a 200 OK response. Normalizes the incoming order payload, generates a unique form token and expiry, and builds a customer-specific review form URL. Fetches each product’s image and permalink from the WooCommerce REST API, aggregates the product list, and appends the form record to a Google Sheets tab. Optionally shortens the form URL using the Dub.co API and optionally waits a configured number of days before sending the message. Renders an HTML email containing the ordered products and the review link and sends it via SMTP to the customer. When the customer opens the review link, looks up the form token in Google Sheets, validates status/expiry, and serves either the multi-product rating form HTML or an error page.

Tags

n8nreference-onlyemail-sendgoogle-sheets
Connects
CCodesheetsGoogle SheetsWHTTP RequestsendemailSend Email
CategoryEmail Send
Triggermanual
Complexityadvanced
Nodes39
AddedJul 12, 2026

Related workflows

See all Email Send
sheetssendemail
free

Send Typeform results to Google Sheet, Slack and email

Trigger on new Typeform form submission Write data to Google Sheet Check severity of problem If very severe post message to Slack If not so severe just send an email Assumptions Google Sheet Sheet in Spreadsheet called "Problems". Columns Names: Name Email Severity Problem Example Sheet: https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU Typeform Typeform formular with questions named exactly like the columns of the Google Sheet.

by Jan Oberhauser
sheetssendemail
free

Create an invoice in Google Sheets based on Typeform submission

This form takes data from a Typeform submission and creates an invoice on Google Sheets

by alex
sheetssendemail
free

Notify about Google Sheet changes in Slack and email

To notify by Slack and mail all modification on a Google Sheet

by etienne