Author: admin

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…

In a previous tutorial, we used a service account to connect to the Google Drive API from a Node.js application. We cannot use a service account to impersonate a Gmail account, but we can use the GMail API with Node.js and Nodemailer to send emails from a user’s own Gmail or Google Workspace account. You may however use external services, such as Amazon’s SES or Twilio’s SendGrid, to send emails from a service account. In this tutorial, we will describe how to send emails from a Gmail account using the GMail API and a Node.js application. Please note that Gmail…

This tutorial explores the different options for inserting images in Google Sheets. We’ll also discuss the advantages and limitations of each method. Use the IMAGE function to insert images into any cell of your Google Sheets. Use the Insert menu in Google Sheets to directly insert images into cells. Use the CellImageBuilder API to programmatically insert images with Google Apps Script. Use the IMAGE function To add an image to a cell, highlight the cell and click F2 to enter the formula mode. Next, enter the formula =IMAGE(“URL”) where URL is the public web address of that image. For instance, the following…

Conditional formatting in Google Sheets makes it easy for you to highlight specific cells that meet a specific criteria. For instance, you can change the background color of a cell to yellow if the cell value is less than a certain number. Or you can choose to highlight an entire row or column if certain conditions are met. Highlight Individual Cells For this example, we have a sales chart that lists the names of salespeople, their state and the total sales target. We would like to highlight individual cells in the State column if the salesperson is from California. Go…

An external accounting system generates paper receipts for its customers which are then scanned as PDF files and uploaded to a folder in Google Drive. These PDF invoices have to be parsed and specific information, like the invoice number, the invoice date and the buyer’s email address, needs to be extracted and saved into a Google Spreadsheet. Here’s a sample PDF invoice that we’ll use in this example. Our PDF extractor script will read the file from Google Drive and use Google Drive API to convert to a text file. We can then use RegEx to parse this text file…