Author: admin
Whether it is a wedding party or a business conference, those tent-shaped place cards are ideal for helping your guests find their seats at the event. This tutorial explains how you can create personalized place cards with the names of your guests and the table number to which they have been assigned. We’ll use Google Sheets to create the party seating plan, Google Slides to design the place card template and Document Studio to generate those place cards as PDF files in Google Drive. Let’s get started. Create Guest Seating Plan Create a new spreadsheet inside Google Sheets (sheet.new), enter…
A school provides email accounts for students that are enrolled in high school. The school has published a Google Form and any student can put their name in the form to request access to an email address. Parent’s consent is required though. When a child submits the request, an email confirmation is sent to the parent of the child for them to provide consent before the student’s email address can be created. Lookup Parent’s Data in Google Sheets The key here is that an email should be sent to the parent of the student. This data itself is not available…
Would you like to know how much traffic (or page views) other websites in your niche are getting for competitive analysis? While it will be difficult for any third-party to accurately measure the traffic of a site, there are a bunch of traffic estimation services that can give you a better understanding of the popularity of a website. Here’s a list: 1. Similar Web – It started as a tool for finding similar sites but now offers a range of data including traffic analysis in a clean interface. You get to know the site’s traffic over time, the countries that…
The Document Studio add-on helps you automatically send text messages when a new Google Form is submitted or when new rows are added to Google Sheets. You can thus build workflows that send text reminders when the invoices are due. Or you can get notified instantly when people fill out your Google Forms. The SMS Workflow The text messages in Document Studio are sent through Twilio but the app can be integrated with any SMS service as long as the service offers an API for sending text messages programmatically. You may use TextMagic, SimplyTexting, Vonage, ClickSend, RingCentral, or any SMS…
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
An order form, created in Google Forms, requires customers to provide their full name, the item quantity and whether home delivery is required. The final bill amount is calculated with a simple formula in Google Sheets. // Item cost is $99 per unit. Delivery cost is $19. =IF(ISNUMBER(C2), SUM(C2*99, IF(D2=”Yes”, 19, 0)), ) The Google Sheet owner has entered the formula across all rows in the Total Amount column so that the value is automatically calculated when a new form response is submitted. The problem is that the formulas in Google Sheets are automatically deleted when new responses come in.…
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…