Author: admin
Nestled in the Nilgiri Hills, Ooty, also known as Udhagamandalam, is renowned for its picturesque mountain views, sprawling tea estates, verdant grasslands, shimmering lakes, beautiful gardens, and captivating colonial-era architecture. This resort town is considered one of the premier hill stations in India and among the top places to visit near Bangalore. Ooty offers countless attractions to explore, making it impossible to experience everything in just two days. To make the most of your visit, we have tailored an Ooty 2-Day Trip that provides a comprehensive glimpse of the captivating landscapes, encompassing the most remarkable highlights of this majestic hill…
Situated amidst the majestic mountains of Karnataka, Coorg is a destination that appeals to all kinds of travelers – whether you seek relaxation, nature’s beauty, or thrilling adventures. With its unparalleled natural landscapes, fragrant coffee plantations, diverse wildlife, and lush green hills intersected by flowing streams, Coorg is a gem waiting to be explored. This pristine hill station offers a plethora of tourist attractions, making it impossible to visit all in just a day or two. To make your trip planning easier, Trawell.in has curated a list of the best places to visit during your Coorg 2 day trip. Here…
Use AI to improve spam detection in Gmail and find legitimate emails that were mistakenly marked as spam by Google algorithms.False positives in Gmail are uncommon but can happen, meaning an important email might mistakenly end up in your spam folder. When you’re dealing with hundreds of spam messages daily, identifying these legitimate emails becomes even more challenging.You can create filters in Gmail such that emails from specific senders or with certain keywords are never marked as spam. But these filters would obviously not work for emails from new or unknown senders.Find incorrectly classified messages in Gmail SpamWhat if we…
Use Google Apps Script to create a custom menu that will work inside Google Sheets, Google Docs, Slides and Google Forms. Adding a custom menu in Google Sheets, Docs, Slides, and Forms using Google Apps Script is straightforward.As an illustration, the following code snippet adds a custom menu to the parent Google Sheet that reveals the spreadsheet name upon clicking.function onOpen() { const ui = SpreadsheetApp.getUi(); const menu = ui.createMenu(‘➯ Custom menu’); menu.addItem(‘Show spreadsheet name’, ‘showName’); menu.addToUi(); } function showName() { const fileName = SpreadsheetApp.getActiveSpreadsheet().getName(); SpreadsheetApp.getUi().alert(fileName); }The above code defines two functions: onOpen which executes when the app opens, and…
Learn how to send messages to Slack from Google Form and Google Sheet. You can also tag or mention a Slack user in the chat message.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…
Learn how extract all the embedded images from a Google Document or Google Slides presentation and save them as individual files in a specified folder in your Google Drive.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. 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.”…
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.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…
How to use Document Studio to embed uploaded images in generated documents from Google Forms responses.The Document Studio add-on lets you create pixel-perfect documents from your data in Google Sheets and Google Forms. For instance, someone can fill out your Google Form, upload a photo and the add-on will automatically generate a PDF document with the uploaded photo and form answers (tutorial).Embed Images in DocumentsOne of the most unique features of Document Studio is that it can embed images in the generated documents. For instance, you could have a Google Form where the respondent uploads an image and these can…
How to use Google Sheets to monitor your stock portfolio. Get daily performance reports in your email inbox at a scheduled time.I have a Stock tracker spreadsheet built inside Google Sheets that keeps track of my fictional stock portfolio. The stock prices in the Google Sheet are updated automatically using the GOOGLEFINANCE function. I would like to set up a daily trigger that runs every day at, say 4pm, and sends me an email with the screenshot of the spreadsheet. This way I can keep track the performance of my stocks without having to open the spreadsheet every day. Let’s…
Learn how to save password protected PDF attachments from your Gmail to Google Drive automatically. The PDF files will be saved to Google Drive as unencrypted PDF documents that can be opened without entering the password.Credit card companies and banks often send their financial statements in the form of password-protected PDF files. These PDF attachments may be encrypted with passwords derived from the last four digits of your Social Security number, your birthdate, or any unique combination. If you are to open these password-protected PDF files, you’ll have to enter the password every time. You can permanently remove passwords from…
How to pre-fill answers in Google Forms using data from a Google Sheet and send the pre-populated Google Forms as personalized emails.Prefilled Google Forms, where some of the fields in the form are pre-populated with answers you already have, make the process of filling out your forms easier and faster.Your contacts are more likely to fill out the form as it takes less time for them to complete the remaining fields.The form respondents are less likely to type incorrect data in fields, like the employee ID, that are pre-populated.The forms feels more personal when people see their name and other…
How to setup conditional email notifications in Google Forms. This powerful feature allows you to route form responses to different email addresses based on form answers or choices made by respondents.The Google Forms Email Notifications add-on lets you send Google Form responses in an email message as soon as a respondent submits the form. The email template can be customized to include the form answers or the form edit link. You can also set up conditional email notifications for Google Forms where the form responses are sent to different email addresses based on the form answers filled-in by the respondent.In…