• Mail us
  • Book a Meeting
  • Call us
  • Chat with us

AI/ML

n8n Workflow Automation : The Smart Way to Collect Customer Testimonials and Feedback


Overview

n8n sends a Google Forms feedback request post-purchase, collects responses and updates a WordPress site with testimonials.

Prerequisites

  • n8n installed.
  • Google Forms with webhook support.
  • Gmail account with API key.
  • WordPress site with API access.

Workflow Setup

  1. Prepare n8n Environment

    • Navigate to http://localhost:5678 (or your n8n hosted URL) and log in with your credentials. 

    • In the sidebar, click “Workflows,” then select “+ New” and name it (e.g., “Campaign Tracker”). Click “+” on the canvas to open the node selector.

  2. Trigger Node: Shopify Webhook

    • Node: Webhook

    • Settings:

      • Path: shopify-sale

      • Shopify Webhook: “Order Creation” at https://<n8n-host>/webhook/shopify-sale

    • Output: Sale data (e.g., {{ $json.body.line_items[0].sku }}).

  3. Update Shopify Node: Shopify

    • Node: Shopify

    • Settings:

      • Credentials: Shopify API key

      • Resource: Inventory

      • Operation: Update

      • SKU: {{ $node["Webhook"].json.body.line_items[0].sku }}

      • Quantity: Decrease by {{ $node["Webhook"].json.body.line_items[0].quantity }}

    • Output: Shopify stock updated.

  4. Update Amazon Node: HTTP Request

    • Node: HTTP Request

    • Settings:

      • URL: Amazon SP-API endpoint for inventory

      • Method: PUT

      • Authentication: Amazon API credentials

      • Body: { "sku": "{{ $node["Webhook"].json.body.line_items[0].sku }}", "quantity": "-{{ $node["Webhook"].json.body.line_items[0].quantity }}" }

    • Output: Amazon stock synced.

  5. Log Node: Google Sheets

    • Node: Google Sheets

    • Settings:

      • Operation: Update

      • Spreadsheet ID: Inventory sheet

      • Range: A:C

      • Key: SKU column

      • Value: New quantity

    • Output: Centralized stock log.

  1. Prepare n8n Environment

    • Navigate to http://localhost:5678 (or your n8n URL) and log in with your credentials. In the sidebar, click “Workflows,” then select “+ New” and name it (e.g., “Testimonial Collector”). Click “+” on the canvas to open the node selector.

  2. Trigger Node: Cron

    • Node: Cron

    • Settings:

      • Cron Expression: 0 10 * * * (daily at 10 AM)

    • Output: Daily trigger.

  3. Send Request Node: Gmail

    • Node: Gmail

    • Settings:

      • To: Customer email (from CRM or sheet)

      • Subject: We’d Love Your Feedback!

      • Body: Please share your experience: <Google Form link>

    • Output: Feedback request sent.

  4. Collect Response Node: Google Forms

    • Node: Webhook

    • Settings:

      • Path: feedback-response

      • Google Forms Webhook: https://<n8n-host>/webhook/feedback-response

    • Output: Response data (e.g., {{ $json.body.form_response.answers[0].text }}).

  5. Update Site Node: HTTP Request

    • Node: HTTP Request

    • Settings:

      • URL: https://<your-site>.com/wp-json/wp/v2/testimonials

      • Method: POST

      • Authentication: WordPress API key

      • Body: { "title": "Testimonial", "content": "{{ $node["Webhook"].json.body.form_response.answers[0].text }}", "status": "publish" }

    • Output: Testimonial published.

Workflow Summary

  • Flow: Cron → Gmail → Webhook → HTTP Request.
  • Execution: ~10 seconds per response.

Benefits

  • Saves ~30 minutes/testimonial.
  • Builds trust with social proof.
  • Enhances marketing automatically.

Troubleshooting

  • Email Fail: Check Gmail API key.
  • Site Update Fail: Verify WordPress API.

Ready to transform your business with our technology solutions? Contact Us today to Leverage Our AI/ML Expertise. 

Share

facebook
LinkedIn
Twitter
Mail
AI/ML

Related Center Of Excellence