Google Apps Script is a strong scripting language that is frequently used with Google Sheets. It allows people to create lightweight web applications that run on Google’s servers in the cloud. There are many surprising things that we can do in Google Sheets such as performing a Google Search, website monitoring, sending SMS, and many other things.
On this page, let us discuss all the surprising things that we can do in Google Sheets and Google Apps Script with the help of Google Sheets Tips. Read further to find more.
Table of Contents
Surprising Tips We Can Do With Google Sheets
There are many surprising tips that we can do in Google Sheets and they are discussed below:
1. Get SMS or Email When Website Goes Down
Commercial website-monitoring services will check a website you’re responsible for on a regular basis and send you an SMS message if it ever goes down. This helps you to respond quickly and fix the problem.
This is done using Google Docs via the Website Uptime Monitor script. It monitors your website every five minutes. If it is down, it adds a calendar event to your Google Calendar with a reminder, and the remainder is programmed to send you an SMS message right away. It uses Google Calendar’s SMS-reminder feature to automatically send you an SMS – the sending part is free, but receiving an SMS on some cellular carriers may cost money.
- How To Save Data on Google Sheets? – Save Data in Google Sheets using Apps Script
- The Best Google Sheets Add Ons: Automate your Workflow With Best Add-Ons
- How to Turn On Notifications in a Google Spreadsheet in 2 Easy Steps
2. Perform a Mail Merge
A “mail merge” may appear to be a relic of the past, yet it can still be beneficial. By creating a template, you can send personalised emails to several persons using a mail merge. “Hello $PERSON, how are you?” can be an example of a template. You might have a list of email addresses and person names, and everyone would get a personalised email that started with their name if you used mail merge.
3. Track Products on a Website
The Amazon Price Tracker script accepts a list of URLs (website addresses) of products on Amazon.com or another Amazon website, such as Amazon.ca or Amazon.co.uk, and compares them. It will monitor these pages once a day and send you a daily email digest with a list of pricing changes. This can be useful if you want to keep an eye on a product and buy it when it’s cheaper.
4. Know Read Recipients in Gmail
The “read receipts” feature in Outlook can notify you when your email has been read by the receiver. This tells you whether the recipient of your email has opened it or not, though it isn’t always accurate.
Although the capability isn’t available in Gmail, the Email Tracker script integrates with Google Analytics and allows you to track email openings through Google Analytics when you use the script to send an email. It inserts a tiny 11-pixel picture, and Google Analytics tracks how many times this image is accessed. This should be much more accurate now that Gmail is loading graphics in emails automatically.
5. Schedule a Gmail Message in Google Sheets
The Gmail Sheet Scheduler lets you make a custom spreadsheet that imports drafts emails from your Gmail account and assigns dates and times to them. After that, select a menu option, and the script will deliver the messages at the time you specify. You don’t have to trust a third-party service or leave a web page open because it all happens through a simple script running in your Google account.