Author: admin

Mail Merge for Gmail is the ultimate journalist outreach tool for Marcom and PR professionals. Send personalized and targeted email pitches and press releases to your media contacts with Gmail.John is a public relations professional and he is often required you to send press releases and event invites to journalists, bloggers and influencers via email.Reaching out to individual journalists can be slow so how do you send the same email to multiple people in one go? Some people use the BCC option in Gmail – compose a single email, put email addresses of all recipients in the BCC field and…

How to send Google Forms response in an email message after a respondent submits the form. You can send a copy of the form answers to the submitter as well.Google Forms are a perfect tool for creating online forms and surveys. The forms are responsive and mobile friendly, and they look beautiful as the color schemes and typography are based on Material design philosophy. Whether you need a basic Contact Me form to a more complex Event Registration form, there are readymade form templates to get you up and running in minutes.Google Forms offer several advantages. The form responses are automatically saved in a Google spreadsheet that can be easily exported…

Situated at an elevation of 3,400 feet at the base of Mullayanagiri, Chikmagalur is a captivating hill station in Karnataka. It showcases the epitome of lush green nature and a delightful environment, providing a respite from the scorching summers of the plains. Overflowing streams, undulating hills, verdant forests, towering mountains, aromatic coffee plantations, and pleasant weather combine to make Chikmagalur a must-visit tourist places in Karnataka, particularly in the month of May when the temperature hovers around a soothing 30 degrees Celsius. This unspoiled hill station is adorned with abundant greenery and boasts numerous attractions that entice visitors with their…

Quickly rename files in Google Drive with Apps Script and Google Gemini AI. The script will automatically rename the files with a descriptive name based on the image content.Do you have image files in your Google Drive with generic names like IMG_123456.jpg or Screenshot.png that offer no context about what the image is about? Wouldn’t it be nice if you had an assistant that could look at these images and automatically suggest descriptive filenames for the images? Rename Files in Google Drive with AIWell, you can use Google’s Gemini AI and Google Apps Script to automatically rename your files in…

How to send personalized emails using Mail Merge in Google Sheets with SMTP. You can send emails via SendGrid, Postmark, AWS SES, Zoho Mail, or any other SMTP serverThe Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail account or your Google Workspace email address. Google also imposes a limit on the number of emails you can send per day.Mail Merge with SMTPMail merge is convenient because you can put your contacts in a Google Sheet and the add-on will individually send the emails for you. However,…

How to auto-send emails to the person when submit a Google Form. The autoresponder email message can contain a custom note and a copy of the form answers.You have a Google Form and you would like to send an auto-confirmation emails to the person as soon as they submit the form. The autoresponder email message can contain a custom note (like an acknowledgement saying that you have received their form entry)  and also a copy of the form answers that that they have submitted.These auto-responders are similar to canned responses in Gmail but for Google Forms. You may use the technique for sending welcome messages, acknowledge…

How to recover the forgotten Wi-Fi password on Windows, Mac, and Linux computers.Imagine this scenario – your computer is connected to a Wi-Fi network but you do not remember the password that you previously used to connect to this particular WiFi network. Maybe you forgot the password over time, or perhaps the network administrator setup the Wi-Fi connection for you without providing the actual password to you.Now, you need to connect a second device, such as your mobile phone, to the same Wi-Fi network, but you’re unsure how to retrieve the password.Recover the Forgotten Wi-Fi PasswordIn this situation, you may…

Learn how to automatically copy Google Form responses to a Microsoft Excel or Zoho Sheet when a new form response is submitted. You can also copy the form responses to multiple Google Sheets.Google Forms is a perfect tool for collecting data, from event registrations to customer feedback. By default, your Google Form responses are added in a Google Sheet that is linked to the form.However, there could be scenarios where you may want to store a copy of the form responses in a different location, such as a Microsoft Excel worksheet, a Zoho sheet, or even multiple Google sheets. The…

Learn how to set up automatic send emails reminders for events created in Google Forms. The personalized reminders are sent to people who have filled out a form, ensuring timely notification as the event date approaches.You are using Google Forms to collect registrations for an upcoming event and would like to send email reminders to all the registered attendees a few days before the event date to ensure maximum attendance.This tutorial explains how you can use Google Sheets and Document Studio for sending automatic reminders to all the registered attendees. We’ll primarily us Gmail to send the reminders via email…

Learn how to restrict the number of responses that a Google Form can accept. You can also specify a closing date for your Google Forms or schedule them to open on specific daysWhen you create a Google Form, it is public by default meaning anyone who has the link to the form can submit a response. There forms, whether they are quizzes, polls or surveys, have no expiration date and they can collect unlimited number of responses until the form owner chooses to close it manually.However, there are scenarios when setting limits on Google Forms can be beneficial. For instance:Contests…

How to automatically create multiple sub-folders in Google Drive for each student and their subjects using Google Sheets and Document Studio.A teacher would like to create separate Google Drive folders for each student in her class. Within each student’s folder, there will be additional subfolders for various subjects. This folder structure would make it easier for students to submit their assignments to the appropriate subject subfolders. We’ve prepared a Google Sheet with the names of students, and the subjects they are taking. For example, consider a student named Emily Johnson, who is taking Maths, Science, and English. In this case,…

The SUBSTITUTE function in Google Sheets lets you find and replace a specific text value in a cell with another value. If you need to replace multiple values in a string with different values, you’ll need to nest multiple SUBSTITUTE functions which can be cumbersome.Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For instance, you can use =SUBSTITUTE(“My favorite color is red”, “red”, “blue”) to replace the text red in the string with blue. The SUBSTITUTE function is case-sensitive and will replace all occurrences of the…