Google drive

https://developers.google.com/apps-script/

• Your First Script - This tutorial covers the basics of writing and executing a script, demonstrating how to create a Google Document and send an email.
• Your First Custom Function - This tutorial teaches you how to create custom spreadsheet functions which can be used as part of normal spreadsheet formulas.
• Sending Emails from a Spreadsheet - This tutorial shows how to use spreadsheet data to send emails to different people.
• Removing Duplicate Rows in a Spreadsheet - This tutorial shows how to remove duplicates when manipulating data in Apps Script.