30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights

on YouTube ↗51m

" summary

Demo shows concrete tools and results: a BigQuery data connector beta and a Salesforce add-on that can embed Sheets into Salesforce, macros and Apps Script triggers that convert nightly CSV drops into Sheets, checkboxes and row/column grouping, filter views and preview Slicers for dashboards, and scale plans from two million to five million cells. Case studies cite Avery Dennison saving thousands by replacing outsourced surveys and Prato automating daily imports and dashboards that now update each morning.

AI-written summary · about

" chapters (13)

1. 0:00Intro
2. 1:21Agenda
3. 1:39Analytical Workflow
4. 2:42Importing Data
5. 10:08Preparing Data
6. 13:47Recording Macros
7. 17:00Analyze Data
8. 24:11Demo
9. 29:26Sharing
10. 31:11Comments
11. 43:26Mobile Apps
12. 44:46Example
13. 47:21Sneak Peek

" related talks

• 25mUnlocking key metrics and patterns using GrafanaSyed Usman Ahmad · SREday London 2024
• 32mWork Less and Do More: Google Sheets for JavaScript DevelopersFranziska Hinkelmann, Leah Cole · Node+JS Interactive 2019
• 22mAutomating Custom Reports from JIRA to GoogleSheetsVladymyr Prymakov · QA Fest 2015
• 49mUnlocking Key Metrics and Patterns Using GrafanaUsman Ahmad · DevDays Europe 2024
• 41mUsing Google Data (now Looker) Studio for Dashboard Analytics ReportingJeffrey S. Danielewicz · DrupalCamp NJ 2023
• 17mHow to build apps with AppSheet and Apps Script ConnectorChristian Schalk · Google I/O 2022
• 34mIntegrate Google Workspace with your solutionsCharles Maxson, Olaf Hubel, Matthew Izatt, Steven Bazyl · Google I/O 2021
• 33mWork Less and Do More: Sheets for Node.js DevelopersFranziska Hinkelmann, Anu Srivastava · Google I/O 2019