Analyzing Text Data with Google Sheets and Cloud Natural Language

on YouTube ↗40m

" summary

A working pipeline shows Google Forms feeding a Sheets spreadsheet, Sheets using detectLanguage and TRANSLATE to normalize text, and an Apps Script that triggers on form submit, calls the Cloud Natural Language API for entity extraction with sentiment, and writes results to an entity table; 715 reviews produce about 10,000 entity rows, processed via periodic triggers, and visualized in Data Studio with blended tables; full demo code and a codelab live on GitHub.

AI-written summary · about

" chapters (10)

1. 0:00Introduction and speaker
2. 3:38Scenario and data collection
3. 10:32Cloud Natural Language overview
4. 13:04Apps Script for automation
5. 17:20Preprocessing with Apps Script
6. 20:33Calling Natural Language API
7. 26:42Data visualization in Data Studio
8. 35:00Report customization and sharing
9. 37:10Resources and next steps
10. 38:39Q&A and closing

" related talks

• 59mMachine Learning and Big Data Magic with Node.js and Google CloudBret McGowen, Sara Robinson · NDC Sydney 2017
• 47mBuilding smarter apps with Machine Learning, from magic to realityLaurent Picard · GDG DevFest Poland 2018 in Wrocław
• 29mBetter Understand Your Documents with AIElliott Ning · Global Artificial Intelligence Conference 2020
• 24mText Analytics SimplifiedTrung Diep, Ronald Sujithan · Data By the Bay 2016
• 36mCrash Course in Machine Learning for Natural Language ProcessingAllen O'neil · C# Corner Annual Conference 2022 - Hyderabad
• 06mAdvancements in Natural Language Processing (NLP) and Text AnalyticsNada GabAllah · DSC MENA 2024
• 01h 00mBoost your App with Machine Learning APIsLaurent Picard · ML Conference 2018 Spring
• 37mCorinna Cortes, Head of Research, GoogleCorinna Cortes · MLconf NYC 2015