UrTrix - UnRevealed Tricks

This video tutorial explains how you can automatically send Slack messages from Google Forms with the help of Document Studio . For this example, we have an event registration form created with Google Forms. When a participant completes the form and clicks the submit button, a message is instantly posted in the company’s Slack channel with details of the attendee like their name and email address. The Google Form has a “Preferred Location” question as well and based on this answer, a specific member of the team will be tagged or mentioned in the Slack message. For instance, if the attended selects New York as the location in the form, the internal Slack message will tag @Angus since they takes care of New York registrations. Send Slack Messages on Google Form Submit Go to your Google Form and launch Document Studio . Create a new workflow and add a Slack task. Connect your Google Account to your Slack account and you’ll be presented with a list of #channels available in t...

Cron is a scheduling tool that helps you run tasks at recurring intervals. You use a cron expression to specify the exact timing for your scheduled task. For example, if you want a schedule to run every week day at 8:30 pm, the cron expression would look like this: 30 20 * * 1 -5 Cron Expressions Here are some more practical examples to help you understand the cron expression. Cron Expression Description 0 0 * * * every day at midnight 0 */2 * * * every 2 hours 0 10 * * FRI,SAT every Friday and Saturday at 10 am 30 9 */15 * * at 9:30 am on every 15th day 0 0 1 */3 * first day of every quarter Time Triggers in Google Apps Script Google Apps Script supports time-driven triggers to help you run tasks in the background automatically. For instance, you can setup a time trigger in Apps Script to email spreadsheets every weekday. Or a trigger to download emails from Gmail to your Google Drive. Time-based triggers in Apps Script have certain limitat...

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 Billing > Get more services > Google Workspace add-ons. Here, look for the Duet AI for Google Workspace Enterprise card and cick the Start Free Trial link to subscribe to the Duet AI service. You can use the Duet AI add-on without payment for a period of 14 days. 2. Assign Duet AI licenses Once you’ve successfully activated Duet AI, it’s time to share its benefits with your team. Go to Directory > Users and se...

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...