Welcome !

In one of my previous blogs I had shown you how send bulk emails using YAMM. In that blog I had used FormPublisher to create custom bills for each that were then mailed to each of the residents. In this blog I will be showing you how I created those documents using Form Publisher.

What is Form Publisher ?

Form Publisher is a document generator that can be used to generate PDF’s, Google Docs, Slides and more. You can create customized documents with data from Google Sheets. To know more about Form Publisher click here.

Step1: Sample Google Sheet

The Google Sheet that I will be using…


Welcome!

Sending emails in bulk is an important requirement for most businesses. You often have situations, where you need to send the same email with a few customizations to tons if not hundreds of recipients. I will be covering the following topic:

  1. We need to send out bulk emails to residents of the society regarding the payment of the maintenance bill
  2. The task of writing individual emails is a cumbersome process, so we will be using YAMM.

What is YAMM?

YAMM(Yet Another Mail Merge) is an easy to use Mail merge where you select a draft created in Gmail and replace all the…


Welcome!

In this blog, I am going to show you how to create and delete drop-down lists in Google Sheets.

Step 1: Sample Google Sheet

The Google Sheet that I will be using has some colours store in on column and using that data I want to create a dropdown in the adjacent cell.


Originally published on FormPublisher.

Recently the College I study at had a Technical Fest that had multiple technical events. At the end of the Technical fest, we had to send out a feedback form to record their experience and suggestions on the various events that were conducted. During event registrations, we had collected the data on attendees, the events and the speakers which were stored in Google Sheets. …


A few months back I started a new video series called Workspace Nuggets. Short videos on tips and tricks around Google Workspace, Apps Script and more.

Here are all the Google Workspace Nuggets. These short tips range from Google Forms to Google Docs to formulas in Google Sheets. Hope these tips and tricks help you.

Workspace Nugget Part 1

Workspace Nugget Part 2

Add Images in Google Sheets.

Workspace Nugget Part 3

Add Header Images to Google Forms

Workspace Nugget Part 4

Make questions required in Google Forms

Workspace Nugget Part 5

Autofill in Google Sheets

Workspace Nugget Part 6

Conditional Formatting in Google Sheets

Workspace Nugget Part 7

Version History in Google Sheets

Workspace Nugget Part 8

Add Videos to Google Docs

Workspace Nugget Part 9

Conditional…


I am pursuing B-Tech(Computer Engineering) at NMIMS.

Since last year we have been undergoing online lectures and examinations, as a result of the pandemic. This presented a unique problem for the college administrators: how to distribute the test scores via email. Considering the number of students, the task required automation. I was allowed to devise a solution.

Let me take you on a journey from the problem to the solution.

Part 1: The Problem

Teachers had a requirement for sending out mark sheets via email to individual students and parents. Also, they did not want the scores of the students to be revealed to…


Did you know you can show specific questions to users based on the user's answers in Google Form? Yes using the conditional questioning feature in Google Form, you can show questions based on the user’s response. In this blog, we will take a look at this feature using a simple example.

So let’s get started.

Step 1: Sample Google Form

The Google Form that we will be using is a feedback form for 5 different sessions. So the plan is to display the session feedback questions based on the option selected by the user. …


What are Add-ons?

Add-ons are customized applications that integrate with Google Workspace productivity applications. Most Add-ons are built using Google Apps Script.

What goes into the making of an Add-on?

Most Add-ons are built using Google Apps Script and various other languages. In this blog, we will be using Google Apps Script and some HTML to build the card for the Add-on.

In one of the previous blogs, I showed you how to Limit Responses in Google Forms using Google Apps Script. In this blog, I am going to show you how to create an Add-on using the same Google Apps Script code that we had written.

If you haven't read…


Welcome to the Second part of the Calendar API Tutorial Series.

In this blog I am going to show you how to created calendar events from a Google Sheet using the Calendar API and Google Apps Script.

So let’s get started.

Step 1 : Sample Google Sheet

The Google Sheet that I will be using in this blog, contains the following details . If you prefer working with the sheet click here.

  1. Name of the Event
  2. Start date/time of the Event
  3. End date/time of the Event
  4. Location of the Event
  5. Description of the Event


Welcome to the Third part of the Calendar API Tutorial Series.

In this blog, I will show you how to Add Google Meet links to Calendar Events using the Calendar API and Google Apps Script.

So let’s get started.

Step 1: Sample Google Sheet

The Google Sheet that I will be using in this blog, contains the following details. If you prefer working with the sheet click here.

  1. Name of the Event
  2. Start date/time of the Event
  3. End date/time of the Event
  4. Description of the Event
  5. Attendees for the Event

Aryan Irani

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

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