Build Cool and useful tools immediately

If you use Gmail, Google Sheets, Docs, or other G Suite apps, With Google Apps Script, you have a chance to build something useful tools and you can automate a boring tedious task with no cost and there is no configuration or Setup required.

What Apps Script can do?

• Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.
• Write custom functions and macros for Google Sheets.
• Publish web apps (either standalone or embedded in Google Sites). - This is not recommended and should be avoided whenever possible.
• Interact with other Google services, including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.

What Apps Script cannot do?

App Script can only automate tasks across Google products and third party services and build web applications, other than that we can't use apps script anywhere else.

• App Script has limitation quota. Make sure you read through this article before you plan and create it.
• To execute the App Script (trigger or manual execution), it will be done via an user account. Make sure that account used to install the trigger or executing the function has the correct permission set for the resources required.
• App Script will not be able to connect to Solvay's intranet resources.
• Avoid building a very complex solution (multple script dependencies on other App Script) with App Script. If the solution is complex, consider making the design simplier or App Script is not suitable. (Considering the maintenance support effort required from you).

Always remember to consider that you will need to transfer all the App Scripts created or support by you to the next person who is going to take over.