Author: admin
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…
How to capture screenshots of Google Sheets and send the images via email automatically on a schedule to keep your team updated with the latest data.The finance team has created a revenue dashboard inside Google Sheets to track the company’s sales performance over time. The dashboard has data tables and charts showing overall revenue and regional performance trends.Here’s a screenshot of the Google Sheets dashboard: The finance team wants to send a snapshot of this dashboard to the company’s management every Monday morning. They would like to automate this process so that the screenshot is captured automatically and sent via…
Amritsar‘s Golden Temple in Punjab is a celebrated monument renowned for both its spiritual significance and architectural beauty. This spiritual sanctuary, known as Darbar Sahib or Harmandir Sahib, attracts devotees and tourists with its golden grace. It offers the perfect blend of serenity, devotion, and architectural beauty. As you approach this sacred haven, the shimmering domes and tranquil waters paint a picture of tranquillity against the stunning backdrop. Today, the Golden Temple or Suvarna Mandir in Amritsar is a top tourist destination, drawing people with its spiritual aura, and architectural grandeur. Festivals like Vaisakhi, Guru Nanak’s birthday, Guru Teg Bahadur’s…
This detailed guide explains how you access your passwords, API keys and other sensitive data stored in the Google Secret Manager with Google Apps Script.Google Secret Manager is a cloud service where you can store sensitive data such as passwords, database credentials, encryption keys or any other confidential information that you don’t want to hardcode in your application’s source code. You can also set up an expiration time for the secret and the Google Secret Manager will automatically delete the secret after the specified time. The following guide explains how you can use Google Apps Script to access secrets stored…
The Dubai skyline is a stunning display of architectural wonders that truly capture the eye and ignite the imagination. The Burj Khalifa, rising like a radiant needle into the sky, proudly claims the title of the world’s tallest building. The Burj Al Arab, resembling a majestic sail, stands as a luxurious hotel on its private island, emanating opulence and elegance. And then there’s the Dubai Frame, a colossal picture frame connecting the city’s past and present. These buildings aren’t just landmarks but symbols of Dubai’s innovation, ambition, and architectural excellence. Get ready to learn about these amazing buildings that show…