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 Google Sheet [Part II]
In our last post we have seen how we can use Google Apps Script to search a string in Google Sheet and add n number of rows just after the row in which the string was found. But there is one issues : which is that it won’t loop over all the items that matches […]
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 […]