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. 

    Experts in AI, ML, and automation at OneClick IT Consultancy

    AI Force

    AI Force at OneClick IT Consultancy pioneers artificial intelligence and machine learning solutions. We drive COE initiatives by developing intelligent automation, predictive analytics, and AI-driven applications that transform businesses.

    Share

    facebook
    LinkedIn
    Twitter
    Mail
    AI/ML

    Related Center Of Excellence