WHAT
WHAT
1-minute promo link.
WHAT does this solution do?
This is a *NO-COST* solution that Searches > Curates > Downloads YouTube content to your Google Sheets from any channel — automatically and for you to keep.
WHAT can I do with this solution?
As a YouTube Host you can use this solution to automatically collect every comment on your channel’s videos, filter by positive/negative vibe, and highlight the most engaged viewers. Instead of scrolling endlessly, you see the feedback in one sheet and can reply faster to build community loyalty.
A viewer or fan can use this solution to save comments from videos you care about, filter by positive/negative vibe and keep a personal log of meaningful conversations. You can acknowledge supportive comments or revisit threads that mattered to you long after the video faded.
You're neither a host nor a viewer? See below under 'OTHERS'.
🔥 See below under 'HOW' to get started. 🔥
1-minute promo link.
NO CO$T: The solution's developer didn’t impose a cost when used for casual personal use.
NO SPAM or ADs: Doesn’t post or auto-reply; collection only.
NO DATA LIMITS or QUOTAS: The solution's developer didn’t create limits like data caps, subscriptions, etc. Caps/windows are set by you in the config, not by the developer.
NO LOGINS or REDIRECTS: Runs in Google Apps Script; nothing is sent to third-parties or the developer.
NO SCRAPING: Uses the official YouTube API; read-only to YouTube.
NO BS (I mean .... NO surprises)
🔥 See below under 'HOW' to get started. 🔥
1-minute WHY link.
WHY was this solution created?
Acknowledgement.
Acknowledgement of effort.
I don’t think + (positive) YT comments should go unanswered.
I don’t think ‒ (negative) YT comments should go unnoticed.
I developed this solution thanks to ChatGPT to make it very easy for - mainly - hosts and viewers to show gratitude by acknowledging his/her/their positive or negative YT comments.
Hoping you (or someone you know) use this solution to spot the comments that contributes to your life and acknowledge him/her/them for it.
Maybe make it a habit to acknowledge 2, 5, 10+ comments per video or whatever feels right to you.
🔥 See below under 'HOW' to get started. 🔥
This solution is now available as a Google Sheets add-on in Google Workspace Marketplace in the following countries/regions:
🇺🇸 U.S.
I'm considering making it available in Latin America, Asia, Europe, etc.
🔥 See below under 'HOW' to get started. 🔥
TESTERS:
🇺🇲 - In the U.S.:
ADVISORS:
🇺🇲 - In the U.S.:
ADVOCATES:
🇺🇲 - In the U.S.:
HOW to set it up:
This is a 1-min One-time setup demo and the steps are listed below:
Open a blank Google Sheets: Go here.
Get the add-on: Go here > Click on ‘Install’ > Follow the prompts.
Get the 'Let's Start Here' sheet: On the top menu click on Extensions, ‘Content Curator for YouTube’, One-time Set Up and follow the instructions.
Then the ‘Let’s Start Here’ sheet should appear at the bottom.
THAT’S IT! Now, here’s how to use this solution
This is a 5-minute demo on how to use this solution:
Other ways to acknowledge others:
Working on adding more ideas here
This solution timeline...
2024, Dec 🠆 SHOCKED! 🠆 0 lines of code 🠆 Favorite YT creators said they didn’t respond to comments.
▼
2025, Jan 🠆 QUESTIONS 🠆 0 lines of code 🠆 Can I prove comments are not that bad?
Do I want to do it?
Can I do it?
▼
2025, Jan 🠆 ANSWERS 🠆 1.4k lines of code 🠆 I don't' know. Let's chat to mentors and do research.
Answers: Yes, I do want to do it. Yes, it's likely I can do it.
▼
2025, Feb 🠆 HEAD BANGING 🠆 1.5 lines of code 🠆 Asking ChatGPT (Free & PLUS versions) to generate code
was like speaking with a:
polite, eloquent 10-year-old with Alzheimer's. Lots of mistakes in the code and lots of platform "network" errors.
▼
2025, April 🠆 MORE HEAD BANGING 🠆 2k lines of code 🠆 ChatGPT memory update to reference past chats/conversations kept generating new code with *past* implementations that had not wok for me.
HUGE set back because I had no idea what was going on or how to fix it.
▼
2025, Aug 🠆 LESS HEAD BANGING 🠆 5k lines of code 🠆 Engineered an everchanging detailed prompt to cover each misunderstanding I had noticed ChatGPT had and used it for *every* request from that point on.
▼
2025, Oct 🠆 APPROVAL 🠆 6k lines of code 🠆 Google approved all the permissions necessary for this solution to work for the end-user globally. This approval process took 14 days total and required me to brush up on my graphic design, web developing, video editing, language dubbing, text-to-speech, voice over and IP infringement skills.
Resources used: Guidance by Google - (FREE), CANVA - (FREE)
VSDC Video Editor - (FREE), ElevenLabs - (FREE to try).
▼
2025, Nov? 🠆 RELEASE 🠆 6k lines of code 🠆 Google approved the global release of this solution as a Sheets add-on via Google Workspace Marketplace.
▼
2025, ??? 🠆 VERSION #2 🠆 0 lines of code 🠆 TBD
▼
2025, ??? 🠆 VERSION #3 🠆 0 lines of code 🠆 TBD
Greetings... I'm Lauren.
I’m a Solutions Manager Engineer—TPM who, in developing this solution with ChatGPT, was reminded of the value strong technical roles deliver.
I developed this solution thanks to ChatGPT to make it very easy for - mainly - hosts and viewers to show gratitude by acknowledging his/her/their positive or negative YT comments.
Hoping you (or someone you know) use this solution to spot the comments that contributes to your life and acknowledge them for it.
Maybe make it a habit? Maybe acknowledge 2, 5, 10+ comments for new each video or whatever feels right to you.
🔥 See above under 'HOW' to get started. 🔥
Reflections - Lessons Learned
1) Playing to be a programmer for months reminded me of the intense mental focus programmers must have to produce useful, quality code that produces results. During this time, I was reminded of coding for subtle steps, errors, absence of x, abundance of y, the opposite of z. Put differently, I had to code for what I wanted, for what I didn’t want and for what could happen – for each feature.
a. Tradeoffs: Balanced engineering needs (readable, defensive code) vs end-user needs (clear Sheets output, predictable resumes) vs tool limits (runtime, quotas, write costs).
Achieved stronger safeguards and clearer outputs by adding extra guards, checks, filtering, validation, and edge-case handling — at the cost of raw speed compared to leaner approaches.
2) Playing to be a Systems Engineer reminded me to consider dependencies & tradeoffs to make the best decision for that one feature, at that at point in time, and move on – fast!
a. Tradeoffs: Balanced engineering needs (segmented execution, dependable resumes) vs end-user needs (reliable restarts, no duplicates, clear progress) vs tool limits (Apps Script timeouts, YouTube quotas).
Achieved stable publish order, lower quota use, cleaner pagination, fewer duplicates, and resume-friendly pageTokens by switching channel retrieval from YouTube.Search.list to YouTube.PlaylistItems.list (Uploads playlist) — at the cost of a one-time refactor and setup.
3) Playing to be a Data Scientist reminded me of defining rule-based labels (host/guest/none), tuning emoji-aware vibe scoring with cached regex, and ranking selections using likes/replies with configuration limits and week/date windows.
a. Tradeoffs: Balanced engineering needs (lightweight, local scoring) vs end-user needs (useful, explainable “comments that matter”) vs tool limits (no external ML, limited compute, regex/token rules).
Achieved explainable rankings with host/guest/vibe signals — at the cost of manual token/regex tuning and periodic review.
I’m not a programmer.
I’m not a Systems Engineer.
I’m not a Data Scientist.
I’m a Solutions Manager Engineer—TPM who, in developing this solution with ChatGPT, was reminded of the value those roles deliver.
It’s good to be reminded … by doing.
To share
helpful advice or feedback,
get answers to your questions or
request features
complete this quick and anonymous 5-question form.
You can also get answers to your questions by asking asking this on-demand AI model I created within ChatGPT.
Other users who might benefit from this solution:
Event Organizer / Podcaster:
This solution lets you log live show or episode feedback, identify which guests resonated, and measure whether recurring formats work. That helps you adjust lineups and promote episodes that spark stronger discussions.
Researcher:
This solution lets you capture audience commentary at scale, bucket sentiment, and track recurring themes. That means you can run longitudinal studies on how viewers respond to a person, a topic, or a brand across years without building a separate crawler.
Marketer:
This solution lets you pull thousands of viewer comments in minutes, score them by vibe, and rank them by likes or replies. That way, you can spot campaign impact, validate messaging, and double-down on the content that resonates most with your target audience.
PR / Communications Specialist:
This solution lets you spot negative waves of comments early, identify top critics, and highlight supportive voices. You can manage crises by acknowledging viewers in their own words, strengthening brand credibility.
Data Analyst:
This solution lets you extract raw comments and video stats directly into structured rows, ready for pivot tables or dashboards. You can measure sentiment across years, compare host vs. guest reception, and surface trends in viewer engagement without manual scraping.
Nonprofit / Advocacy Group:
This solution lets you collect supporter and critic comments around awareness campaigns, split them by sentiment, and highlight grassroots voices. You can acknowledge supporters and respond constructively to skeptics.
Educator / Trainer:
This solution lets you gather all learner feedback from course videos, group by positive/negative tones, and quickly identify what lessons worked vs. where students struggled. That gives you a faster loop for improving your content.
🔥 See below under 'HOW' to get started. 🔥
Host's Team Members
Video Editor:
This solution lets you scan all comments to find which clips, quotes, or segments hit hardest with viewers. You can cut highlight reels or shorts from the moments fans actually noticed, boosting watch-through and shareability.
Social Media Manager:
This solution lets you spot which comments are most liked or replied to, then repost them as shout-outs or memes on other platforms. That drives engagement loops and makes fans feel recognized.
Producer / Showrunner:
This solution lets you track reactions to different episode formats, guests, or recurring bits. You can steer the creative direction toward what resonates, while still seeing which experiments missed the mark.
Moderator / Community Assistant:
This solution lets you pull all new comments, classify by vibe, and focus your moderation time on the most heated or off-tone threads. That keeps the community healthy without wading through every single comment manually.
Assistant / Coordinator:
This solution lets you prep acknowledgment notes for the host by listing the top comments to thank. That saves the host’s time and makes sure viewers feel seen in a timely way.
🔥 See below under 'HOW' to get started. 🔥
Indirect Use cases
Academic Researcher:
This solution helps analyze public conversations around cultural trends, digital communities, or media reception by exporting structured datasets of YouTube comments.
Brand Strategist:
This solution helps monitor sentiment shifts across collaborations and campaigns, informing positioning strategies without running separate focus groups.
Advertiser / Media Buyer:
This solution helps identify which hosts and guests generate the most engaged feedback, guiding smarter ad placements or sponsorship investments.
SEO / Growth Specialist:
This solution helps uncover keywords and themes viewers use in comments, which can feed back into video titles, descriptions, and SEO strategy.
Recruiter / HR Specialist (for creators):
This solution helps demonstrate creator influence and audience loyalty when hiring team members or pitching job roles, since community interaction becomes measurable.
Educator / Workshop Facilitator:
This solution helps provide real-world case studies of online engagement for teaching marketing, communication, or social dynamics.
Investor / Analyst:
This solution helps evaluate creator or channel health over time by analyzing audience activity patterns, not just subscriber counts.
General Viewer / Fan:
This solution helps save meaningful comments from favorite videos as a personal archive of community interactions and memories.
🔥 See below under 'HOW' to get started. 🔥
Last updated: October 2025
By installing or using this add-on, you agree to these Terms. If you do not agree, do not use the add-on.
You receive a limited, non-exclusive, non-transferable license to use the add-on and its materials for personal, non-commercial use only.
You may not sell, sublicense, publicly host as a paid service, or otherwise use the add-on commercially. You may not copy, modify, distribute, reverse-engineer, or remove notices from the add-on or its materials.
If you violate these rules, your license ends, and you must delete all copies in your control.
Do not:
Bypass API quotas or rate limits, or republish outputs at scale.
Probe, disrupt, or attack security or access you’re not entitled to.
Use the add-on or its outputs in ways that violate laws or third-party rights.
The add-on requests only the Google permissions needed to provide its features. The developer does not sell your data and shares it only with service providers necessary to operate the add-on (if any are used), consistent with the Privacy Policy. Minimal operational logs may be kept only as long as needed for functionality or legal obligations and are then deleted as described in the Privacy Policy.
Privacy Policy:https://www.tostaygrateful.com/ContentCuratorForYouTube#h.bsgtb89c8e33
You can delete any add-on-created sheets or the entire spreadsheet at any time; doing so deletes the data in those sheets from your Google account.
You can uninstall the add-on or revoke its permissions in your Google Account to stop further access and processing.
You may request deletion or raise questions using the contact method in the Privacy Policy.
Your use must comply with:
YouTube Terms of Service and YouTube API Services Terms and Policies (including the Limited Use policy).
Google Workspace Marketplace policies.
If those policies change, you must follow the updated versions.
Features may change, update automatically, pause, or end. Availability can be affected by API quotas, rate limits, platform changes, or outages.
The add-on and its materials are provided “as is.” No warranties—express or implied—are given, including for accuracy, reliability, or fitness for a particular purpose.
To the maximum extent permitted by law, the developer is not liable for any indirect, incidental, special, consequential, exemplary, or punitive damages, or for lost profits, revenues, or data, arising from your use of—or inability to use—the add-on or its materials, even if advised of the possibility of such damages. Where liability cannot be excluded, it is limited to the amount you paid (if any) for the add-on.
Nothing in these Terms limits your non-waivable consumer rights under laws that apply to you (e.g., EU/UK/AU/CA). Liability is not excluded where exclusion would be unlawful (e.g., for fraud).
All rights are reserved. If you believe content infringes your rights, contact the developer using the details on the Privacy Policy page and include enough information to locate and assess the material. The developer may disable or remove content while reviewing.
Translations are provided for convenience. The English version controls in case of any conflict.
These Terms may be updated at any time. If you continue using the add-on after changes take effect, you accept the updated Terms.
These Terms are governed by U.S. law. If any part conflicts with mandatory law in your country, it will be adjusted only as needed to comply, and the rest remains in effect. Where allowed, disputes may be brought in your local small-claims court.
For questions, requests, or feedback, use the contact method on the Privacy Policy page.
Attribution: YouTube is a trademark of Google LLC. This add-on is not affiliated with or endorsed by YouTube or Google.
This quick and anonymous 5-question form includes an option to get answers to your questions or submit a question.
Privacy Policy — Content Curator for YouTube™ (Google Sheets add-on)
Last updated: October 2025
Summary
The developer does not collect, store, sell, or share your personal information. If this changes in the future, this notice will be updated before any collection begins.
What the add-on does with your data
The add-on runs within your Google account context. It processes YouTube API responses and writes results only to your Google Sheet in your account.
No data is sent to developer-controlled servers.
Permissions
The add-on requests only the Google and YouTube permissions needed to deliver its features. You can revoke access at any time in your Google Account permissions.
How to uninstall: Open a Google file → Extensions → Add-ons → Manage add-ons → (Find App: Content Curator for YouTube™) → ⋮ → Uninstall.
Data collection
The developer does not collect your information.
Sharing data with third parties
None. The developer does not sell, share, or transfer your data to third parties.
Cookies
No cookies are used by this add-on.
Security
Because the developer does not receive or store your data, there is no developer-side retention. Your data remains inside Google services under your account. Keep your Google account and spreadsheets secure (e.g., strong passwords, 2-step verification, careful sharing settings).
External links
Documentation or support pages may link to external sites for convenience.
Analytics (documentation/website only)
Only Google Analytics is enabled—and only on public documentation/support pages—to understand high-level, aggregated usage such as total installs/downloads (as reported by Google), page views, and general engagement trends. No personal data from the add-on or your spreadsheets is sent to analytics.
Compliance with YouTube/Google policies
Your use must follow the YouTube Terms of Service, YouTube API Services Terms and Policies (including the Limited Use policy), and Google Workspace policies.
Your choices
Uninstall or revoke permissions: You can uninstall the add-on or revoke its access in your Google Account at any time.
Delete data in Sheets: Deleting any add-on-created sheet (or the entire spreadsheet) deletes the data contained there from your Google account.
Questions or requests: Use the contact method provided on the documentation/support page.
Children’s privacy
This add-on is not directed to children and should not be used by individuals where applicable law requires parental consent without such consent.
Changes to this policy
If this policy changes—for example, if the developer begins collecting or using information—this page will be updated prior to any new processing taking effect.
Translations
Translations are provided for convenience. The English version controls in case of any conflict.
Attribution: YouTube is a trademark of Google LLC. This add-on is not affiliated with or endorsed by YouTube or Google.
This quick and anonymous 5-question form includes an option to get answers to your questions or submit a question.
Last updated: October 2025
This quick and anonymous 5-question form includes an option to get answers to your questions or submit a question.
You can also get answers to your questions by asking asking this on-demand AI model I created within ChatGPT.
NOTE: this is the only way to get support at the moment.