Sheets Insiders is no active. Here is the first year of the Sheets Insiders content archive.
Content Archive
📌 Sheets Insiders 43: The last one… (4 September 2025)
- Thank you!
- An amazing SCAN formula + conditional formatting trick
- Sheets Insiders Highlights
📌 Sheets Insiders 42: Build Your Own Custom Apps for Google Sheets (28 August 2025)
- Build custom Sheets apps with Gemini AI
- Improved Notes app with logs, search feature, and hashtags
📌 Sheets Insiders 41: Imitation as a shortcut to mastery in Sheets (21 August 2025)
- Recreate Tools or Websites for Inspiration
- Design: columns, whitespace, fonts, borders, dropdowns, IMAGE function, gridlines
- Data: IMPORTHTML, LET, XMATCH, XLOOKUP, Named Functions, Image buttons with scripts
📌 Sheets Insiders 40: A Fundamental Apps Script Lesson (14 August 2025)
- Understanding one of the most difficult concepts of Apps Script, the order of operations
- Concept of server side, batching UI updates
- Spreadsheet flush method to control order
📌 Sheets Insiders 39: The AI Function in Google Sheets (7 August 2025)
- How to use the AI Function
- 10 real-world examples with the AI Function
- Who has access
- What it can’t do
📌 Sheets Insiders 38: Using Google Sheets Tables with Apps Script (31 July 2025)
- How to use Tables with Apps Script
- Introduction to Advanced Services
- Introduction to the Sheets API
📌 Sheets Insiders 37: Introduction to Looker Studio (24 July 2025)
- What is Looker Studio?
- Benefits of Looker Studio
- Looker Studio chart tutorial
📌 Sheets Insiders 36: More reader tips (17 July 2025)
- Named Functions
- Data Validation
- Build Strings With Formulas
- And more…
📌 Sheets Insiders 35: Reader Ideas! (10 July 2025)
- Highlight incomplete rows
- Global commenting system
- Filter with partial matching
- Dynamic SUM
- And more…
📌 Sheets Insiders 34: Over to you! (3 July 2025)
- Submit Your Favorite Tip
📌 Sheets Insiders 33: The era of homemade add-ons / 3-D Formula References (26 June 2025)
- 3D references formula in Google Sheets
- How to build a sidebar add-on to do 3D references
- Era of homemade add-ons
📌 Sheets Insiders 32: Conditional Notifications (19 June 2025)
- Conditional Notifications in Google Sheets
- How to set up and use conditional notifications
- How to build your own version with Apps Script, if you don’t have access
📌 Sheets Insiders 31: Arrays are a key skill for advanced formulas (12 June 2025)
- How to create arrays in Google Sheets with curly brackets { }
- How to combine formulas with arrays
- Examples of useful formula combinations using arrays
- Sparkline with text overlay formula
📌 Sheets Insiders 30: Custom actions using Gems from the Google Sheets sidebar (5 June 2025)
- Access custom Gems from the Gemini sidebar in Google Sheets
- How to build a Gems with custom instructions
- How built a Gem to generate sparkline formulas from description
📌 Sheets Insiders 29: Save TIME with this Automated Feedback Tool (15 May 2025)
- Leverage AI to radically speed up time to share to feedback
- Example using Education Data (student scores)
- AI Formula in Sheets, Gemini, and Apps Script automation
📌 Sheets Insiders 28: Roadmap, learning pathways, and CHOOSECOLS trick (8 May 2025)
- Membership roadmap
- Learning pathways for existing member content
- A delightful CHOOSECOLS trick
📌 Sheets Insiders 27: Use Apps Script To Build Utility Tools (1 May 2025)
- Extract URLs from rich text cells with script
- Make plain text links clickable in bulk
- Using Apps Script & AI tools to create utility scripts
📌 Sheets Insiders 26: Undocumented Functions (23 April 2025)
- Undocumented Functions in Google Sheets
- CONDITION_ONE_OF_RANGE Function
- STRICT Date and Time Functions
- REFERENCE Function
- Easter Egg Functions
📌 Sheets Insiders 25: Two Huge Workspace Announcements from the Google Cloud Conference (17 April 2025)
- Google Workspace Flows
- Help Me Analyze in Google Sheets
📌 Sheets Insiders 24: Intermediate Skills Workshop (27 March 2025)
- ⭐ Live session replay
- Key data techniques
- Benefits of Tables
- LEFT, MID, DATE, IMPORTRANGE, XLOOKUP
- Killer pivot table tricks
📌 Sheets Insiders 23: Apps Script Vibe Coding 😎 (20 March 2025)
- Upcoming workshop registration
- What is vibe coding?
- Vibe coding experiment with Google Apps Script
- Build a color counting automation in Sheets
📌 Sheets Insiders 22: NEW FUNCTION ALERT! And, How To Keep Up With AI In 2025 (13 March 2025)
- Sneak peek at the new AI function
- Resources to keep up-to-date with AI
- New workshop announcement
📌 Sheets Insiders 21: Unlocking the Secrets of LAMBDA Functions Workshop Replay (6 March 2025)
- ⭐ Live session replay
- Introduction to LAMBDA Functions
- What they are and how they work
- Demos of LAMBDA, BYROW, MAP, SCAN, and Named Functions
📌 Sheets Insiders 20: Better Charts in Google Sheets Workshop Replay (27 February 2025)
- ⭐ Live session replay
- Introduction to Data Visualization
- 4 key techniques for better charts
- 3 chart demos to illustrate how these work
📌 Sheets Insiders 19: Future of spreadsheets + IMPORT example (20 February 2025)
- Using OpenAI’s Deep Research to write a whitepaper on the future of the spreadsheet industry
- IMPORT formula to grab all the Sheets Insiders links on this page
📌 Sheets Insiders 18: Advanced Chart Tutorial (13 February 2025)
- Combo chart with columns and area
- How to use data to create advanced charts
- Sinusoidal curve formulas 🤓
📌 Sheets Insiders 17: Brainpower still matters… for now (6 February 2025)
- Cautionary tale of how AI can still make mistakes with relatively simple data tasks
- How to solve using SPLIT, TOCOL and QUERY
📌 Sheets Insiders 16: Beginner Apps Script workshop 3 (30 January 2025)
- ⭐ Live session replay (workshop 3)
- How the MAP function works in Apps Script
- How to publish Internal Adds Ons to share scripts throughout your organization
📌 Sheets Insiders 15: Beginner Apps Script workshop 2 (23 January 2025)
- ⭐ Live session replay (workshop 2)
- How to design and code with AI tools and Apps Script
- Building our Table of Contents tool with Apps Script and AI
📌 Sheets Insiders 14: Beginner Apps Script workshop (16 January 2025)
- ⭐ Live session replay (workshop 1)
- Best way to learn Apps Script in 2025
- How to approach problems
- How to leverage AI to accelerate learning path
📌 Sheets Insiders 13 (9 January 2025)
- Resources and reads on spreadsheets and AI
📌 Sheets Insiders 12: Holiday Formula Challenge (19 December 2024)
- January Schedule for the upcoming Apps Script workshops
- Holiday formula challenge with dates and the SEQUENCE formula
📌 Sheets Insiders 11: The Year in Sheets (12 December 2024)
- Rundown of all Google Sheets feature releases during 2024
📌 Sheets Insiders 10: Table Formulas + Combo Chart (5 December 2024)
- How to use Tables formulas and benefits
- How to create combo charts
- How to add labels to charts
📌 Sheets Insiders 9: Modern Analytical Functions Part II (21 November 2024)
- ⭐ Live session replay
- HSTACK and VSTACK examples
- BYROW and LAMBDA
- Bonus SPARKLINE trick with HSTACK
📌 Sheets Insiders #8: Modern Analytical Functions (14 November 2024)
- How to use HSTACK and VSTACK
- How to create default values in cells
- How to work with multi-select dropdowns and database functions
📌 Sheets Insiders #7: Database Functions (7 November 2024)
- ⭐ Live session replay
- How to use Database Functions
- Advanced criteria options
📌 Sheets Insiders #6: Tables (31 October 2024)
- Benefits of Tables
- How to use Structured Table References in formulas
- Advanced Tables formulas
📌 Sheets Insiders #5: Dropdowns (24 October 2024)
- Automatic dropdowns
- Multi-select dropdowns
- Dependent dropdowns with formulas and Apps Script
📌 Sheets Insiders #4: AI Experiments (17 October 2024)
- Three AI tools: Gemini, ChatGPT, and Julius
- Prompting tips
- Data analysis experiments
- Formula generation
📌 Sheets Insiders #3: User Interface Template (10 October 2024)
- Built-in methods like checkboxes and dropdown menus
- Specialized use cases with Apps Script
- Experimental methods using formulas and clever formatting tricks
📌 Sheets Insiders #2: Chart Tutorial (3 October 2024)
- Why series (columns) of data are KEY to building charts
- How to use “filler” bars to float data
- How to use formatting and drawings to make your charts visually pop!
📌 Sheets Insiders #1: Visual Vocabulary Template (26 Sep 2024)
- Google Sheets Visual Vocabulary template
- Design tips
- Show/hide technique for dashboards