In this we will see how we can get latitude and longitude of a location using Google Apps Script. I was working on a use case where i was trying to link Charts created in Google sheet with Google slide such that the charts gets updated automatically when the data in the sheet changed. But […]
Find and Replace in Google Apps Script
Here in this post we will see how we can create a find and replace function in Google apps script. This function will find a particular searched string or value and replace it with the desired value. Google Apps Script code : Let’ see how code for Find and Replace works in Google Apps Script. […]
Getting Spreadsheet creation and modification date using GAS
When you are working as an Analyst, your main part of the job is to create reports with important KPI which help business to understand in detail about how their business is performing. Also performing automation or creating automated reports are one more task. While working and automating Google Spreadsheet, you have come across a […]
Navigate from one Google Sheet to another using GAS
When you are building a toolkit or a dashboard in Google sheets you have came across a situation where you want to navigate from one google sheet to another on a button click. Here in this post we will see how you can navigate or move from one google sheet to another using Google Apps […]
Google Apps Script to search a string in a column in Google Sheet [Part 1]
Searching a string in a google sheet is easy when you search it manually using Ctrl+F and enter the string. But what if you want to automate the task and search the string to perform dependent task, the Google Apps Script is there for your rescue. I came across a situation where i have to […]
Regular Expression in Google Apps Script
I believe we all have used Regular Expression while working on different projects in different languages. Basically we Regular Expressions to match a pattern of characters. Here in this post we will see how you can define Regular Expression in Google Apps Script. Importance of Regular Expression(RegEx) and why you should learn: RegEx helps you […]