Author: admin

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…

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…

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).…

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…

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

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…

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…

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…

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…

Looking for a place to host images so you can embed them on to your website? The most popular image hosting services are imgur.com and imgbb.com but did you know that you can also use Google Drive to host images. It works something like this. You upload an image file to Google Drive and make that file public. Google Drive will now generate a high-resolution thumbnail image of the uploaded file that you can directly embed on your website or emails. Generate Google Drive Image Links 1. Share File Go to Google Drive and upload the image that you wish…

This Apps Script sample shows how you can programmatically schedule video meetings inside Google Meet with one or more participants using the Google Calendar API. It can be useful for teachers who wish to schedule regular meetings with their students but instead of manually creating meeting invites, they can easily automate the whole process for the entire class. Setup Google Meeting with Apps Script Give your meeting a title, the start date, the meeting duration, the list of attendees and how often you wanted to be reminded of the upcoming Google meeting. A new meeting event will be added to…