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