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.:
One-time setup (3 steps)
STEP #1 — Copy the 'Let’s Start Here' template.
This is how:
1. Get the template by clicking here.
2. On the top menu click on File → Make a copy → Name it → Make a Copy.
STEP #2 — Install the hybrid AI tool:
This is how:
Got to 'Extensions' → Add-ons → Get add-ons → On top type 'Content Curator For YouTube' → Click on ‘Install’
Follow the prompts until it's installed and you see these 2: the tool name & the tool icon.
3. STEP #3 — [ OPTIONAL ] Save your preferred ML provider.
NOTE: This is an optional step. The script will still work without it. If you want to use ML, this is how:
Click on the tool icon on the Google sidebar → ML Settings → Select your ML provider → Continue → Enter your ML settings → Test → Save.
Demo
Start using this hybrid AI tool. This is how:
1. While on ‘Let’s Start Here’ sheet → Go to Section 1 → Complete Selections → Click on Start.
This is a 5-minute demo on how to use this solution:
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.
This AI tool 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).
▼
2026, April 🠆 RELEASE 🠆 13k lines of code 🠆 Google to approve the global release of this solution as a Sheets add-on via Google Workspace Marketplace.
▼
2026, May? 🠆 VERSION #2 🠆 18k lines of code 🠆 Added and optimized 2 features:
An optional Machine Learning (ML) feature to help review neutral comments using your preferred ML provider: Google Natural Language, Azure Text Analytics or AWS Comprehend.
Comment translation using Google Translate, so you can translate comments into nearly 250 languages in seconds.
▼
2026, July? 🠆 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.
Other ways to acknowledge others:
Working on adding more ideas here
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: May 2026
Acceptance of Terms
By installing or using this add-on, you agree to these Terms. If you do not agree, do not use the add-on.
License (Personal Use Only)
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.
Acceptable Use
Do not:
Bypass API quotas or rate limits, or republish outputs at scale.
Probe, disrupt, or attack security or access you are not entitled to.
Use the add-on or its outputs in ways that violate laws, platform rules, or third-party rights.
Use the add-on to process, export, or reuse YouTube data in ways that violate YouTube, Google, or optional ML provider rules.
Submit content to optional ML providers unless you have the right to process that content and accept that provider’s terms.
Data & Privacy
The add-on requests only the Google and YouTube permissions needed to provide its features.
The add-on runs in your Google account context and writes results, logs, charts, helper sheets, and run state into your spreadsheet or Google-managed properties connected to the add-on.
The developer does not sell your data.
The developer does not send your spreadsheet data or YouTube outputs to developer-controlled servers.
If you choose “Use ML,” the add-on may send selected comment text or related text directly to the ML provider you selected and configured. This may include providers such as Google Natural Language, Azure Text Analytics, AWS Comprehend, IBM Watson NLU, Hugging Face, or Oracle OCI AI Language.
Those providers process data under their own terms, privacy policies, quotas, pricing, and security practices.
Privacy Policy: https://www.tostaygrateful.com/ContentCuratorForYouTube#h.bsgtb89c8e33
Optional ML Providers
ML features are optional.
If you do not select “Use ML,” the add-on uses its built-in non-ML logic for sentiment classification.
If you select “Use ML,” you are responsible for the provider account, API key, endpoint, region, charges, quotas, terms, and permissions connected to that provider.
The add-on may save your selected ML provider and provider settings in Google DocumentProperties tied to the spreadsheet so the add-on can run without asking for the same setup each time.
You can clear provider settings, revoke provider keys, uninstall the add-on, or revoke Google permissions when you no longer want ML processing.
AI, ML, Translation, Charts, and Output Accuracy
Outputs are informational.
Sentiment labels, translations, rankings, charts, summaries, and classifications may be incomplete, delayed, inaccurate, or affected by YouTube API data, provider results, quota limits, language differences, and spreadsheet settings.
Review important results before relying on them.
Your Controls
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 clear saved ML provider settings if you no longer want the add-on to use them.
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.
YouTube, Google, and Provider Policies
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.
The terms and policies of any optional ML provider you choose to use.
If those policies change, you must follow the updated versions.
Service Changes & Availability
Features may change, update automatically, pause, or end.
Availability can be affected by API quotas, rate limits, Google changes, YouTube changes, optional ML provider changes, platform outages, or provider outages.
No Warranties
The add-on and its materials are provided “as is.”
No warranties are given, including for accuracy, reliability, availability, security, completeness, sentiment quality, translation quality, chart quality, or fitness for a particular purpose.
Limitation of Liability
To the maximum extent permitted by law, the developer is not responsible for indirect, incidental, special, consequential, exemplary, or punitive damages, or for lost profits, revenues, data, access, provider credits, API quota, or business opportunities arising from your use of—or inability to use—the add-on or its materials.
Where liability cannot be excluded, it is limited to the amount you paid, if any, for the add-on.
Consumer Rights (Global Users)
Nothing in these Terms limits rights that cannot be waived under laws that apply to you.
If a rule in these Terms conflicts with a mandatory local consumer protection rule, the local rule applies only to the extent required, and the rest of these Terms still apply.
Intellectual Property & Takedowns
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
Translations are provided for convenience.
The English version controls if there is a conflict.
Updates to These Terms
These Terms may be updated at any time.
If you continue using the add-on after changes take effect, you accept the updated Terms.
Governing Law
These Terms are governed by U.S. law, unless a mandatory law in your country says otherwise.
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.
Support & Questions
For questions, requests, deletion questions, or feedback, use the contact method on the Privacy Policy page or the support form linked from the documentation/support 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: May 2026
Summary
The developer does not sell your personal information.
The developer does not send your spreadsheet data, YouTube outputs, comments, logs, charts, or generated sheets to developer-controlled servers.
The add-on runs in your Google account context.
If you choose “Use ML,” selected text may be sent directly to the ML provider you selected and configured. That provider processes the data under its own terms and privacy policy.
If this policy changes in a way that affects collection or processing, this notice will be updated before the new processing begins.
What the add-on does with your data
The add-on processes YouTube API responses, video metadata, comment data, configuration inputs, language selections, sentiment settings, and run state so it can build results in your Google Sheet.
The add-on writes results only to your spreadsheet, such as DONE sheets, IN PROGRESS sheets, STOPPED sheets, log sheets, graph/helper sheets, language helper sheets, cache/state sheets, and LastState-style recovery sheets.
The add-on may store run state in Google-managed properties so it can resume safely, avoid duplicate work, remember settings, restore state, and avoid writing to the wrong sheet.
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 Content Curator for YouTube™ → ⋮ → Uninstall.
Data stored in Google Sheets and Google Properties
The add-on may store output data and operational data in your spreadsheet, including results, logs, charts, helper sheets, state sheets, and cache sheets.
The add-on may use ScriptProperties, DocumentProperties, and UserProperties to store add-on state, such as run progress, sheet bindings, path signatures, cache proofs, startup checks, selected ML provider, provider settings, pending translation selections, and Quick Start display count.
These values are used to keep the add-on working, resume safely, reduce repeated setup, and protect cross-channel or cross-sheet runs.
Optional ML processing
ML processing is optional.
If C12 is blank or set to “Don’t use ML,” the add-on uses built-in non-ML logic.
If C12 is set to “Use ML,” the add-on may send selected comment text or related text directly to the ML provider you selected and configured.
Supported provider options may include Google Natural Language, Azure Text Analytics and AWS Comprehend.
The developer does not control those providers’ processing, retention, security, pricing, quotas, or privacy practices.
Review the provider’s terms and privacy policy before enabling that provider.
Provider settings and API keys
If you configure an ML provider, the add-on may save provider settings in Google DocumentProperties tied to the spreadsheet.
Those settings may include provider name, endpoint, region, API key, or other configuration values needed to call the provider.
You are responsible for securing your spreadsheet, limiting who can access it, managing provider keys, monitoring provider usage, and revoking keys when needed.
Data collection by the developer
The developer does not collect your spreadsheet data, YouTube outputs, comments, provider keys, ML results, generated sheets, or add-on logs on developer-controlled servers.
The developer may receive information only if you choose to send it through a support form, email, feedback form, or other contact method.
Sharing data with third parties
The developer does not sell your data.
The developer does not share your spreadsheet data with third parties from developer-controlled servers.
If you enable optional ML, the add-on sends selected text directly from the add-on to the ML provider you selected and configured.
External providers, Google services, YouTube services, and public documentation/support pages operate under their own terms and privacy policies.
Cookies
No cookies are used by the add-on itself.
Public documentation or support pages may use cookies or similar technologies if enabled by the website or analytics tools used on those pages.
Security
Because the add-on runs in your Google account context, your data remains mainly inside Google services and your spreadsheet unless you enable optional ML provider processing.
Keep your Google account, spreadsheet, sharing settings, and provider API keys secure.
Use strong passwords, 2-step verification, limited sharing, and provider key rotation where appropriate.
Retention
Data written to your spreadsheet stays there until you delete it.
Google Properties used by the add-on may remain until they are reset, cleared by the add-on, removed by uninstall/revocation where applicable, or no longer needed for the add-on’s operation.
Optional ML providers may retain data according to their own policies.
The developer does not keep a separate developer-side copy of your spreadsheet data or add-on outputs.
External links
Documentation, support pages, Quick Start videos, ML setup videos, templates, and provider-related pages may link to external sites for convenience.
Those external sites are not controlled by the add-on and may have their own terms, privacy policies, cookies, analytics, or data practices.
Analytics (documentation/website only)
Google Analytics may be enabled only on public documentation/support pages to understand high-level, aggregated website usage, such as page views and general engagement trends.
No personal data from the add-on or your spreadsheets is sent to website analytics by the add-on.
Compliance with YouTube, Google, and Provider Policies
Your use must follow YouTube Terms of Service, YouTube API Services Terms and Policies, including the Limited Use policy, Google Workspace policies, and any optional ML provider terms that apply to the provider you choose.
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.
Clear ML settings: You can clear saved ML provider settings or revoke provider API keys if you no longer want optional ML processing.
Do not use ML: Leave C12 blank or select “Don’t use ML” to avoid optional ML provider processing.
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.
Global users
This add-on may be used by people in different countries.
Your local privacy and consumer rights may apply depending on where you live.
Nothing in this policy is intended to reduce rights that cannot be waived under laws that apply to you.
Changes to this policy
If this policy changes—for example, if the developer begins collecting, storing, sharing, or using information in a new way—this page will be updated before the new processing takes effect.
Translations
Translations are provided for convenience.
The English version controls if there is a 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: May 2026
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.