Author: admin

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…

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…

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…

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…

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…

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…

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…

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…

YouTube is the second largest search engine on the Internet after Google. This guide discusses advanced search operators that you can use with your YouTube search queries for more accurate video searches. How to Search YouTube like a Pro! Find a specific YouTube channel royal wedding, channel YouTube will have numerous videos related to the royal wedding but if you are only looking for their official YouTube channel, add the word channel to your query separated by a comma. Watch live videos on YouTube zoo, live Add live to your search queries and watch live stream videos such as live…

Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise

Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise

Google Chrome support shortcuts to help you quickly search the web. You can go to the address bar, type in a custom shortcut (say @yt for YouTube) followed by your search term and it will instantly search the specific website for your query. Chat with AI from Address Bar You can use the same technique to quickly send prompts to favorite AI chatbots. For instance, typing @plex How do I make pasta? in the URL bar will instantly open the Perplexity website with your prompt pre-filled, saving you the steps of: Opening a new tab Navigating to the Perplexity AI…