Author: admin

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,…

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…

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…

“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…

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…

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…

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…

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…

You can bring the power of Google Maps to your Google Sheets using simple formulas with no coding. You don’t need to sign-up for the Google Maps API and all results from Google Maps are cached in the sheet so you are unlikely to hit any quota limits. To give you a quick example, if you have the starting address in column A and the destination address in column B, a formula like =GOOGLEMAPS_DISTANCE(A1, B1, “driving”) will quickly calculate the distance between the two points. Or modify the formula slightly =GOOGLEMAPS_TIME(A1, B1, “walking”) to know how long it will take…

The Email Spreadsheets add-on for Google Sheets can save office workers a ton of time by automating the reporting of spreadsheet data and dashboards by email. With this add-on, you can schedule reports to be sent automatically on a recurring schedule, so you don’t have to manually email spreadsheets to colleagues anymore. Play ; With Email Spreadsheets, you can schedule reports and it will automatically send them by email on a recurring schedule. You can email entire workbooks, specific sheets inside a workbook or even range of cells. Watch the video to get started. And because the add-on runs on…

Bob Canning writes: I have a Google Spreadsheet with postal addresses in column A. Each week, a real estate agent copies a section of those addresses to a “upcoming tour” tab on our website. The tab is shared with other real estate agents so they can see the addresses in the order they will be viewed on the tour. I would like to make all of the addresses clickable so that people can easily navigate to the next location on the tour. Is this possible? Make Addresses Clickable in Google Sheets We can use custom functions in Google Sheets with…

Emojis can be a fun and effective way to add visual interest to your Google Sheets formulas. There are so many different ways to add emojis in Google Sheets but my favorite option is the built-in CHAR function. You can copy the hex code of any emoji from unicode.org and then use the HEX2DEC function to convert the hexadecimal value into its decimal equivalent. The CHAR function will take this decimal number as input and returns the corresponding emoji symbol. // Add the 😀 emoji to the active cell =CHAR(HEX2DEC(“1F600”)) // Get the hex value of 😀 emoji =DEC2HEX(UNICODE(“😀”)) Well…