Author: admin
The default layout of your Gmail inbox has the sender’s name listed in the left column followed by the subject and the date of the message. The emails are sorted in reverse chronological order with the newest messages listed at the top. Play ; The problem with this layout is that you cannot figure out who the actual sender of a message is without actually opening the email. For instance, if you get an email from Angus who works at Google and a different email from another Angus who is employed with Microsoft, Gmail will show Angus as the sender…
Google Cloud offers several serverless services that let you build and run applications without having to manage servers. You can run containers on Google Cloud Run, create API endpoints with Cloud Run Functions (formerly Google Cloud Functions) or run your mobile and web backends with Firebase Functions. A common concept for serverless functions on Google Cloud is the concept of revisions. Each time you deploy your code, a new and immutable revision is created on Google Cloud and the old revision is not deleted. This is useful because, later, you can easily roll back to an older version of a…
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
The REMOVE_ACCENTED function for Google Sheets will replace all accented characters in the referenced cell, like the letters è, õ, ā, ĝ and so on with their normal Latin equivalents. To get started, make a copy of the Google Sheet, go to the Tools menu, choose Script Editor and copy the entire code to your clipboard. Now open your own Google Sheet and paste the same code inside the Script editor of your sheet. Save and you should be able to use the REMOVE_ACCENTED function in your own sheets. Input StringOutput stringA História de Malú e João MiguelA Historia de…
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
You have a workbook in Google Sheets that contains multiple rows of data and you are required to sort the list in a random order. For instance, your sheet may contain the names of your team members and you need to reshuffle the list before assigning tasks to each of the members randomly. Or your Google Sheet may have the email addresses of people who participated in a giveaway and you need to pick any three random entries in an unbiased manner for the prize. There are multiple ways to randomize the data rows in Google Sheet. You can either…
With its soaring temperatures, May ranks among the hottest months in the Indian subcontinent, prompting a desire to seek cooler destinations to alleviate the heat. Additionally, May marks the official summer vacation period in India, making it an ideal time for family getaways. Fortunately, India offers a plethora of locations to explore in May, ranging from the majestic Himalayas to picturesque hill stations and lush jungles. Whether you prefer backpacking or spending quality time with loved ones, these tourist places in India provide a refreshing escape from the summer heat with their mild climates, allowing you to relax and rejuvenate…
Notion, my absolute favorite tool for storing all sorts of things from web pages to code snippets to recipes, just got better. They’ve released a public API and thus it will be a lot easier for developers to read and write to their Notion workspace from external apps. For instance, you can create a document in Google Docs and export it to Notion while staying inside Docs. Google Sheets users can pull pages from Notion database into their spreadsheet. Any new submissions in Google Forms can be directly saved to Notion and so on! Save Gmail Messages in Notion I…
Would you like to receive notifications in your Telegram messenger when a new form response is submitted in Google Forms. Or maybe send a notification alert to your entire Telegram group when an important event happens. In this step-by-step tutorial, you’ll learn how to create a new Telegram bot and send messages to your Telegram channel and groups through this bot with the help of Google Apps Script. Create a new Telegram Bot Open the telegram app on your desktop or mobile phone and search for the @BotFather bot. This is the official Telegram bot that you can interact with…
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
Dates are internally stored as sequential serial numbers in Google Sheets. This serial number represents the number of days elapsed since December 31, 1899. You can use the DATEVALUE function to convert any date input to a number that represents the date. For instance, both the functions DATEVALUE(“Jan 1”) and DATEVALUE(“01-Jan-2021”) return the same number (44197) though the inputs have vastly different formats. The function TODAY() returns the current date while the function NOW() returns the current date and time. Both these functions do not require any arguments and they update when any cell in the Google Sheet is changed.…
Razorpay is a popular payment gateway in India that allows you to accept online payments from customers anywhere in the world. Your customers can pay with credit cards, debit cards, Google Pay, Walmart’s PhonePe and other UPI apps. Razorpay, similar to Stripe, offers a simple no-code tool for generating payment links that you can share with customers over SMS, WhatsApp, or email. When a customer clicks on the link, they are redirected to a secure checkout page hosted on Razorpay where they can can make the payment using their preferred payment method. Here’s a sample payment link generated with Razorpay…