Labnol

Digital Inspiration

Tech, a la carte


Create a Keyboard Shortcut for Apple Intelligence Writing Tools on Mac

[2024-11-03 1:30 pm]

The recent release of Apple Intelligence has added a new set of helpful AI writing tools to your Mac. You can proofread emails, summarize…

The recent release of Apple Intelligence has added a new set of helpful AI writing tools to your Mac. You can proofread emails, summarize…


How to Generate Software License Keys and Verify Them

[2024-10-06 1:30 pm]

You are running a small software business that sells digital downloads - apps, plugins, or even templates. When the buyer completes the…

You are running a small software business that sells digital downloads - apps, plugins, or even templates. When the buyer completes the…


How to Accept Online Payments with Zoho Payments

[2024-10-04 1:30 pm]

Zoho Payments is a new payment gateway that lets you accept payments on your website. You can visit this sample store to see the Zoho…

Zoho Payments is a new payment gateway that lets you accept payments on your website. You can visit this sample store to see the Zoho…


How to Export WooCommerce Customers to Google Sheets

[2024-10-02 1:30 pm]

If you are running an online store running on WordPress, chances are you are using WooCommerce to manage your customers and orders. The…

If you are running an online store running on WordPress, chances are you are using WooCommerce to manage your customers and orders. The…


How to Rollback Changes to a Specific Commit in Github

[2024-09-03 1:30 pm]

Let's say you have a Github repository where you push all your code changes. Each commit has a unique commit hash, and you can use this hash…

Let's say you have a Github repository where you push all your code changes. Each commit has a unique commit hash, and you can use this hash…


How to Convert Google Slides to PNG Images with Google Script

[2024-07-15 1:30 pm]

Document Studio can convert Google Slides into high-resolution PNG images. This can be useful if you want to create multiple variations of…

Document Studio can convert Google Slides into high-resolution PNG images. This can be useful if you want to create multiple variations of…


Find Legitimate Emails in your Gmail Spam Folder with AI and Google Script

[2024-06-06 1:30 pm]

False positives in Gmail are uncommon but can happen, meaning an important email might mistakenly end up in your spam folder. When you're…

False positives in Gmail are uncommon but can happen, meaning an important email might mistakenly end up in your spam folder. When you're…


How to Add a Universal Custom Menu to Multiple Google Workspace Apps

[2024-05-20 1:30 pm]

Adding a custom menu in Google Sheets, Docs, Slides, and Forms using Google Apps Script is straightforward. As an illustration, the…

Adding a custom menu in Google Sheets, Docs, Slides, and Forms using Google Apps Script is straightforward. As an illustration, the…


Send Personalized Emails with SMTP and Mail Merge in Google Sheets

[2024-04-30 1:30 pm]

The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail…

The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail…


An Improved SUBSTITUTE Function for Replacing Multiple Values in Google Sheets

[2024-04-24 1:30 pm]

Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For…

Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For…


How to Extract Email Addresses from Gmail Messages

[2024-04-12 1:30 pm]

A fintech startup is preparing to host its first-ever networking event for professionals within the industry. Over the course of their…

A fintech startup is preparing to host its first-ever networking event for professionals within the industry. Over the course of their…


How to Move Files Uploads from Google Forms to Specific Folders in Google Drive

[2024-04-11 1:30 pm]

The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File…

The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File…


How to Add Password to PDF Documents in Google Drive

[2024-04-05 1:30 pm]

The Document Studio add-on helps you create personalized PDF documents from Google Sheets. You can generate invoices , certificates…

The Document Studio add-on helps you create personalized PDF documents from Google Sheets. You can generate invoices , certificates…


How to Request UPI Payments with Google Forms

[2024-04-03 1:30 pm]

Cake Studio is a local bakery that accepts orders through Google Forms. When a customer places an order, the customer automatically receives…

Cake Studio is a local bakery that accepts orders through Google Forms. When a customer places an order, the customer automatically receives…


How to Access Secrets from Google Secret Manager using Apps Script

[2024-03-29 1:30 pm]

Google Secret Manager is a cloud service where you can store sensitive data such as passwords, database credentials, encryption keys or any…

Google Secret Manager is a cloud service where you can store sensitive data such as passwords, database credentials, encryption keys or any…


How to Email Screenshots of Google Sheets on a Schedule

[2024-03-27 1:30 pm]

The finance team has created a revenue dashboard inside Google Sheets to track the company's sales performance over time. The dashboard has…

The finance team has created a revenue dashboard inside Google Sheets to track the company's sales performance over time. The dashboard has…


How to Create Multiple Sub-folders in Google Drive Automatically

[2024-02-28 1:30 pm]

A teacher would like to create separate Google Drive folders for each student in her class. Within each student's folder, there will be…

A teacher would like to create separate Google Drive folders for each student in her class. Within each student's folder, there will be…


How to Schedule Form Availability and Limit Submissions in Google Forms

[2024-02-27 1:30 pm]

When you create a Google Form , it is public by default meaning anyone who has the link to the form can submit a response. There forms…

When you create a Google Form , it is public by default meaning anyone who has the link to the form can submit a response. There forms…


How to Send Email Reminders for Google Forms Automatically

[2024-02-21 1:30 pm]

You are using Google Forms to collect registrations for an upcoming event and would like to send email reminders to all the registered…

You are using Google Forms to collect registrations for an upcoming event and would like to send email reminders to all the registered…


How to Automatically Copy Google Forms Responses to any other Spreadsheet

[2024-02-19 1:30 pm]

Google Forms is a perfect tool for collecting data, from event registrations to customer feedback. By default, your Google Form responses…

Google Forms is a perfect tool for collecting data, from event registrations to customer feedback. By default, your Google Form responses…


How to Verify API Keys for Gemini AI and OpenAI with Google Apps Script

[2024-02-15 1:30 pm]

Are you developing Google Sheets functions or Google Workspace add-ons that tap into the power of Google Gemini AI or OpenAI? This…

Are you developing Google Sheets functions or Google Workspace add-ons that tap into the power of Google Gemini AI or OpenAI? This…


How to Send Confirmation Emails with Google Forms

[2024-02-01 1:30 pm]

You have a Google Form and you would like to send an auto-confirmation emails to the person as soon as they submit the form. The…

You have a Google Form and you would like to send an auto-confirmation emails to the person as soon as they submit the form. The…


How to Find the Wi-Fi Password of your Current Network

[2024-02-01 1:30 pm]

Imagine this scenario - your computer is connected to a Wi-Fi network but you do not remember the password that you previously used to…

Imagine this scenario - your computer is connected to a Wi-Fi network but you do not remember the password that you previously used to…


How to Automatically Rename Files in Google Drive with Apps Script and AI

[2024-01-28 1:30 pm]

Do you have image files in your Google Drive with generic names like IMG_123456.jpg or Screenshot.png that offer no context about what…

Do you have image files in your Google Drive with generic names like IMG_123456.jpg or Screenshot.png that offer no context about what…


How to Send Google Forms Responses in an Email Message

[2024-01-13 1:30 pm]

Google Forms are a perfect tool  for creating online forms and surveys. The forms are responsive and mobile friendly, and they look…

Google Forms are a perfect tool  for creating online forms and surveys. The forms are responsive and mobile friendly, and they look…