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 […]
Loop over two list or array in Google Apps Script
If you loves working on Google suits, i am sure you work on Google Apps script which is based on JavaScript. While working on Google Apps Script (GAS) you have came across situation where you have two list or array and you want to loop over each item one by one. Here in this post […]
Unzip files using Google Apps Script on Google Drive
Sometime you came across situations where you have the zipped files on the Google drive and you want to automate the process but required unzipped files to do the data manipulation tasks. Here in this post i will share the code which will help you to Unzip files using Google Apps Script placed on Google […]
Google Apps Script Code to find the days of the week
Google Apps Script is no doubt the best when you are trying to automate the boring stuffs that you do on day to day basis. Google has created a complete ecosystem including Google Big Query, Google Drive, Google Colab and Google Apps Script by using these you can fully utilize the power of cloud and […]
Automating Python Script to Run at Specific Time Every Day using Windows Task Scheduler
No doubt the 21st century is all about Python, Machine Learning and Artificial Intelligence. While working on these technologies is pretty exciting but there are processes that you perform on a day to day task. Say, for example, downloading a file from a particular location daily for updated content or transferring files from one drive […]