Author: admin

This guide explains how you can easily create and manage hyperlinks in Google Sheets. An entire cell in the sheet, or specific text inside the cell, can be linked to external web pages. A cell can also contain multiple hyperlinks. If you type a web page address in a Google Sheet cell, it is automatically converted into a clickable hyperlink. You can add anchor text to plain hyperlinks for more accessible URLs. Hover your mouse over the hyperlink and click the Edit icon. Now add the anchor text in the Text input box and click the green Apply button. Alternatively,…

Read More

Search operators in Google (see Google cheat sheet) help you refine and improve search results. For instance, a query like “Taj Mahal AND Hotel” will search for pages related to the Hotel Taj and not the Mughal monument. Similarly, “kindle -site.com” will find all Kindle related resources outside the Amazon website. AROUND Search Operator Google Search supports an undocumented search operator called AROUND(n) that will help you find documents where the distance between two search terms is around ‘n.’ Here’s an example: Google Around Search Operator for Proximity Searches A search query like “CNN Obama” will mostly show CNN pages that are…

Read More

Your organization is currently using Gmail with Google Workspace for email. You are moving to another company and would like to archive all your existing email messages before the contract is terminated and the emails are permanently deleted from Gmail servers. How to Copy Google Workspace Emails to another Gmail Address Our previous email migration guide discussed ShuttleCloud, a service built into Gmail that uses Gmail APIs to copy your emails from one Gmail account to another. That approach, however, will not work when you are transferring emails from Google Workspace (or Google Apps) to a free Gmail account. Here’s…

Read More

The personal edition of Microsoft Office 365 is available for $6.99 per month on the official Microsoft website. This license includes all Microsoft Office apps. With the personal license, you’ll be able to install Microsoft Office on all your computers, phones and tablets through you can only be signed in to 5 device at the same time. You may buy a license for Microsoft Office 365 through the Microsoft website, through in-app purchases inside the Apple App Store or Google Play store or through online stores like Amazon. Office 365 Prices Comparison I did a quick comparison of Office 365…

Read More

When you delete any file or folder in your Google Drive, it is moved to the trash folder. The deleted file stays in trash for 30 days and then it is permanently deleted. You can right-click the deleted file in the trash bin and select Restore to undelete the file. Restore Permanently Deleted Files If you fail to restore a deleted file within the 30-day window, or if you have emptied the trash manually, the files will be permanently deleted from your Google Drive. You can however contact Google Support and they may restore the deleted files for you. Go…

Read More

With Google Drive, you can store files in the cloud and share them easily with anyone. Open any file in Google Drive, click the Share button and you’ll get a URL (link) that others can use to access your file. This is common knowledge but Google Drive has plenty of URL tricks up its sleeve that will make these simple Drive links even more powerful. Google Drive URL Tricks Google Drive Web Viewer Google Drive includes a built-in web viewer so people can view your shared files – from Microsoft Office documents to videos to AutoCAD drawings – directly in…

Read More

Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise

Read More

You can use Google Apps Script to find all the inactive user accounts in your Google Workspace domain. The script will find all the users that have not logged in to the domain for a period of time (say 6 months). You also have the option to delete the dormant accounts from Workspace domain and save on your monthly bills. Find the inactive users in Google Workspace domain We can use the Admin Directory service of Apps Script to list all the users (active and inactive) in a Google Workspace domain. Open a new script, go to Service section and…

Read More

Here we have an employee list spreadsheet with a column named Employee Name and a column named Employee ID. As soon as you enter a new employee name in the Employee Name column, the Employee ID column will automatically be filled with the help of an ARRAY FORMULA provided below: =ARRAYFORMULA(IF(ROW(A:A)=1, “Employee ID”, IF(NOT(ISBLANK(A:A)), ROW(A:A)-1, “”))) The formula adds the current row number to the Employee ID column if the current row is not the first row. If the current row is the first row, then the title is added to the cell. Also see: Google Sheets Formulas for Google…

Read More

This tutorial will show you how to import PayPal transactions into Google Sheets with the help of Google Apps Script. You can choose to import standard PayPal payments, recurring subscription payments, donations, or even refunds and chargebacks into Google Sheets. Once the data has been imported into Google Sheets, you can export them into a CSV file and import them into Quickbooks accounting software. Tally users in India can export PayPal transactions from Google Sheets into XML format and bulk import them into Tally. Also see: Automate PayPal with Google Forms Import PayPal Transactions in Google Sheets For this example,…

Read More

The Mail Merge for Gmail add-on lets you send personalized emails via Gmail but wouldn’t it be nice if a similar solution existed for sending personalized SMS to your contacts directly from your mobile phone? There are services, Twilio SMS for example, that let you send text messages programmatically to any phone number in the world. You can either build an SMS solution on top of these messaging APIs or you can take a simpler and less expensive route – build your own text-sending app with Google Sheets and MIT’s App Inventor. Play ; Before getting the implementation, let me…

Read More

This step by step guide will guide you on how to upload files to Google Drive with a service account using Node.js. For this example, we have a folder on your local hard drive containing multiple files and we are required to upload these files to a specific folder in Google Drive. 1. Create a Google Cloud Project Go to cloud.google.com and create a new Google Cloud project. Give your project a name, change the project ID and click the Create button. 2. Enable Google APIs Choose APIs & Services from the left menu and click on Enable APIs and…

Read More