UrTrix - UnRevealed Tricks

This tutorial explains how you can build a BMI calculator app with Google Sheets and Google Forms. When a user submits the form, their BMI score is calculated in Google Sheets and a personalized report is generated in Google Docs. The user then receives an email with their BMI score and the PDF report. 👋 Complete this quick Google Form to calculate your BMI and receive a personalized report in your inbox. BMI Calculator with Google Forms We have a Google Form that asks the user to enter their height and weight. The response is stored in a Google Sheet and the BMI score is calculated automatically using the BMI formula. The PDF report is personalized and includes the user’s BMI score, BMI category, and suggestions on how to improve their BMI score. The user’s photo is also embedded in the report as shown in the screenshot above. BMI Calculations in Google Sheets We perform the following calculations in Google Sheets to calculate the user’s BMI score. Age of the respon...

The Save Gmail to Google Drive add-on lets you automatically download email messages and file attachments from Gmail to your Google Drive. You can save the email messages as PDF while the attachments are saved in their original format. Transcribe Gmail Attachments The latest version of the Gmail add-on adds support for transcribing audio and video attachments in Gmail messages. The transcription is done with the help of OpenAI’s Whisper API and the transcript is saved as a new text file in your Google Drive. Here’s a step by step guide on how you can transcribe audio and video attachments in Gmail messages to text. Step 1. Install the Save Gmail to Google Drive add-on from the Google Workspace marketplace. Open sheets.new to create a new Google Sheet. Go to the Extension menu > Save Emails > Open App to launch the add-on. Step 2. Create a new workflow and specify the Gmail search criteria. The add-on will scan the matching email message for any audio and video file...

“Tech and AI” - that’s the theme of an upcoming event we are organizing in New York. We have created a Google Form to collect registrations and would like to send a welcome email automatically to each person as they fill the form. The email should be personalized and include the name of the attendee. We would like also attach a PDF file, with the speaker bios and other details about the event, to the email. Google Form for Event Registration Here’s a sample Google Form that we are using to collect registrations for the event. The form requires attendees to fill in their name, email address and their preferred date to attend the event. Personalized Welcome Email Since we would like to send a personalized email to each attendee, we’ll use markers in the email template that will be replaced with the actual values from the Google Form. For instance, if we use the marker in the email template, it will be replaced with the actual name of the attendee that is filled in the Google F...