Alternate Row Shading In Google Sheets

This article shows you how to apply shading to every alternate row in a google sheet. You can apply the shading by using Alternating Colors Feature or simple conditional formatting formula. Alternatively, you can use Google app script to apply colors to ...

Get YouTube Analytics Data With Google Apps Script

This article explain here steps to configure Google Sheet and Apps Script to get Youtube Analytics data like views, subscribersGained, estimatedRevenue, grossRevenue, cpm etc for all videos uploaded for the linked channel account. https://www.youtube.com ...

Managing Files in Google Drive App

This tutorial is basically about Google Drive App Script. Firstly, App Script is basically Javascript in the cloud, you can write your own Javascript code and have it run on Google cloud and access Google services. App Script is javascript so you p ...

Google Apps Script to create and delete folder

First of all, I would like to tell you this article is about Google Apps Script. Here, I am going to show you here how you can use Google apps script to create and delete folders from Drive. Firstly, create a new folder in the root folder of ...

Inserting check boxes in Google sheets

A checkbox that permits the user can create binary choice. Like user can select choice between two options; options are yes or No. Checkboxes in Google Sheets is a new feature; You can add boxes to cells in a spreadsheet easily.  Checkboxes have shown as ...

Remove Duplicates Google Sheets With App Script

Firstly In this article, you can learn how you Remove Duplicate Google Sheets with the help of App script. So, this article explains how you can write a simple script in google sheets to remove duplicate entries.Therefore, large spreadsheets sometimes ma ...

Google Script To Extract Text from PDF

In this article, you can read how you can Google script to extract text from PDF. Google Script can be used to extract text from a pdf document. And retain simple formatting. You can have the pdf in google drive folder or can be accessed from web URL. ...

Create Table in Google Doc Using Google Apps Script

Here we will learn how to create a table inside a Google document using Google apps script, This is a straightforward code which creates a table in Google Document. We need to write a function. Likewise, I have created a function and called this createTa ...