UrTrix - UnRevealed Tricks

The Mail merge add-on for Gmail lets you send personalized emails to your contacts in bulk. You can pull file attachments from Google Drive and include them in the outgoing emails. The emails can be sent immediately or scheduled for sending at a later date and time. If you are an Outlook or Microsoft 365 user, you can still use Google Sheets to send personalized emails to multiple people at once with the help of Mail Merge. All you have to do is add your Outlook account to Gmail as an alias and the Mail Merge add-on will be able to send emails through your Outlook account. Generate an App Password for Outlook The first step is to generate an app password for your Outlook / Microsoft 365 account. Go to account.microsoft.com/security , sign-in with your Outlook account and choose Advanced security options . Scroll down to the App passwords section and click Create a new app password . Add your Outlook Account to Gmail Go to your Gmail account and choose Settings from...

Imagine you’re working with a lengthy Google Document, or a Google Slides presentation, and you need to extract all the embedded images from the text and save them as individual files. Extract Individual Images A simple solution to address this issue is as follows: convert your Google Document or Google Slide into a web page. Here’s how you can do it: Go to the “File” menu. Select the “Share” submenu and then choose “Publish to Web.” It will generate a public web page that contains all the images from your document or slide. You can simply right-click an image on the page and select the “Save Image” option download it to your local disk. What we have just discussed is a manual process but we can easily automate this with the help of Google Apps Script. Extract all Images from a Google Document Open your Google Document containing the images, go to the Extensions menu and choose Apps Script. Copy-paste the code below and run the saveGoogleDocsImages function to download all...

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