UrTrix - UnRevealed Tricks

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 to the respective Discord channel. To get started, go to the Discord channel where the Google Form notifications should be delivered and click the Settings icon to copy the webhook URL for that channel. Now that you have generated the Discord webhook URL, go to your Google Form and create a new workflow in Document Studio. On the Conditions tab, s...

Are you looking for a way to receive notifications in real-time when an important spreadsheet in your Google Drive get modified or is accidently deleted by sometimes? Well, Google Drive offers an API to help you set up a watch on any file in your Google Drive be it a document, presentation or even a PDF file. This means that you can receive instant notifications whenever the content or even permissions of that file changes. This tutorial explains how you can setup watch notifications on any file in your Google Drive with the help of Google Apps Script. Setup a File Watch in Google Drive To get started, type script.new in the browser to open the Apps Script editor and add the code below to create a watch. You’d need the unique ID of the Google Drive file and the webhook URL where the notifications would be send when the file gets modified. const API_BASE_URL = 'https://www.googleapis.com/drive/v3' ; const SUBSCRIPTION_DURATION_MS = 24 * 60 * 60 * 1000 ; /...

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 - - that would be replaced with actual values from the Google Sheet. The Source Template Here’s the source data and the image template. The placeholder in a graphic was replaced with actual values from the Google Sheet. The Generated Graphic And here is the completed deck in Google Slides, where each slide is generated from individual rows of the Google Sheet. You may notice that the names are distinct on every slide for personalization. The best part is that the customization options aren’t just limited to text - you can a...

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 the purpose of this guide is not to explain how to add emojis in Google Sheets but the problems that emojis may cause in your production workflows related to Google Sheets . The problem with Emojis in Google Sheets If you are to convert any Google Sheet to a PDF file programmatically, Apps Script can help. However, if your Google Sheet contains any emoji sy...