Automate WooCommerce Reviews with n8n & Google Sheets

Effortlessly Automate WooCommerce Reviews with n8n & Google Sheets

Enhance your WooCommerce store's customer engagement effortlessly with our powerful n8n workflow. Seamlessly automate post-purchase review requests and effortlessly manage customer feedback using Google Sheets in a streamlined manner. From capturing order details to collecting insightful reviews, this workflow ensures your store is equipped to leverage valuable customer feedback, enhancing both reputation and sales.

What this workflow does

• Receives WooCommerce order completion events through a webhook and acknowledges them with a 200 OK response.
• Processes incoming order data, generating a unique review form token and expiration date. Builds customized review form URLs for your customers.
• Retrieves product images and permalinks via the WooCommerce REST API, compiles a comprehensive product list, and appends form records to a Google Sheets tab for streamlined management.
• Optionally shortens form URLs with Dub.co for cleaner delivery and configures message send delays tailored to your preference.
• Crafts and sends beautifully rendered HTML emails through SMTP, presenting ordered products and review links directly to customers.
• When customers access the review link, validates tokens via Google Sheets, delivering either a user-friendly multi-product rating form or an informative error page.
• Submits each product review back to WooCommerce, holding the status for moderation while marking the Google Sheets form as completed.

Use cases

• E-commerce Owners: Streamline the review collection process, enhancing your store’s authenticity and customer trust.
• Automation Engineers: Implement efficient review collection systems, integrating seamlessly with existing platforms for enriched data management.
• Customer Experience Teams: Leverage customer feedback insights swiftly with organized data collection and processing via Google Sheets.

Technical details

• Integrations: WooCommerce, Google Sheets, Dub.co
• n8n Nodes Utilized: Webhook, Code, Email Send, If, Wait, Merge