Welcome !

In this video I am going to show you how to create PDF’s from a Google Sheet using Google Apps Script. We are going to use the following fictitious example:

  • Teacher intends to create custom mark sheets.
  • Doing it manually will be an hectic task

In this video we will be tackling this issue using some Google Apps Script.

So let’s get started.

Do let me know what else you would like to learn about the same and I will be happy to cover that in future sessions.

Do write to me on aryanirani123@gmail.com with your feedback and comments.


Welcome !

In this blog I am going to show you how to run your Google Apps Script in 3 ways.

So let’s get started.

We are going to run our Google Apps Script in the following 3 ways:

(1) Using custom menus : With a few lines of code we are going to create custom menus to run specified functions

(2) Macros : We are going to create macros and assign the function to it. To run a macro, we will specify the shortcut that we are going to use.

(3) Insert Images : Here we are going to…


Welcome !

In this video I am going to show you how to Add math equations to Google Form Using a Google Chrome Extension.

In this video I have used the following test case:

(1) A math test is coming up for the students, and the teacher wants to add equations and formulas to the Google Form.

(2) Normally the teacher used to type out the question, but that has caused too many issues with the students(students cannot understand the typed out question).

So in my video we will solve this problem using a simple Google Chrome extension. If you…


Welcome !

In this blog I am going to show you how to limit responses in Google Forms using Google Apps Script. We are going to use the following fictitious example:

  • But the hall that we have booked has a max capacity of 100 people.
  • People can register for the workshop through a Google Form.
  • The organising Team wants to make sure that there are only 100 responses in the Google Form.

So let’s get started.

If you need to refresh your knowledge on using Google Forms, click on the link given below.

Step1: Sample Google Form


Welcome to the next post in the Google Classroom Tutorial series.

In this video I am going to show you how to assign Special Assignments to particular students using Google Classroom.

Sometimes in a class 2 or 3 students might fail the test, and the might have to assign special assignments or tests to each student. So in my video you will learn how you as a teacher can assign individual assignments to students.

If you are a teacher interested in Google Classroom, please share your feedback on the video series. Do let me know what else you would like to learn about the same and I will be happy to cover that in future sessions.

Do write to me on aryanirani123@gmail.com with you feedback and comments.


Welcome !

In this blog we are going to play with some txt files using python. I am going to be doing the following 3 example:

(1) Print the number of lines in the txt file
(2) Print the count of each word in the file
(3) Print the line number next to each line in the file

So let’s get started.

Print the number of lines in the txt file

This is the first example that I will be explaining. This the output that we have to achieve in the end.


Welcome !

In this blog I am going to show you how to restrict responses for each option in Google Forms. We are going to do this using some basic Google Sheets formulas and a Google Form Add-on called FormRanger.

So let’s get started.

If you need to refresh your knowledge on using Google Forms, click on the link given below.

Step 1 : Sample Google Form

The form that I will be using is a Simple Session registration form . (If you prefer working with a copy of the Google Form, click here)

This form contains the following:

  • Email address of…


Welcome to the No-Code Apps with Google AppSheet Tutorial Series.

So what is Google AppSheet ?

Google AppSheet is a No-Code application development platform that allows users to create mobile, tablet and web applications from data sources like Google Drive, Office 365 .

Why do people prefer no-code app development platforms ?

Yes, people do prefer No-Code app development platforms. They find it appealing because it is easy to use and also allows non-programmers to pump out apps.

In this series I will show you how to create simple apps using Google AppSheet.

  1. Create an Inventory Management App Using Google AppSheet…


Welcome !

In the last blog we learnt how to create the app and also made our first service order . In this blog I am going to show you how to filer data for specific users , where the manager of the service centre should be able to see the data of all users .

So let’s get started.

Step 1 : Add the Third Sheet


Welcome !

In this blog I am going to show you how to create a Vehicle Inspection App using Google AppSheet . In this app the user can place a service for his car by filling out a form. This app will have the following features:

(1) The user can place a service order.
(2) Filter data for specific users. Manager of the service centre should be able to see data of all users.

This blog is divided into two parts:

(1) The first part will show you how to create and setup the app, followed by placing our first…

Aryan Irani

Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student. Created a course on Google Classroom

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store