Author: admin

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

You have lots of files in your Google Drive and it can take some effort to find that elusive file you’ve been looking for. For instance, how do you quickly find the sales presentation that Kristin shared with you last week? Or how do you locate a specific resume among the hundreds of other PDF files in your Google Drive folders? Like Gmail and Twitter, Google Drive supports a plethora of advanced search operators that will help you quickly find the exact file you’ve been looking for. You can use search operators on the Google Drive website and the Drive…

Read More

Gmail supports a plethora of search operators to help you instantly find that elusive email message buried in your mailbox. You have size search – like larger_than:5mb – to find the big messages in your account. File search – like has:attachment filename:doc – will locate email messages that contain specific file attachments. This graphic illustrates all the known Gmail search operators that work both on Gmail website and mobile. Search by Date in Gmail Date search in Gmail helps you locate emails sent or received during a specific period. Here are some examples: newer_than:7d from:me – Emails sent in the last 7 days…

Read More