Dataful.TechAccess Google Cloud Secret Manager via Google Apps ScriptThere are many ways to store secrets, such as tokens, passwords, and API keys, in Google Apps Script, but they are not created equal. Some…2 min read·May 1, 2024----
Dataful.TechHow to Sort by Multiple Columns in Google SheetsYou often need to sort rows by multiple columns simultaneously to review and analyze the data more efficiently. It is easy to do in Google…6 min read·Apr 25, 2024----
Dataful.Tech7 Ways to Sort Data in Google SheetsSorting data in Google Sheets is a common task that can help organize and analyze it. There are multiple ways to sort data in Google…8 min read·Apr 18, 2024----
Dataful.TechHow to Preserve Header Row Position During Sorting in Google SheetsIn this post, we will look at a quick lifehack. If you sort data in Google Sheets via the Main Menu -> Data -> Sort ... as well as the…1 min read·Apr 9, 2024----
Dataful.TechSecretService: Library for Storing Secrets in Google Apps ScriptLeverage SecretService Library for your Google Apps Script projects to securely store secrets.3 min read·Mar 12, 2024----
Dataful.TechDropdowns in Google Sheets: Complete GuideEverything you need to know about dropdowns in Google Sheets6 min read·Feb 6, 2024----
Dataful.TechFILTER function with OR and complex conditionsFILTER is an indispensable and powerful Google Sheets function that allows you to filter data by multiple criteria. By default, all FILTER…4 min read·Jan 3, 2024----
Dataful.TechBoost Your Google Sheets Productivity with the Name BoxGoogle Sheets’ Name box is my favorite time saver of the year. It is situated to the left of the formula box and, by default, shows the…3 min read·Dec 15, 2023----
Dataful.TechPractical Solutions for IMPORTRANGE “Result too large” ErrorOne of the most common issues with IMPORTRANGE in Google Sheets is the “Result too large” error. According to Google’s documentation, this…9 min read·Dec 9, 2023----
Dataful.TechFetchApp: UrlFetchApp with RetriesGoogle Apps Script is often used to pull data from various services via HTTP requests. However, these requests sometimes fail due to…5 min read·Dec 8, 2023----