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 […]
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 […]
Find and Copy files of specific types using Google Apps Script
When you want to find and copy files of specific types using Google Apps Script from a folder to another folder on Google Drive, this code for sure will come handy. As you know Google Apps Script has a functionality of running it automatically on a particular time (time driven trigger) or even driven trigger(like […]
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 […]