Skip to the content
AppsScript LAB logo with gradient curly braces and bold text in a pink-to-orange gradient

Welcome! Just sharing some stuff I build with Apps Script, tips, tutorials, and whatever else I find useful


  • Home
  • Apps Script Development
  • Google Sheets
  • Workspace Automation
  • Google Cloud & BigQuery
  • Developer Workflow
  • Workspace Tips
  • All posts

Topics

APIs Backend Development BigQuery CacheService CI/CD clasp Cloud Run Data Validation Debugging Google Calendar Google Cloud Logging Google Docs Google Forms Google Sheets API Google Workspace Add-ons Logging OAuth2 Performance Reusable Components Service Accounts Sheets Performance Unit Testing UrlFetchApp Web Apps Xero

© 2026 Lidia Ribeiro

Google Sheets

Guides to Google Sheets functionality, performance and advanced spreadsheet techniques. Explore the articles below.

  • Conditional Formatting in Google Sheets (Simple Guide)
  • Filter by a Dropdown in Google Sheets (Data Validation + QUERY)
  • Solving Slow Google Sheets: Boost Performance with Smart Tricks and Automation
  • How to Create Dependent Drop-Down Lists in Google Sheets (Dynamic Cascading Drop-Downs)
  • Fix Chart Color Shuffle in Google Sheets using the Sheets API
  • How to Push Big Datasets into Google Sheets with Apps Script (Without Crashing!)
Twitter Reddit LinkedIn