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.
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.
The Google Sheet that I will be using…
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:
YAMM(Yet Another Mail Merge) is an easy to use Mail merge where you select a draft created in Gmail and replace all the…
In this blog, I am going to show you how to create and delete drop-down lists in Google Sheets.
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.
Add Images in Google Sheets.
Add Header Images to Google Forms
Make questions required in Google Forms
Autofill in Google Sheets
Conditional Formatting in Google Sheets
Version History in Google Sheets
Add Videos to Google Docs
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.
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.
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. …
Add-ons are customized applications that integrate with Google Workspace productivity applications. Most Add-ons are built using Google Apps Script.
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.
The Google Sheet that I will be using in this blog, contains the following details . If you prefer working with the sheet click here.
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.
The Google Sheet that I will be using in this blog, contains the following details. If you prefer working with the sheet click here.