پیچک

Lea how to create online forms with file uploads that save files to Google Drive. The forms use Google Forms style responsive material design and the responses are saved in a Google Spreadsheet. Google Forms arexa0probably the best service for creating online forms but they miss a few key features found inxa0commercial web form builders. Google Forms do not allow file uploads, there’s no option forxa0adding CAPTCHA in forms to prevent spam and, what may be of interest to the legal and retail ind...

Lea how to create impressive pixel paintings with Google Spreadsheets. You can convert any image into pixel art with little effort. You may have been using Google Spreadsheets for budgeting and project management but did you know that the same sheets application can also help you create impressive pixel paintings in minutes? The Google blog recently published a storyxa0ofxa0two illustrators who created a bright and beautifulxa0wall muralxa0usingxa0Google Spreadsheets. Marina and Mallory conne...

Lea how to temporarily share files in Google Drive that are accessible for a limited time. You can set an auto-expiry date and the shared Google Drive links will stop working after the specified date and time. Works for both Gmail and Google Apps accounts. When you share any file or folder in Google Drive with another user, the shared links will work forever unless you manually change the sharing permissions. For instance, if you have shared a document with an exteal vendor, they’ll continue to ...

How to use Google Sheets as a free website monitoring tool and receive instant email and SMS text alerts when your website goes down. The app runs on Google Servers and can monitor unlimited websites. Would you like to receive instant alerts as soon as your website goes down or isxa0inaccessible to users? Would you like to receive these downtime alerts as anxa0email message or text on your mobile phone or both? Mostxa0website monitoring servicesxa0follow the “freemium” modelxa0– they have free...

How to use Google Sheets as a free website monitoring tool and receive instant email and SMS text alerts when your website goes down. The app runs on Google Servers and can monitor unlimited websites. Would you like to receive instant alerts as soon as your website goes down or isxa0inaccessible to users? Would you like to receive these downtime alerts as anxa0email message or text on your mobile phone or both? Mostxa0website monitoring servicesxa0follow the “freemium” modelxa0– they have free...

Lea how to create impressive pixel paintings with Google Spreadsheets. You can convert any image into pixel art with little effort. You may have been using Google Spreadsheets for budgeting and project management but did you know that the same sheets application can also help you create impressive pixel paintings in minutes? The Google blog recently published a storyxa0ofxa0two illustrators who created a bright and beautifulxa0wall muralxa0usingxa0Google Spreadsheets. Marina and Mallory conne...

Lea how to temporarily share files in Google Drive that are accessible for a limited time. You can set an auto-expiry date and the shared Google Drive links will stop working after the specified date and time. Works for both Gmail and Google Apps accounts. When you share any file or folder in Google Drive with another user, the shared links will work forever unless you manually change the sharing permissions. For instance, if you have shared a document with an exteal vendor, they’ll continue to ...

Lea how to place a Google Drive file or folder into multiple folders simultaneously. This prevents you from creating duplicate copies of the files in Google Drive. Gmail works around the concept of tags (or labels) and any email message can belong to one or more tags. Google Drive hasxa0folders instead of tags and thus any file or folderxa0in Drivexa0can have a single parent folder. For instance, if you have uploaded a presentation file in Folder-A, it can’t simultaneously exist in Folder-B. Rig...

Lea how to embed a YouTube video that autoplay but the sound is muted. The YouTube video will automatically play when the webpage is loaded but with the volume set to 0. It is easy to embed YouTube videos in your website. You grab the default IFRAME embed code, paste it anywhere inside your web page and you’re done. YouTube offers basic customizationxa0– you can modify the player dimensions or hide the YouTube brandingxa0– but if you would like to exercise more control over the xa0behavior of th...

The Drive Auditor scans your Google Drive and prepares a detailed report revealing who has access to your files and the permissions they have over shared files. The files and folders in your Google Drive are private by default until you decide to share them. You can share your documents with specific peoplexa0or you can make them public and anyone on the Inteet can view the shared files. Google Apps users have the option to share files and foldersxa0within the organizationxa0while restricting ac...

Lea how to extract email addresses and names of senders from your Gmail account and import the CSV list into Google Contacts. The extractor can mine emails from the message body content as well. Acme Widgets Inc. has been in business for over 10 years and they have exchanged emails with thousands of customers and suppliers. The email messages are archived neatly in Gmail but most of the email addresses aren’t stored in Google Contacts. The company is now shifting office and they need to inform e...

Twitter Analyzer identifies the gender of your Twitter followers based on their profile picture. The user details are saved in a Google Spreadsheet. Do you ever wonder what is the demographics of people who follow you on Twitter. How many of your Twitter friends are men? Or women? Or random colored eggs, people who are either too lazy to change their default avatar or maybe they are Twitter bots. The Graph Search of Facebook can provide deep insights into the demographics of people who are con...

Google Drive does not offer an xcopy like option to copy folders and their subfolders to another directory. A simple script can duplicate folders in Google Drive and retain its permissions. Google Drive, launched almost 4 years ago, is an online vault where you can store all your files and documents. It offers nearly all the functionality that you would expect in a file manager app making it easier for you to manage files from within the browser. You can move files between folders, rename files,...

You can embed the Facebook Messenger button in your website and receive messages from anyone who has a Facebook account. People can message your Facebook page or your personal profile. Email has always been the preferred mode for reaching out to people on the Inteet. Websites would put their email addresses on web pages and made them clickable hyperlinks using the mailto protocol. Things have changed and while email is still considered important, the new generation is known to prefer instant tex...

Your WhatsApp account is filled with motivational quotes, memes and other junk images that are clogging your phone’s memory. Here’s how to smartly delete all the useless content in one go. WhatsApp is probably the largest space hog on our mobile phones. We all have friends and relative who diligently forward us every single motivation quote and meme they’ve received from their own network. Some think it is their duty to wake us with a “good moing” message accompanied with photos of the rising su...

Lea how to create multiple copies of the same e-mail draft messages in Gmail. The duplicate message will copy the body and attachments too. You have composed a draft inside Gmail and would like to send the same email message to multiple people, separately. The subject, the email body, the attachments remain unchangedxa0and the only thing that differs in each message is the recipient’s email address. Maybe you are sending your résuméxa0to multiple companies. How canxa0you do this without having t...

09 Apr 2016 Lea how you can create your own Twitter bots without writing a single line of code. The bots can favorite, retweet, reply tweets or even send DMs to users. couch mode print story Twitter Bots can do interesting things. You can tweet questions like “how many calories are in diet coke” to @DearAssistant and the Twitter bot, like Google Now or Apple Siri, will reply with the answer.xa0The @HundredZeros bot tweets links to eBooks that are free on Amazon. Another Twitter botxa0@WhatThe...

How to schedule emails in Gmail, including recurring email, with a Google Sheet. Write your emails now and Gmail will delay the delivery and send them at a specified date and time. Have you ever wanted to write an email message in Gmail now but send it later? Maybe you are sending birthday wishes and would like to delay the delivery of the email message until the actual day. Or you have written an email but would like to schedule delivery in the recipient’s time zone when the message is more lik...

The Google Fonts directory features 100s of fonts but finding that perfect font combination can be time-consuming. Here are the best font pairs that go well together, picked by type masters. Whether you are creating a website, writing your resume or designing a presentation, the fonts or typeface you choose can make a notable difference. The Google Fonts directory offers a myriad of choices but how do you pick the correct font for your digital projects? Should you go for Serif fonts or Sans Seri...

Lea how to convert your Google Docs and Microsoft Word documents into ePUB ebooks that can be opened inside any digital ebooks reader. Adobe PDF may be the most popular document format on the web but there’s a reason why eBook lovers prefer the ePubxa0format over PDF. PDF documents have a static layout with fixed page breaks but the layout of an ePUB documentxa0is “responsive” meaning it will automatically adjust for different screen sizes. You can readxa0an ePub bookxa0on your desktopxa0or in...