How to Set Expiration Dates for Shared Google Drive Files

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 external vendor, they’ll continue to have access to the file long after your business contract may have ended.
In such a situation, wouldn’t it be nice if you could set expiration dates while sharing files in Google Drive? For instance, share a document temporarily for, say, 10 days and access to the file should be revoked automatically after that period has passed.

Add an Auto-Expiry Date for Shared Links in Google Drive

Google Drive does let you set expiration dates for shared links but this option is only available to paid Google App for Work accounts.

Well, no worries. If you have a free Google account, you can still create temporary links that auto-expire after a certain time. Here’s a step by step guide:

Go to xyz.org/expire and authorize the web app to access your Google Drive.
Open the File Picker and select any file or folder in your Google Drive that you would like share.
Enter one or more email addresses (comma separated) of users who should be given viewer (read-only) or editor (read & write) access to your file.
Finally, specify the time period after which the access should be limited. You can say 5 hours or 3 weeks or even 2 years.

Click the “Set Expiration” button and you are done. The Google Script will set a time-based trigger that will automatically remove the specified user from the access list after the specified date and time.

You can also use the Google Drive Auditor add-on to analyze the shared permissions of every file in your Google Drive and know who can see your files.

The auto-expiry app will list all the files and folders that are set to expire after a certain period. You can click the “cancel” link against any Drive link to prevent that shared link from expiring automatically.

Comments

How to Identify the Gender of your Twitter Followers??

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 connected with you on the social network. For instance, you can write a natural language query like “ My friends who are older than 30 ” or “ My female friends who live in Delhi ” and the answer will be available instantly. Such granular data is however not available for Twitter users. Who Follows You? Males, Females or Eggs How do you programmatically determine the gender of a person on Twitter? The Twitter API doesn’t provide the gender information but there’s a workaround. You can take the profile picture of a Twitter user, feed it into Siftr’s Vision API and it will detect the gender of the most prominent face in the photogr

5 real-world events which ‘prove’ that time travel actually exists

In Back to the Future, you need an expensive car, and a conveniently placed lightning bolt – but what if time travel was easier than that? What if time travellers were ALL AROUND US? The ‘time travelling hipster’ (above) is one of the creepier pieces of evidence touted as proof that time travel exists – but we’ve picked out some of the best below, including several people from black-and-white films who appear to be using mobile phones. Nigel Watson, paranormal expert and author of the UFO Investigations Manual, ‘Would time travelers from the future really be using mobile phones? Wouldn’t they use something more sophisticated and less visible? Then again Dr Who still uses a sonic screwdriver and that is so 20th Century…’ Entry by Cervus Entry by Chan Teik Onn Entry by GordonHaid Entry by gicusudoru

How to Make Phone Numbers Callable in Google Sheets?

How to Insert Clickable Phone Numbers in Web Pages We use the simple tel protocol to convert a plain text phone number on a web page into a clickable telephone link For instance, if you click this link on a mobile phone, it will open the phone dialer prefilled with the specified number. There’s no need to copy-paste numbers. How to Type Phone Numbers in a Google Sheet It is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why: Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon as add the plus sign in the spreadsheet cell, it assumes that you entering a math formula and tries to calculate the value. There are two simple workarounds to this problem. You can enclose the phone number inside double quotes (“) and precede it with an equal to (=) sign. An even easier alternative is to use the single quote (‘) before the phone number. Google Sheets will then interpret the cell’s value as text and

Digital Inspiration

Search This Blog