Author: admin

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…

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…

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…

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

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…

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…

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,…

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…

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…

You have been invited to a meeting that would last really long. You cannot say “no” but secretly wish that someone calls your phone in the middle of that never-ending meeting and rescue you from the boring situation. Well, you can take the help of a human friend or use IFTTT, the versatile automation app available for both iPhone and Android. With IFTTT, you can easily create a workflow (applet) that would simulate a fake phone call to yourself at the scheduled time and help you smoothly exit that meeting. What’s new then? The phone calling service has been part…

You are planning to buy a cell phone from an online shopping site of another country but are not too sure if that phone will work with the mobile networks of your country. Or consider a slightly different scenario. You are travelling but how do you determine if your existing cellphone will be compatible with carriers of the foreign country? Will that Cell Phone Work in my Country? Well, there are basically two factors that may help you determine if a mobile phone will work with cellular operators of another country or not. Here they are: Check Network Technology: GSM…

Your Samsung Galaxy phone ships with Bixby, the voice assistant that is tightly integrated with the phone. However, if you prefer to use Google Gemini instead of Bixby, here’s a quick guide to help you through the process. In the default configuration, when you press and hold the side button of your Galaxy phone, Bixby will wake up waiting for you to ask a question. Let’s see how we can use the same power button to wake up Google Gemini on your phone. Step 1: Install Google Gemini If you haven’t done so already, go to the Google Play Store…