Fields Collected: Timestamp, Post Title, Post URL, Reaction
How to Test
Run Jekyll: bundle exec jekyll serve
Visit any blog post at http://localhost:4000
Scroll to the bottom
Click a reaction emoji (❤️ 👍 🤔 or 😐)
See “Thanks! ✨” message
Open your “Blog Feedback” Google Sheet - you should see the response!
Viewing Feedback
Open your Google Sheet: “Blog Feedback” in Google Drive
You’ll see a new row for each reaction with:
Timestamp: When they clicked
Post Title: Which post they were reading
Post URL: Direct link to the post
Reaction: loved, helpful, interesting, or meh
What Gets Collected
Every time someone clicks a reaction:
Field
Example
Timestamp
“2025-11-10T15:30:45.123Z”
Post Title
“The Team That Built Revolutionary Products”
Post URL
“/og-apple-team/”
Reaction
“loved”, “helpful”, “interesting”, or “meh”
No personal data. Completely anonymous. No tracking.
How It Works (Technical)
The Setup (Already Done!)
Step 1: Created a Google Sheet called “Blog Feedback” with columns:
Timestamp
Post Title
Post URL
Reaction
Step 2: Created a Google Apps Script that:
Receives POST requests from your website
Appends data to the Google Sheet
Handles CORS and authentication
Step 3: Created the feedback widget:
_includes/feedback-widget.html - The HTML/CSS for the emoji buttons
assets/js/feedback-widget.js - JavaScript that sends data to Apps Script
Added `
Was this helpful?
Thanks! ✨
Want to add a quick comment? (optional)
` to _layouts/post.html
That’s it! No Google Forms, no API keys, no complicated setup.
What You Get
Every time someone clicks a reaction:
Instant visual feedback - emoji animates
Thank you message appears: “Thanks! ✨”
Data saves to Google Sheet automatically
Also saves to browser localStorage (backup)
Your Google Sheet will have:
Post Title
Reaction (Loved it / Helpful / Interesting / Meh)
Timestamp
Automatically organized rows
Benefits
✅ 100% Free - unlimited submissions forever ✅ No authentication - anyone can click ✅ Instant submit - one click, done ✅ No popups - stays on the page ✅ Auto-organized - Google Sheets does the work ✅ Easy analysis - charts, filters, pivot tables ✅ Export anytime - CSV, Excel, PDF
Want to add a quick comment? (optional)