Author: admin

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…

Read More

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…

Read More

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…

Read More

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…

Read More

As spring arrives, March presents an excellent opportunity for a delightful holiday across India, characterized by its pleasant climate and a plethora of festivals and fairs celebrated nationwide. With the sun shining warmly and gentle breezes blowing, March is an ideal time to explore the dense forests of Central India, the verdant tea plantations of the North-East, the breathtaking beaches along the Arabian Coast, and the majestic hills in the South, all included in various India tour packages. For adventure enthusiasts and water sports lovers, this month is particularly suitable for visiting India’s adventure destinations. To kick off your holiday…

Read More

Let’s build a simple web application that uses Google OAuth 2.0 to access Google APIs. The user can sign-in with their Google account and authorize the application to access their Google Drive or any other Google service. When the user signs in, Google redirects the user to the Google OAuth 2.0 authorization page. The user is asked to grant access to the application. The application then exchanges the authorization code for an access token and a refresh token. The access token will expire after an hour but the refresh token will be valid indefinitely (unless manually revoked by the user).…

Read More

Due to the diverse array of religions in India, various festivals are celebrated throughout the year. As winter transitions into spring, March emerges as an ideal time to visit India, characterized by pleasant weather and a multitude of vibrant festivals, each more joyous than the last. This month is affectionately referred to as the month of colors, as it marks the celebration of Holi, one of India’s most exuberant festivals. To fully immerse yourself in these cultural festivities, consider planning your trip as part of India tour packages around the festival dates. Below is a list of some remarkable Indian…

Read More

The BHIM UPI payment system has transformed the way we pay for goods and services in India. You scan a QR Code with your mobile phone, enter the secret PIN and the money gets instantly transferred from your bank account to the merchant’s bank account. There’s no transaction fee, the money is transferred in real-time and no data of the payer is shared with the payee. Our online store initially accepted payments through credit cards only but after we added the UPI QR Code on the checkout page, more that 50% of customers in India are making payments through UPI.…

Read More

Let’s create a simple website scraper that download the content of a web page and extract the content of the page. For this example, we will use the New York Times website as the source of the content. The scraper will extract the top 10 news headlines on the page and display them on the web page. The scraping is done using the Puppeteer headless browser and web application is deployed on Firebase functions. 1. Initialize a Firebase Function Assuming that you have already created a Firebase project, you can initialize the Firebase functions in a local environment by running…

Read More

This tutorial describes how you can use Google Sheets to build your own podcast manager. You can specify a list of your favorite podcast shows in Google Sheets and it will automatically download new episodes to your Google Drive in neatly organized folders. The setup is very simple, the app is completely open-source and you need no programming language. How the Drive Podcast Manager Works? You have to place the links of your favorite podcasts in column A of the Google Sheet as shown in the screenshot below. The app will automatically download the latest episodes of each podcast to…

Read More

You can put the link of any MP3 audio file in Google Sheets but when you click the file link, the audio would not play. You can however add a button in your Google Sheet that, when clicked, will play the MP3 file in a modal window. Here’s a demo: The audio files are hosted on Google Drive and when the Play button is clicked, the app will open a modal window with the audio player. Add the Audio Player Button To get started, create a new Google Sheet, go to the Insert menu and select the Create a New…

Read More

Let’s say you have built an add-on for Google Sheets that adds a new menu item to the sheets UI. You would now like to add an option in the menu that, when clicked, will redirect the user to your website without the user having to click any other button. For instance, in this demo Google Sheet, we have a parent menu and a sub-menu that opens the underlying website in the new window. As a first step, we’ll add a custom menu in the Google Sheet and invoke it from the onOpen function so the menu is always available…

Read More