UrTrix - UnRevealed Tricks

The Google Form Notifications add-on lets you automatically send Google Form responses in an email message to one or more recipients. The email notifications are dispatched the moment your form receives a new submission. The more recent version of the Google Form addon includes support for QR Code and Barcode symbols that you can embed in the email messages. The images can be generated from static text or you can create dynamic images based on answers submitted by the user. Add QR Code images in Emails The basic syntax for adding QR Code images in emails is: = QRCODE ( Your Text Goes Here ) You can customize the colors and size of the QR code image by adding key-value pairs in the QRCODE function. For instance, if you would like the QRCode to have Indigo background and the QRCode should be itself in white color, the modified formula with the hex color codes would be: = QRCODE ( TEXT textcolor = # FFFFFF backgroundcolor = # 4 B0082 ) The QR Code images have a default wi...

Google Images earlier offered a useful “search by size” option in advanced search to help you find logos, wallpapers and other images on the Internet by their exact size (or resolution). For instance, you could limit your search for landscape photographs to image files that were at least 10 Megapixels in size. Or, if you are were using Google Image search to find wallpapers for the desktop, you could specify the image resolution as 1920x1080 pixels and Google would only return large images with those exact dimensions. The “exact size” search option is no longer available in Google Image Search but you can still limit your image searches to a particular size by using the secret imagesize search operator in the query itself. Here’s how. Go to images.google.com and enter the search terms as before. Then append imagesize:WIDTHxHEIGHT to your query and hit Enter. Google Images will remove the operator from the query but the results will only display images that match the specified...

Google Apps Script makes it is easy for you to integrate data and functionality from Gmail, Google Drive, Google Maps, YouTube, and most other Google APIs. Apps Script is JavaScript under the hood so you don’t have to learn a new language and you don’t have to manage any servers since all your code runs on the Google Cloud, not your browser. In this video tutorial, you’ll learn how to develop Google Apps Script projects locally on your computer inside Visual Studio Code. You can write your code in modern JavaScript, neatly organized in modules, and the build environment will use Babel and Webpack to transform your code into a version of JavaScript that is compatible with Apps Script. Modern Development with Google Apps Script There are quite a few advantages with having a local development environment vis-a-vis writing code in the Apps Script Cloud IDE. You can write code with ES6 Classes, Arrow Functions, Modules, Destructing and use all the other modern JavaScript features. ...

The Mail Merge app merges data from a Google Spreadsheet and sends them as personalized emails . You can format your sheet data in multiple colors, choose different font families, vary the size of your text, include hyperlinks , line breaks and more. The rich text of spreadsheet cells is internally translated into HTML tags with inline CSS and thus the cell formatting is preserved in the outgoing Gmail messages. Here’s an example: If you would like to enable this feature, go to the Add-ons menu in Google Sheets > Mail Merge with Attachments > Configure Mail Merge and check the “Preserve Cell Formatting” option. You can even format your spreadsheet cells with conditional formatting and the text styles will be retained in mail merge. For instance, you can dynamically color the invoice amount column in red and make it bold if the due date has passed and this value would show up in bold red in the email message as well. Send Rich Text HTML Emails with Google Sheet This ...

This tutorial describes how you can easily send HTML emails in Gmail without using any extensions. You can format your Gmail messages to include tables, buttons, custom fonts, social media icons, wrap images around text, and more. A little knowledge of HTML and CSS will come handy but it is not a pre-requisite. The built-in WYSIWYG editor of Gmail offers basic formatting options - you can make text bold, create lists, change font colors - but that’s pretty much it. There’s no option to insert custom HTML into the message body that is required to send rich emails though Gmail. Write HTML Emails Directly in Gmail Let’s start with some basic examples and then we move on to more advanced example where you’ll learn how to send email newsletters that were created separately inside MailChimp. Insert Buttons in Gmail This HTML snippet creates a beautiful call-to-action button with a blue background, slightly rounded edges and rendered in the popular Roboto font. < a href =...

The Email Extractor app pulls emails addresses of your contacts from Gmail into a Google Sheet. You can then use Mail Merge or Document Studio to send personalized emails to your contacts from within the sheet itself. That said, the imported mailing list may sometimes have duplicate email addresses and it is thus be a good idea to clean up the data in your Google Sheet by removing duplicates before sending out the emails. Highlight Duplicates in Google Sheets You can use Conditional Formatting in Google Sheets combined with the COUNTIF formula to quickly highlight cells that contain duplicate values. Here’s how you can find duplicates in Google Sheets: Open the Google Sheet containing your data and go to the Format menu. Select Conditional Formatting from the expanded menu. This will help us change the colors of cells, rows or columns that meet a specific criteria. In the Apply to Range input box, add the range of cells that contain possible duplicates. In our case...

The Government of India has recently introduced an “open API” for Aarogya Setu , the world’s most popular contact tracing app that has more than 110 million users across the Android and iOS platform. The Aarogya Setu API, in simple English, will help organizations automatically check the health status of their employees. Currently, when an employee enters his or her office, they are required to show their Aarogya Setu app at the reception and are allowed entry only if the status is green meaning they haven’t been in proximity of an infected person. With the API in places, business can automatically know the risk level of their employees. This could save some effort since the HR department can create a Google Sheet with the phone numbers of all employees and a Google Script can automatically get the health status of each number in that list. The script can then email the list of employees who are at moderate or high risk for further action. Also see: Covid-19 India Tracker How ...