Author: admin
Table of Contents 1. Recover Spaces in Google Drive 1.1 For Gmail accounts 1.2 For Google Workspace accounts 1.3 Delete App Backups Your Google account storage is shared between Gmail, Google Drive, and Google Photos. What do you do when your Google account is running out of storage space? You either buy more storage from Google or the inexpensive option is that you spend some time spring-cleaning your account and delete the emails and files that could be hogging up the storage space. Recover Spaces in Google Drive First things first. Go to google.com/settings/storage and click on the “View Details”…
Table of Contents 1. Find All Newsletters in your Inbox 2. Reclaim Space in your Gmail Account Gmail recently rolled out a new feature that helps you unsubscribe from bulk emails with minimal effort. This is a good way to declutter your inbox and focus on the emails that matter most. You open the Manage Subscriptions page in Gmail and it shows a list of all bulk email senders, sorted by the number of messages received from each sender. You can then unsubscribe from any sender with a single click. Find All Newsletters in your Inbox What if you only…
As July arrives, the monsoon intensifies, causing many individuals to dread the idea of traveling in the rain due to traffic congestion, muddy roads, floods, and puddles, particularly for those residing in urban areas. However, July presents an opportunity to explore certain tourist places in India that are adorned with the beauty of nature. The rainfall rejuvenates these locations, enveloping them in lush greenery, which creates a picturesque view. Additionally, many places in India offer significantly reduced prices during the monsoon season! Therefore, we encourage you to read our blog to enhance your July experience as part of India tour…
Table of Contents 1. The Limitation 2. How to Unsubscribe from Email Newsletters in Gmail 3. Gmail Unsubscriber with Google Script 3.1 How Gmail Unsubscribes from Mailing Lists The Gmail Unsubscriber is a Google Script that automatically unsubscribes you from email newsletters and other bulk messages in Gmail. I wrote this script in 2017 and it even won the Lifehack of the Year award from Product Hunt. While the Gmail Unsubscriber script still works, you may no longer need it as Gmail now has built-in functionality to handle unsubscribing from junk email newsletters. They’ve added a new tab in Gmail…
Having your data spread out across different spreadsheets is a common challenge. You might have sales figures in one file, inventory data in another, and customer information in a third sheet. When you need to pull that information together to build a dashboard or a summary report, the default solution is often manual copying and pasting. What if your Google Sheets could talk to each other, automatically updating your reports whenever the source data changes? In this guide, we’ll explore all the powerful ways to import data between different Google Sheets. Also see: Create Stock Dashboard in Google Sheets For…
June marks the beginning of the monsoon season in India, which leads to numerous deals on various services such as travel packages, hotels, and guides, all offered at discounted prices. If you are fond of monsoons, Maharashtra, particularly Mahabaleshwar, is an ideal destination to visit in June as part of the India tour packages. The hills are stunning, and the area is less crowded compared to other times of the year, allowing you to relish the serenity without the hassle of long lines and queues. Furthermore, during June, the monsoon has not fully arrived yet, so you can still enjoy…
Angus owns a beautiful apartment near the university campus. With the new semester around the corner, he wants to create brochures to attract students as tenants. But here’s the challenge: the university has students from all over the world who speak different languages. Angus needs to create brochures that speak to everyone—from students from Japan to those from France, and everywhere in between. While he could create PDF brochures in multiple languages manually, that process would be both time-consuming and error-prone. This guide explains how you can automate it all with the help of Google Sheets, Google Slides and the…
June is the time when summer vacations in India reach their peak and it is the best time for family vacations in India. The summer season is at its peak in North India at this time, but the rains have already started in the South. Therefore, it is a great time to travel to the hill stations in the North, especially in the Leh-Ladakh region, as the mountain passes are open for visitors. During this period, many people go on a trek to the sacred Amarnath cave to enjoy its beauty. For an unforgettable vacation, check out the list of…
The Mail Merge and Document Studio add-ons let you send personalized emails with the help of template markers. The markers automatically create a mapping between the column names in the Google Sheet and the variable fields in your email message. When the email is sent, the marker fields in the email message are replaced with the values from the respective columns of the sheet. Let’s say you have a column titled First Name in your Google Sheet and your email message body has a marker that says Dear {{First Name}}, (also notice the comma in the end). Fill-in Fields If…
With Document Studio, you can create employee badges, event tickets, school tags and other types of documents that contain QR Code images. To get started, go to your source spreadsheet and create a column that will the QR Code. Give it a title, say QR Code Image, and add a formula QRCODE in the first empty cell of that column as shown below. This will add the QR Code image link to all the cells of your spreadsheet where the source cell is not empty. Add QR Codes in Google Documents Click anywhere in the Google document where you wish…
Vim, or Vi Improved, is a powerful text editor that lets you do almost everything using keyboard shortcuts. You can replace text in a document, move or delete lines, automate edit actions, and more, without ever reaching for the mouse. Vim is the favorite source code editor of programmers but there’s no reason why you cannot use this editor for writing documents or composing long emails. Vim can be confusing for people who are used to working inside visual editors like Microsoft Word or Google Docs but spend some time with Vim and it will be difficult for you to go…
When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row contains a Timestamp column, the actual date when the form was submitted, and the other columns in the sheet contain all the user’s answers, one per column. You can extend the Google Forms sheet to also include formula fields and the cell values are automatically calculated whenever a new row is added to the sheet by the Google Form. For instance: You can have an auto-number formula that assigns an auto-incrementing but sequential ID to every…