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.

Send WhatsApp Messages with a Google Sheets Function

Learn how to send WhatsApp messages with a Google Sheets function

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