Summary of 2021 — Aryan Irani

As this amazing year comes to an end, I decided to note down all my blogs, videos in the past year. This has been an amazing year for me academically and professionally.

I have passed all my engineering exams and am in my 3rd year of engineering. I am also constantly helping my college automate internal processes using Google Apps Script and Google Workspace. You can check them out in the blog link given below.

In November, I completed 550 subscribers on YouTube followed by 100 followers of my Medium blog. After around a year of constant blogging and video creation, I reached these numbers.

Here is a collection of all the blogs I have written in the year 2021.

January

1. Create an Inventory management app using Google AppSheet — Part1
2. Create an Inventory management app using Google AppsSheet — Part2
3. Create a Vehicle service app using Google AppSheet — Part 1
4. Create a Vehicle service app using Google AppShet — Part 2
5. Tutorial Series: No-code app using Google AppSheet

February

1. Restricting form responses for each option in Google Forms

March

1. Working with files in python
2. Google Classroom training: Assign special assignments to each student in Google Classroom

April

1. Limit responses in Google Forms using Google Apps Script
2. Add math equations to Google Forms using a Google Chrom Extension
3. 3 Ways to execute your Google Apps Script code
4. Automate PDF creation using Google Apps Script
5. Use triggers to execute your Google Apps Script code

May

1. Courses Completed this week: April 13, 2021
2. Courses Completed this week: April 15, 2021
3. Courses Completed this week: April 23, 2021
4. Add passwords to Google Forms
5. Create filters in Google Sheets using Google Apps Script

June

1. Extract cell notes into another column using Google Apps Script
2. 9 Useful Google Sheets formulas

July

1. Get Calendar events into your Google Sheet using Google Apps Script
2. Add Google meet links to Calendar Events using Google Apps Script
3. Create Calendar events using Google Apps Script
4. Build a simple Google Form Add-on using Google Apps Script

August

1. Conditional questioning in Google Forms
2. My First Project: Project Automation
3. Google Workspace Nuggets

September

1. Autofill options in Google Form using Google Apps Script
2. Create and Delete dropdown lists in Google Sheets using Data Validation
3. Send Bulk emails using YAMM
4. Create mass Documents using FormPublisher

October

1. Create Google Classrooms using Google Apps Script
2. Send out Google Classroom Enrollment codes using YAMM
3. Create pre-filled Google Forms using a simple Google Sheet formula

November

1. Send out pre-filled Google Forms using YAMM
2. Git and Github tutorial — Aryan Irani
3. Add last modified timestamps to Google Sheets using Google Apps Script

In November, I launched my website that has a collection of blogs and videos and some information about me. Check it out by clicking here.

I even launched my course on Google Apps Script (Getting started with Google Apps Script) on Udemy.

Will be coming out with more amazing blogs in the coming years.