Author: admin

This tutorial explains how to make phone numbers clickable within Google Sheets, Slides and Google Docs. When someone clicks on the phone number link in your spreadsheet or this document, it will open the dialer on their mobile phone and initiate dialing of the specified phone number. How to Insert Clickable Phone Numbers in Web Pages Let’s start with the basics. If you click an email link on a webpage, it opens your default mail program. Similarly, you can make phone numbers on your website “callable” meaning when someone clicks on the phone number link, it will automatically launch the…

Read More

The majority of email spam on the Internet originates from forged addresses because SMTP allows any computer to send emails claiming to be from anyone. For instance, a spammer can put your email address in the “From” field when sending out bulk emails and the recipients may therefore incorrectly assume that the mail is coming from you. If any of them chooses to report that spoofed message as spam, its your email address that will be affected in the long run. Authenticate your Google Workspace Domain with SPF To prevent spammers from forging the “From” field of their bulk messages…

Read More

Conditional content allows you to customize your Google Docs template and generate different versions of the same document based on the user’s answers. In this tutorial, I’ll show you how to use conditional content in Google Docs using Document Studio, a Google add-on that automates document creation. If you are new here, please follow this step-by-step guide on how to generate documents from data in Google Sheets and Google Forms responses. Conditionally Display Content Let’s say you are a recruiter who wants to use a Google Docs template to send out job offer letters to candidates. You want to include…

Read More

Mail Exchange (MX) records, in simple English, tell the internet where to deliver your emails. These records enable email servers to know which mail servers are responsible for accepting incoming messages for a given domain. When you are using Gmail with your Google Workspace domain, Google provides you with a set of MX records in the format ASPMX.L.GOOGLE.COM and you need to add five such records to your domain. These MX records point incoming emails to Google’s mail servers, which then deliver the emails to your Gmail inbox. PriorityHost / Mail Server1ASPMX.L.GOOGLE.COM5ALT1.ASPMX.L.GOOGLE.COM5ALT2.ASPMX.L.GOOGLE.COM10ALT3.ASPMX.L.GOOGLE.COM10ALT4.ASPMX.L.GOOGLE.COM These MX records specify the priority and destination…

Read More

Whether you are looking to learn a programming language, enhance your Microsoft Excel skills, or acquire knowledge in Machine Learning, Udemy probably has a video course for you. Udemy courses are usually affordable, there are no subscription fee and you can learn at your own pace. Free Udemy Courses on Programming While most video tutorials on Udemy require payment, the website also offers some of their highly-rated courses for free. I’ve prepared a Google Sheet that lists all the free programming courses currently available on Udemy. The spreadsheet is updated automatically every few hours. You can also access the web…

Read More

This Google Spreadsheet on Udemy courses has about 50 sheets, one for each programming language, and the sheets are sorted in random order so it is difficult to find a specific sheet. It will take a while to sort the worksheets manually but we can easily automate the process with Google Apps Script and easily navigate through large spreadsheets. Automate Sheet Sorting with Google Apps Script The following code snippet will automatically sort the worksheets in a Google Sheet alphanumerically. The script can arrange the sheets in either ascending or descending order based on the sheet names. To get started,…

Read More

This guide describes how you can programmatically create user meetings in your Zoom account with the help of Google Apps Script and the official Zoom API. As a first step, go to the Zoom Developer Dashboard and create a new app. Choose JWT as the app type and make a note of the Zoom API key and secret. We can build Zoom apps with the OAuth2 library as well but since this app is only for internal use and will not be publish to the Zoom marketplace, the JWT approach is easier. The app would involve two step. We’ll connect…

Read More

The Pancha Bootha Sthalams are the five ancient Hindu temples dedicated to Lord Shiva, each representing one of the five fundamental elements of nature: Earth, Water, Fire, Air, and Sky. It is believed that these five elements are embodied in the five lingams housed within these temples, as Lord Shiva is considered the guardian of these elements. These revered temples are situated in South India, with four located in Tamil Nadu and one in Andhra Pradesh, and have been venerated for centuries by the Hindus. Let us delve into the mystique and divine presence that envelops these sacred locations as…

Read More

“Tech and AI” – that’s the theme of an upcoming event we are organizing in New York. We have created a Google Form to collect registrations and would like to send a welcome email automatically to each person as they fill the form. The email should be personalized and include the name of the attendee. We would like also attach a PDF file, with the speaker bios and other details about the event, to the email. Google Form for Event Registration Here’s a sample Google Form that we are using to collect registrations for the event. The form requires attendees…

Read More

The Save Gmail to Google Drive add-on lets you automatically download email messages and file attachments from Gmail to your Google Drive. You can save the email messages as PDF while the attachments are saved in their original format. Transcribe Gmail Attachments The latest version of the Gmail add-on adds support for transcribing audio and video attachments in Gmail messages. The transcription is done with the help of OpenAI’s Whisper API and the transcript is saved as a new text file in your Google Drive. Here’s a step by step guide on how you can transcribe audio and video attachments…

Read More

SlideCasts let you combine YouTube videos and Google Sides / PowerPoint presentations in a single-player. The speaker video and the slides appear side-by-side and, as the video progresses, the slides auto-change in sync with the video. You can try a live demo of SlideCasts here. Just hit the play button on the YouTube video and you’ll notice that the slides will change at the 10s, 25s and 30s mark (configurable). SlideCasts can be really useful for educators involved in remote teaching. The teacher’s “talking head” video can be uploaded to YouTube and the lecture slides can be hosted on Google…

Read More

This tutorial explains how you can build a BMI calculator app with Google Sheets and Google Forms. When a user submits the form, their BMI score is calculated in Google Sheets and a personalized report is generated in Google Docs. The user then receives an email with their BMI score and the PDF report. 👋 Complete this quick Google Form to calculate your BMI and receive a personalized report in your inbox. BMI Calculator with Google Forms We have a Google Form that asks the user to enter their height and weight. The response is stored in a Google Sheet…

Read More