My 4 Tricks in Google Sheets

1. Enable Notifications in Google Spreadsheet

No need to wait for an email to know if the job is done or not. Just enable notifications in Google Spreadsheets and know when your colleague made any edits in the document:

Tools → Notification rules → Notify me at when… → Save → Enjoy

2. Check HTTP respons in  Google Spreadsheet

 Tools  →  Script Editor  →  Name Your Script Editor  →  OK  →  Add Below Code.

function HTTPResponse( uri )
 var response_code ;
try {
 response_code = UrlFetchApp .fetch( uri ) .getResponseCode() .toString() ;
catch( error ) {
 response_code = error .toString() .match( / returned code (\d\d\d)\./ )[1] ;
finally {
 return response_code ;

httpresponse google My 4 Tricks in Google Sheets HTTPResponse

Don’t forget to save 🙂 

[Taken from]

3. Remove duplicates

Now you can remove duplicates in Google Spreadsheet. You might be using this add-on.

4. Create Fast Google Analytics Reports in Google Spreadsheet

This add-on is very popular. It makes reporting easy. Check out video to install the add-on.

Submit a comment