Author: admin
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…
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…