@kdk
Programmer, Content Creator and Apprentice Entrepreneur
I am no longer publishing through HashNode. I have started my own publication Script Portal: https://medium.com/script-portal.
You can also find my video tutorials on my coding Channel: Coding With Nibesh: https://www.youtube.com/@codingWithNibesh
Google Apps Script automation tasks, create google workspace add-ons for Gmail, Sheets, Docs, etc.
Feb 23, 2024 · 6 min read · As part of the Google CASA process, developers can run static analysis on their application’s source code using an inline integration with OpenText’s Fortify Source Code Analyzer (SCA) via the CASA portal. Naturally, I had to prepare my source code a...
Join discussion
Feb 9, 2024 · 23 min read · Have you ever struggled with navigating a massive spreadsheet? You can do away with the endless scrolling and unlock the power of targeted data retrieval with a custom search form using Google Apps Script. In this hands-on guide, we'll craft a searc...
Join discussion
Sep 7, 2023 · 8 min read · In this tutorial, you will learn how to remove empty rows and columns from Google Sheets using Google Apps Script. A while ago I wrote an article on how to remove empty rows and columns from Google Sheets. I recently revisited that article and I now...
Join discussion
Jul 20, 2023 · 11 min read · Welcome to this tutorial on how to integrate ChatGPT with Google Spreadsheets using the GPT API and Google Apps Script. We will create two custom formulas, GPT_SUMMARY and GPT_SIMPLIFY. You can use GPT_SUMMARY to summarize a large passage or text int...
Join discussion
Jun 5, 2023 · 2 min read · Hello!, I wrote a blog on finding the last non-empty rows a couple of months ago. Since then, I have found a better, faster, and easier method, which works in most cases. Find the Last Row & Column You can copy and paste one of the following function...
Join discussion
