How to Sort Google Sheets Automatically with Apps Script

If you are working with a Google Sheet that has a large number of tabs, it can be difficult to find the sheet you need if they are not organized properly. Use Google Apps Script to sort sheets automatically

How to Efficiently Read Email Messages with the Gmail API and Apps Script

How to read email messages with the Gmail API and the UrlFetch service of Apps Script

How to Use Gmail SMTP Server for Sending Email

Learn how to use the Gmail SMTP server for sending emails from your own Gmail account.

How to Schedule a Meeting in Google Meet with Apps Script

Learn how to setup a video meeting inside Google Meet with the Google Calendar API and Apps Script

How to Open a Website in New Window from Google Sheets Menu

This tutorial how to open a web page in new window from a menu option in Google Sheets

How to Play an MP3 File in Google Sheets

This tutorial explains how to embed an audio file in Google Sheets and play the MP3 audio when you click the Play button.

How to Build a Website Scraper with Puppeteer and Firebase Functions

This tutorial explains how you create a web scraper with Puppeteer and deploy it on the web with Firebase functions.

How to Build a HTML Form for Uploading Files to Google Cloud Storage

This tutorial explains how you can build a file upload form for uploading files to Google Cloud Storage. The uploaded files can be made pubic or private.

How to Use Google OAuth 2.0 to Access Google APIs with Refresh Token

This tutorial explains how you can sign-in with Google OAuth 2.0, store the refresh token in database and access the various Google APIs with the access token generated from the refresh token.

How to Upload Files to Google Drive with Node.js, Express and Multer

This tutorial explains how you can upload files to Google Drive that are submitted through a web form and encoded as multipart/form-data.

How to Split a PDF file into Separate PDF Documents

Learn how to split any PDF file into multiple PDF files from the command line without requiring Adobe Acrobat or any expensive PDF manipulation library

How to Send Email with the Gmail API and Node.js

This tutorial explains how you can send emails from your own Google account using the Gmail API and Nodemailer without any UI.

How to Upload Files to Google Drive with a Service Account

This tutorial explains how you can connect to Google Drive or any other Google API from a service account without user authentication.

How to Send SMS Messages with Google Sheets and Android Phone

Send personalized text messages to your contacts with the help of Google Sheets and Android phone. The SMS messages go directly from your phone SIM, no third-party SMS service is required.

How to Get the Last Row in Google Sheets when using ArrayFormula

Find and Remove Inactive Users in your Google Workspace Domain

Learn how to find inactive users in your Google Workspace domain and delete the dormant accounts to save on your monthly bills.

How to Extract URLs from HYPERLINK Function in Google Sheets

How to Use Hyperlinks in Google Sheets

How to Factory Reset your Gmail Account

How to Check if the Google User has a Google Workspace Account

Create Google Cloud Function to Generate Images in Google Cloud Storage

How to create a Google Cloud Function to generate open graph images from Google Slides template in Google Drive

Manage Shared Drives in Google Drive with Google Apps Script

How to Use the Stripe Payments API with Google Apps Script

How to use the Stripe Payments API with Google Apps Script

How to Use PayPal Subscriptions API with Node.js

How to use the PayPal Subscriptions API with Node.js to manage recurring payments on serverless cloud functions.

How to Convert Image to Base64 Data URI

How to convert an image to a base64 data URI with Google Apps Script or the HTML5 Canvas API.

List All Users of a Google Workspace Domain in Google Sheets

Convert PDF Files to Text with Google OCR

How to Find and Replace Text in Google Docs with RegEx Search Patterns

How to Import Lodash in your JavaScript Projects for Lowest Bundle Size

How to correctly include specific functions of the popular lodash library in your web JavaScript project without having to import the entire library.

Convert a Google Document into an EPUB File

How to Force Reset Google Workspace Users' Passwords with Apps Script

Learn how the Google Workspace admin can change the Google account passwords of multiple users in their organization automatically with Google Apps Script.

Make all Shapes the Same Size in Google Slides

Make all shapes in Google Slides the same size as the height and width of the first shape.

Improve Performance of Google Apps Script with Memoization

How to use JavaScript memoization to optimize and improve the performance of your Google Apps Script code.

How to Delete Blank Rows from Tables in your Google Documents

How to remove all blank rows from one or more tables in a Google Docs document with Google Apps Script. You may also delete blank rows from tables in Google Slides.

How to Request Payments with Razorpay and Google Sheets

How to use Google Sheets to generate Razorpay payment links and easily accept payments from customers anywhere in the world!

How to Share Files in Google Drive with Multiple Users

How to Convert HTML to PDF with Google Script

Learn how to convert HTML files to PDF documents in your Google Drive with the help of Google Scripts and Cloud Functions

How to Create a Telegram Bot for Sending Notifications using Google Apps Script

Learn how to create your own Telegram bot with Google Apps Script and post notification messages from Google Sheets, Forms and other Google apps.

How to Use Notion with Gmail and Google Sheets using Apps Script

How to use the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.

Sort by Random - How to Randomize the Order of Rows in Google Sheets

Learn how to sort your data in a Google Sheet in randomized order using Excel formulas and Google Apps Script.

Exceeded maximum execution time Exception in Google Apps Script

How to Replace Accented Characters (diacritics) with English letters in Google Sheets

The Google Sheets function will convert diacritics letters or characters with accents to their simple Latin equivalent. For instance, á or à will change to 'a', ê or ë will be replaced with e and so on.

How to Use Google Text to Speech API

How to Change the Font in your Google Documents with Apps Script

How to change the font family and font styles of multiple Word documents in your Google Drive with Apps Script

How to Replace Text and Hyperlinks in Google Documents with Apps Script

How to Convert Column Number (e.g. 28) to Column Letter (e.g. AB) in Google Sheets

Convert column letters (AA) to corresponding numbers, or covert column numbers to A1 notation cell references in Google Sheets and Microsoft Excel.

Google Documents - How to Replace Text in Header and Footer

How to find and replace text in the Word document's header and footer section using the Google Document API.

Create React App with Multiple Entry Points

How to build a multi-page React application with multiple entry points using Create React App without ejecting.

Google Sheets - Find Values in One Column that are Missing in Another Column

How to compare columns in Google Sheets and highlight cell values that are in one column but missing in another column.

Get Email Alerts When COVID-19 Vaccines Become Available Near You

Monitor the availability of Covid-19 Vaccines in your city and get email alerts when vaccine doses are available for people above 18 years of age.