OR 

How to Use Hyperlinks in Google Sheets

This guide explains how you can easily create and manage hyperlinks in Google Sheets. An entire cell in the sheet, or specific text inside the cell, can be linked to external web pages. A cell can also contain multiple hyperlinks. If you type a web

favicon of http://www.labnol.org

Let People Quickly Save your Events on their Calendars

You are organizing an online event - maybe a meeting on Zoom or a training session hosted on Google Meet - and you would like the attendees to add the event to their own calendars. Once added to their calendar, the event will act as an automatic

favicon of http://www.labnol.org

How to Create Zoom Meetings with Google Script

This guide describes how you can programmatically create user meetings in your Zoom account with the help of Google Apps Script and the official Zoom API. As a first step, go to the Zoom Developer Dashboard and create a new app . Choose JWT as the

favicon of http://www.labnol.org

How to Download Speaker Notes in Google Slides

With Creator Studio , you can easily convert your Google Slides presentation into animated GIFs and video slideshows . The add-on can also extract speaker notes from your slides and export them as a text file in Google Drive. To get started, open

favicon of http://www.labnol.org

Awesome Mac Apps and Utilities - 2020 Edition

Whether you are a new Mac user or a seasoned veteran looking to do even more amazing things on your Mac, check out this updated collection of lesser-known but awesome Mac Apps of 2020. The majority of apps listed here are free and they‘ll appeal to

favicon of http://www.labnol.org

How to Get Hidden and Filtered Rows in Google Sheets with Google Script

You can hide entire rows in Google Sheets manually or use filters to hide any rows that matches the specified criteria. For instance, if you have a sheet containing orders from different countries, you can set up a country filter to hide all rows

favicon of http://www.labnol.org

SlideCasts - Sync YouTube Videos with your Google Slides Presentation

SlideCasts let you combine YouTube videos and Google Sides / PowerPoint presentations in a single-player. The speaker video and the slides appear side-by-side and, as the video progresses, the slides auto-change in sync with the video. You can try a

favicon of http://www.labnol.org

How to Embed Google Slides Like a Pro!

It takes 2 easy steps to embed any Google Slides deck in your website. Open Google Slides, go to the File Menu and choose Publish to web. Your presentation becomes public and you are presented with an IFRAME HTML tag that you can copy-paste in any

favicon of http://www.labnol.org

How to Make Pixel Paintings with Google Spreadsheets

You have been using Google Sheets for budgeting and business but there‘s another interesting use of spreadsheets - you can use them to create impressive pixel paintings in minutes. Marina and Mallory created a bright and beautifulwall muralusing

favicon of http://www.labnol.org

How to Use Images in Gatsby

This guide explains how you can use the gatsby-image plugin with GraphQL queries to display optimized images inside your Gatsby pages and React components. The images are lazy-loaded with blurred SVG background, the large images are resized

favicon of http://www.labnol.org

How to Use Google Sheets with D3.js and Google Visualization

The D3.js visualization library can be used for creating beautiful graphs and visualizations using data from external sources including CSV files and JSON data. https://www.youtube.com/watch?v=se7o9jvxbEE To give you an example, this D3.js animation

favicon of http://www.labnol.org

How to Sell Digital Products Online with Google Drive and PayPal

The web has made it incredibly easy for anyone to sell digital products directly to customers through websites, social media, and email newsletters. You can sell PDF ebooks, event tickets, MP3 music , photos, gift cards, software apps , license

favicon of http://www.labnol.org

How to Create a Disposable Email Address with Gmail

A temporary email address is very useful when you don‘t want to share your real email address with a website. There are a plethora of services - 10 Minute Email , Mailinator and MailDrop to name a few - that will mask your main email address

favicon of http://www.labnol.org

How to Use Conditional Fields in Email Templates

The Mail Merge and Document Studio add-ons let you send personalized emails with the help of template markers. The markers automatically create a mapping between the column names in the Google Sheet and the variable fields in your email message

favicon of http://www.labnol.org

How to Add an XML Sitemap to your Blogger Blog

The XML Sitemap file is like a directory of all web pages that exist on your website or blog. Google, Bing and other search engines can use these sitemap files to discover pages on your site that their search bots may have otherwise missed during

favicon of http://www.labnol.org

How to Factory Reset your Gmail Account

Your phone, the iPad, and your laptop offer a ‘hard reset‘ option that resets your device to the default factory settings. Once you perform a factory reset, it erases all the apps, files, and settings and there‘s no way to recover the wiped off data

favicon of http://www.labnol.org

How to Send Google Forms with Pre-filled Answers

Prefilled Google Forms , where some of the fields in the form are pre-populated with answers you already have, make the process of filling out your forms easier and faster. Your contacts are more likely to fill out the form as it takes less time for

favicon of http://www.labnol.org

How to Add Options in Google Forms Questions from Google Sheets

A school is trying to create a Google Form where students can register their details. The form would have a drop-down of countries, the names of class teachers as a multiple choice question and a checkbox style question where students can pick one or

favicon of http://www.labnol.org

How to Track Unsubscribes with Mail Merge for Gmail

Mail Merge for Gmail gives you can easy option to add an "Unsubscribe" link to all your outgoing email campaigns. When an email recipient clicks the unsubscribe link, the status of their email address is set to UNSUBSCRIBED and you will not able to

favicon of http://www.labnol.org

How to Handle GET and POST HTTP Requests in Google Apps Script

With Google Apps Script, you can easily create a Web App that serves HTML, JSON, XML or plain text output using the HTML service. When your publish your Google Script project as a web app, the script gets a public URL (think API) that can be invoked

favicon of http://www.labnol.org