Google Forms Masterclass • Episode 04 of 14

New Rating Question Scales & Smart Embedding: (ep 04) Scale Post-Purchase Feedback

Stop losing customer reviews to link fatigue! In this episode, Dr. Vishwajeet breaks down the Assam Organic Tea D2C Case Study, exploring new visual Rating question icons (Stars, Hearts, Thumbs-up), custom branded QR generation, responsive HTML iframe embedding, and zero-effort Pre-filled CRM URL distribution.

📺 Speaker: Dr. Vishwajeet Vinayak Gaike ⏱ Duration: 11:44 min 🏷️ Topic: Visual Ratings & Smart Embedding

The 4-Step Visual Feedback & Embedding Architecture

The proven D2C customer feedback blueprint demonstrated by Dr. Vishwajeet in Episode 04 to drive response rates beyond the typical 4% benchmark.

STEP 01

Visual Rating Question Selection

Replace outdated Linear Scales with native Rating fields (3 to 10 points). Deploy Stars for delivery logistics, Hearts for product taste and aesthetic appeal, and Thumbs-up for rapid CSAT verification.

STEP 02

Custom Branded QR Deployment

Generate clean QR codes in Chrome by opening the live published link in an incognito window. Replace the default dinosaur graphic with your corporate logo in Paint or Photoshop to eliminate WhatsApp spam distrust.

STEP 03

Website HTML Iframe Embedding

Click Send → < > tab and embed the iframe directly into your WordPress Elementor or Shopify page. Customer answers feed automatically into your Google Drive sheet without touching local website databases.

STEP 04

Pre-Filled Link Automation

Use the "Get pre-filled link" feature under the three dots menu. Connect URL parameters directly to your billing software or CRM to pass Order IDs and branch names automatically—guaranteeing zero typing friction.

Episode 04 • Knowledge Check

"Why does adding a 'File Upload' question create a critical friction barrier when embedding Google Forms inside a website iframe?"

A) Google Forms disables iframe embeds and redirects users to an external 404 error page.
B) Correct Answer [09:50]: Because file uploads are stored in Google Drive, visitors MUST sign into an active Google account in their browser; otherwise, an intrusive login prompt or blank frame blocks their feedback!
C) Uploaded image files automatically consume the website's local WordPress hosting disk quota.
D) Elementor automatically strips out all iframe file inputs for HTML cross-site scripting security.
Production Deployment Blueprint

System Blueprint: Gemini Multilingual Prompt + HTML Iframe Vault

Deploy the complete 2-part D2C customer review framework: First, use the Gemini prompt to generate a 5-question feedback form featuring native Heart and Star rating scales. Second, copy the responsive HTML iframe snippet to embed it seamlessly into WordPress, Elementor, or Shopify.

PART 1: GEMINI_D2C_FEEDBACK_FORM_PROMPT_EP4.TXT
Act as an expert D2C Customer Experience Specialist and UX Researcher. Create an elite post-purchase feedback form for "Assam Organic Tea" to scale response rates and eliminate link fatigue.

Structure Requirements (Exactly 5 Questions):
1. Aroma & Taste Feedback (Rating with "Hearts" icon, 1-to-5 scale)
   Title: "Rate the Aroma & Taste of our Tea / हमारी चाय की सुगंध और स्वाद को रेट करें / आमच्या चहाचा सुगंध आणि चव रेट करा"
2. Delivery Experience (Rating with "Stars" icon, 1-to-5 scale)
   Title: "Rate your Delivery Experience / अपने डिलीवरी अनुभव को रेट करें / तुमच्या डिलिव्हरी अनुभवाला रेट करा"
3. Pricing Value (Multiple Choice)
   Title: "Is our premium organic tea value for money? / क्या हमारी प्रीमियम ऑर्गेनिक चाय पैसे वसूल है? / आमचा प्रीमियम सेंद्रिय चहा पैशासाठी योग्य मूल्य आहे का?"
4. Next Purchase Interest (Checkboxes: Masala Chai, Green Tea, Oolong Tea, White Tea)
   Title: "Which tea blend would you like to try next? / आप अगली बार कौन सी चाय आज़माना चाहेंगे? / तुम्हाला पुढील वेळी कोणता चहा वापरायला आवडेल?"
5. Suggestions for Improvement (Optional Short Answer)
   Title: "Any suggestions for us? / हमारे लिए कोई सुझाव? / आमच्यासाठी काही सुचना?"

Field Constraints:
- Questions 1 through 4 must be Mandatory (Required).
- Question 5 must remain Optional.
- Set 'Collect email addresses' to 'Do not collect' in settings to enable frictionless anonymous submissions.
PART 2: WORDPRESS_IFRAME_EMBED_SNIPPET.HTML
<!-- Responsive Google Form HTML Embed for WordPress (Elementor) & Shopify -->
<div class="v-gform-wrapper" style="width: 100%; max-width: 820px; margin: 0 auto; overflow: hidden; border-radius: 12px; box-shadow: 0 10px 30px rgba(15, 76, 92, 0.12); border: 1px solid rgba(15, 76, 92, 0.15);">
  <iframe 
    src="https://docs.google.com/forms/d/e/YOUR_FORM_ID_HERE/viewform?embedded=true" 
    width="100%" 
    height="850" 
    frameborder="0" 
    marginheight="0" 
    marginwidth="0"
    style="border: none; display: block;">
    Loading Customer Feedback Form…
  </iframe>
</div>

Deployment Notes:
1. Replace YOUR_FORM_ID_HERE with the unique token from your Google Form view link.
2. In WordPress Elementor, drag an "HTML" widget onto the page and paste this code.
3. All submitted feedback automatically saves directly to your connected Google Sheet in Drive—zero local MySQL database bloat!

Frequently Asked Questions

Technical clarifications on visual rating scales, iframe responsiveness, and QR code branding.

What is the difference between Linear Scale and the new Rating question type?

Linear Scales only display numerical radio buttons (e.g., 1 to 5). The new Rating question type allows you to select visual icons—Stars, Hearts, or Thumbs-up—across a scale of 3 to 10 points. Visual icons gamify the review process, significantly boosting completion rates on mobile devices.

How do I generate a branded QR code without third-party paid subscriptions?

As demonstrated by Dr. Vishwajeet at [02:48], open your published form link in an incognito window, right-click, and select "Create QR code for this page" in Google Chrome. Download the image and replace the central dinosaur icon with your company logo in MS Paint or Photoshop—it remains fully scannable.

Can external website visitors submit embedded forms without a Google account?

Yes, provided you observe two rules: 1) Go to Settings → Responses and set "Collect email addresses" to "Do not collect", and 2) Ensure your form does not contain any "File Upload" fields. This allows 100% anonymous, frictionless submissions without any Google login requirement.

What is coming up in Episode 05?

Episode 05 covers Conditional Skip Logic & Dynamic Branching—learning how to route respondents to tailored sections based on specific answers to prevent survey fatigue.