Posts

How to Store Secrets in Google Apps Script

11 Aug, 2023
- Google Apps Script
- security

[Updated: March 2024] Explore the multiple methods and practical considerations for securely storing your secrets (passwords, API keys, etc.) in Google Apps Script.

Flexible Color-Coding System in Google Sheets

30 Jul, 2023

Learn to create a flexible color-coding system in Google Sheets. Make data easy to understand and use.

Do Not Share Documents via Public Link: Do This Instead

24 Jul, 2023

Examine the security risks of sharing documents via a public link and learn about safer alternatives for better access control and data privacy.

Authorization Scopes in Google Apps Script: Convenience vs. Security

19 Jul, 2023
- Google Apps Script
- security

Learn how to set authorization scopes in Google Apps Script, understanding the balance between functionality and security, and how to shift from automatic to manual scope setting for optimal control.

How to Manage Authorization Scopes in Google Apps Script

16 Jul, 2023
- Google Apps Script
- security

Keep your data safe by learning how to manage authorization scopes in Google Apps Scripts.

Sizing Named Ranges: Tips and Best Practices

09 Jul, 2023

Despite their simplicity, named ranges are a very powerful feature in Google Sheets. To extract maximum utility from them and sidestep common pitfalls, it’s crucial to appropriately size the ranges.

How to Unpivot Data in Google Sheets

05 Jul, 2023

This post demonstrates how to effectively transform tabular data into an analysis-friendly format in Google Sheets by unpivoting it with the help of powerful formulas and named functions.