Long spreadsheets with a lot of entries can sometimes mistakenly have multiple instances of the same data. It's easy to remove them in Google Spreadsheet by making a simple script, says MakeUseOf.

Google's online office suite can do a lot more than meets the eye. Learn to use scripts and macros to boost your productivity to the max.

Google Sheets, just like AdWords, can be automated with App Scripts from Google. This means we can write some code to make the spreadsheet connect with a data source of our choosing.

A custom spreadsheet and script can automatically copy the attachments of messages with a certain tag in Gmail and send them to Google Drive.