Author: admin

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

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

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…

Read More

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…

Read More

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…

Read More

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…

Read More

Yesterday marked Friendship Day, and to celebrate, I sent a personalized image to each of my friends via WhatsApp. The images were created in bulk, but each graphic had the person’s name, making the greetings unique and heartfelt. To achieve this, I did employ some automation. First, I gathered the names of my friends in a Google Sheet. Then, I designed a graphic template in Canva and imported the design in Google Slides. The template had a placeholder – {{Friend’s Name}} – that would be replaced with actual values from the Google Sheet. The Source Template Here’s the source data…

Read More

Play ; Discord is a popular instant messaging and group-chatting platform, used by millions of people. Notably, it has gained significant traction within colleges and gaming communities. This tutorial shows how you can automatically post Google Form responses to a specific Discord channel with the help of Document Studio. Send Google Form Responses to Discord Imagine a college Discord server with dedicated #tech and #science channels for different societies. Student volunteers can fill in a Google Form and indicate which society they would like be a part of. When the respondent submits the Google Form, an instant notification is sent…

Read More

Whether you are looking to write emails in Gmail, create tables with custom data in Google Sheets or design a presentation in Google Slides, Duet AI for Google Workspace can do the work for you in few easy steps. How to Enable Duet AI Duet AI is now available for Google Workspace but you need to take the following steps to start using the AI capabilities of Duet AI in your Gmail and other Google apps. 1. Purchase the Duet AI add-on Open admin.google.com and sign in to your Google Workspace account as an administrator. Inside the dashboard, navigate to…

Read More

Google Forms are a perfect tool for creating online forms and surveys. The forms are responsive and mobile friendly, and they look beautiful as the color schemes and typography are based on Material design philosophy. Whether you need a basic Contact Me form to a more complex Event Registration form, there are readymade form templates to get you up and running in minutes. Google Forms offer several advantages. The form responses are automatically saved in a Google spreadsheet that can be easily exported to other formats like PDF or CSV. Unlike other online form builders that follow the freemium model, Google Forms are absolutely free and can accept unlimited responses. You can…

Read More

You have a Google Form and you would like to send an auto-confirmation emails to the person as soon as they submit the form. The autoresponder email message can contain a custom note (like an acknowledgement saying that you have received their form entry)  and also a copy of the form answers that that they have submitted. These auto-responders are similar to canned responses in Gmail but for Google Forms. You may use the technique for sending welcome messages, acknowledge support requests, and more. Here’s a sample confirmation email that was sent through Google Forms: A sample auto confirmation email sent through Google Forms Send a Confirmation…

Read More