How to Send WhatsApp Messages from Google Sheets with the WhatsApp API and Apps Script

Learn how to use the WhatsApp API to send personalized messages from Google Sheets to your WhatsApp contacts.

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 Embed Images from Google Drive on your Website

This tutorial describes how you can display images stored in your Google Drive on your website or emails. All image files on Drive have a high-resolution thumbnail that you can embed into any webpage.

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 Sheet and play the MP3 audio when you click the Play button.

How to Auto-Download Podcasts to Google Drive with Google Sheets

You use Google Sheets as your own Podcast Manager that will automatically download your favorite podcasts to Google Drive and instantly sync across all your devices.

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 Generate Dynamic QR Codes to Collect Payments through UPI

This tutorial explains how you can create QR Codes and merchant badges for collecting UPI payments through Google Pay, PhonePe, PayTM, Amazon or any BHIM UPI apps.

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 Extract Text from PDF Files with Google Apps Script

This tutorial explains how you can parse and extract text elements from invoices, expense receipts and other PDF documents with the help of Apps Script.

How to Use Conditional Formatting in Google Sheets to Highlight Information

Conditional formatting in Google Sheets allows you to apply automatic formatting to cells in spreadsheets that meet certain criteria. Check out some practical examples and master conditional formatting in Google Sheets.

How to Insert Images in Google Sheet Cells

Learn about the different approaches that will help insert images in Google Sheets and understand the reason why you may prefer one approach over the other.

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 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 Import PayPal Transactions into Google Sheets

Learn how to easy import transactions from PayPal into Google Sheets with Google Apps Script. You can import standard transactions, recurring subscriptions and donations.

Simple URL Tricks for Google Drive You Should Know

Learn about secret URL tricks for Google Drive to quickly create direct download links, copy or preview shared files in Drive.

How to Recover Permanently Deleted Files and Folders in Google Drive

Did you empty the Drive trash folder accidentally? Learn how to restore files and folders that you have permanently deleted from your Google Drive.

View Microsoft Office Files in the Browser without Downloading

Office Web Apps Viewer and Google Drive Viewer can come handy when you don't have any Office suite installed on your computer or when you would like to quickly preview any online Office file in the browser without having to download it locally.

How to Create Photo Stickers in Canva

Learn how to design your own outline stickers from photos in Canva with transparent background.

How to Save Money on your Microsoft Office 365 Subscription

Looking to buy a subscription of Microsoft Office 365 for your home or small business? Here are some tips to save money on your office 365 subscription.

How to Copy Email Messages from Google Workspace to another Gmail Account

This step by step guide explains how you can easily move all your email messages from your Google Workspace (GSuite) account to a Gmail account. The archived emails will be available in Gmail even if the original email account is deleted.

How to Use Hyperlinks in Google Sheets

How to Factory Reset your Gmail Account

How to Embed Google Maps in your Website Responsively and Lazily

How to embed Google Maps to your website in a responsive manner with lazy loading. The maps will resize based on the device screen and load only when the user scrolls to the map thus making the page load faster.

How to Create Dynamic Open Graph Images with Google Sheets

Generate dynamic Open Graph images for your website with Google Sheets without requiring Puppeteer. All pages on your website can have their own unique Open Graph images created from a Google Slides template.

How to Hide Empty AdSense Slots When No Ads are not Available

When there are no advertisers available for a specific page, Google AdSense will replace the ad units on that page with a blank space. You can easily hide the empty slots with the help of CSS

How to Import Canva Designs into Google Slides

Learn how to import Canva presentations into Google Slides. You can convert any graphics or Canva template into a PowerPoint or Slides deck.

The Best Google Chrome Extensions

A collection of the best Google Chrome extensions to improve your web experience and enhance productivity.

How to Request Stripe Payments with Google Sheets

How to use Google Sheets to generate Stripe payment links and request payments in any currency from your customers anywhere in the world!

How to Make Phone Numbers Callable in Google Sheets

Save Web Pages As An Image with Screenshot Guru

Learn how to convert HTML web pages into a high-resolution image without using any apps

Twitter Screenshots - The Best Way to Embed Tweets in Web Pages

Tutorial: How to Make Cinemagraphs with Photoshop

Get Extra Email Addresses for your Gmail Account with Aliases

Learn how to create an alias in Gmail in few easy step. When you setup an alternate email address, you can also send emails on behalf of that email alias in Gmail.

How to Write a Successful Blog

I share some of my learnings and blogging tips that will help take your blog to the next level

How to Get the Permanent URL of an Email Message in Gmail with Apps Script

When you send an email with Google Apps Script, the Gmail API returns a unique ID that you can use to determine the URL of the email message in your sent items.

How to Make Someone Else's YouTube Playlist Your Own

How to Change the Date Format in Google Sheets

You can customize the date format in a Google Sheet with the TEXT function and completely change the way the date and time values are displayed in the worksheet.

Useful Regular Expressions for Validating Input in Google Forms

Collection of regular expressions to validate user input in Google Forms quizzes and surveys.

Find Product Prices in Google Sheets with Vlookup and Match Functions

How to use the Index and Vlookup functions in Google Sheets with Match and ArrayFormula to lookup product prices that are listed as a table in the spreadsheet.

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.

The 101 Most Useful Websites on the Internet

The most useful websites on the Internet that will make you smarter, increase productivity and help you learn new skills

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

Useful npm Tips and Tricks that Developers Should Know

This is a collection of npm tips and tricks that every developer should know. If your work involves working with npm packages, you should find these npm commands useful.

Essential Date Functions for Google Sheets

Master all the important date functions for Google Sheets with working formula examples. Whether you are looking to calculate the number of working days before the project is due or days until your upcoming birthday, this is the place to start.

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.