Author: admin
This tutorial describes how you can upload files and folders from your Google Drive to a bucket in Google Cloud Storage using Google Apps Script. You can even set up a time-based trigger, like a cron job, that watches a folder in your Google Drive and automatically upload new incoming files to Google Cloud Storage. The same technique can also be used to upload files from Google Drive to Firebase Storage. Create Google Cloud Storage Bucket To get started, go to console.cloud.google.com/projectcreate and create a new Google Cloud Project. Once the project has been added, go to console.cloud.google.com/storage/create-bucket and create…
FFmpeg is an extremely powerful and versatile command-line tool for converting audio and video files. It is free and available for Windows, Mac and Linux machines. Whether you want to join two video files, extract audio from a video file, split audio files, convert your video into an animated GIF, FFmpeg can do it all and even more. Extract the audio from a video file with this simple FFmpeg command. Useful FFmpeg Commands FFmpeg supports all popular audio and video formats. Or you can running the command ./ffmpeg -formats to get a list of every format that is supported by…
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
Google Developer Expert Google awarded us the Developer Expert title recogizing our work in Workspace ProductHunt Golden Kitty Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards Microsoft MVP Alumni Microsoft awarded us the Most Valuable Professional title for 5 years in a row Google Cloud Champion Google awarded us the Champion Innovator award for technical expertise
It is easy to embed a YouTube video but you’ll be surprised to know how much extra weight a single YouTube video embed can add to your web pages. The browser has to download ~900 kB of data (see screenshot) for rendering the YouTube video player alone. And these files are downloaded even before the visitor has clicked the play button. The embedded YouTube video not only increases the byte size of your web pages but the browser has to make multiple HTTP requests to render the video player. This increases the overall loading time of your page thus affecting…
A teacher may want to create folders in Google Drive for each of their students and share those folders with the students. This can be a tedious task if you have a large number of students but there’s a way to automate the process – you may either use an add-on or write an Apps Script to generate the folder structure. Prepare the Students’ Data in Google Sheets We’ve prepared a Google Sheet with the names of students, their corresponding classes and email addresses. The first row of the sheet displays the column titles, while the student data starts from…
NPM, short for Node Package Manager, is a widely-used tool for managing JavaScript packages in a project. It allows developers to install and update packages, as well as manage dependencies and scripts. NPM comes bundled with Node.js, so if you have Node installed on your machine, you automatically have access to NPM as well. npm Commands You Should Know This is not a tutorial for learning npm, the official docs are a good place to get started, but a collection of tips and tricks that will help you do more with the npm utility. Whether you’re a seasoned developer or…
This tutorial explains how to make phone numbers clickable within Google Sheets, Slides and Google Docs. When someone clicks on the phone number link in your spreadsheet or this document, it will open the dialer on their mobile phone and initiate dialing of the specified phone number. How to Insert Clickable Phone Numbers in Web Pages Let’s start with the basics. If you click an email link on a webpage, it opens your default mail program. Similarly, you can make phone numbers on your website “callable” meaning when someone clicks on the phone number link, it will automatically launch the…
The majority of email spam on the Internet originates from forged addresses because SMTP allows any computer to send emails claiming to be from anyone. For instance, a spammer can put your email address in the “From” field when sending out bulk emails and the recipients may therefore incorrectly assume that the mail is coming from you. If any of them chooses to report that spoofed message as spam, its your email address that will be affected in the long run. Authenticate your Google Workspace Domain with SPF To prevent spammers from forging the “From” field of their bulk messages…
Conditional content allows you to customize your Google Docs template and generate different versions of the same document based on the user’s answers. In this tutorial, I’ll show you how to use conditional content in Google Docs using Document Studio, a Google add-on that automates document creation. If you are new here, please follow this step-by-step guide on how to generate documents from data in Google Sheets and Google Forms responses. Conditionally Display Content Let’s say you are a recruiter who wants to use a Google Docs template to send out job offer letters to candidates. You want to include…
Mail Exchange (MX) records, in simple English, tell the internet where to deliver your emails. These records enable email servers to know which mail servers are responsible for accepting incoming messages for a given domain. When you are using Gmail with your Google Workspace domain, Google provides you with a set of MX records in the format ASPMX.L.GOOGLE.COM and you need to add five such records to your domain. These MX records point incoming emails to Google’s mail servers, which then deliver the emails to your Gmail inbox. PriorityHost / Mail Server1ASPMX.L.GOOGLE.COM5ALT1.ASPMX.L.GOOGLE.COM5ALT2.ASPMX.L.GOOGLE.COM10ALT3.ASPMX.L.GOOGLE.COM10ALT4.ASPMX.L.GOOGLE.COM These MX records specify the priority and destination…
Whether you are looking to learn a programming language, enhance your Microsoft Excel skills, or acquire knowledge in Machine Learning, Udemy probably has a video course for you. Udemy courses are usually affordable, there are no subscription fee and you can learn at your own pace. Free Udemy Courses on Programming While most video tutorials on Udemy require payment, the website also offers some of their highly-rated courses for free. I’ve prepared a Google Sheet that lists all the free programming courses currently available on Udemy. The spreadsheet is updated automatically every few hours. You can also access the web…