How-to Guides - Page 4 of 128

Color Codes for Google Spreadsheets

How to Calculate the Percentage Score in a Google Forms Quiz

Learn how to find the percentage score of a quiz in Google Form with the help of a Google Sheets formula.

How to Block Google Analytics from Tracking your Visits

How to Auto Format Google Form Responses in Google Sheets

Learn how to automatically preserve the formatting in Google Sheet when new Google Form responses are submitted.

The Most Useful Twitter Bots

The most useful Twitter utility bots that work within the Twitter ecosystem.

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.

Send WhatsApp Messages with a Google Sheets Function

Learn how to send WhatsApp messages with a Google Sheets function

Read This Before You Buy Any Udemy Course

How to Send WhatsApp Messages from Google Sheets using the WhatsApp API

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

Always on Top: Keep Any Window Visible Always

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