Open up a new spreadsheet and head over to the "Tools" menu option. Choose the "Script gallery" option.
When the Script Gallery window opens, you'll see that there are a number of scripts developed by existing Google Apps users that could improve the functionality of your experience. The best way to move through these is by selecting a specific category that you may be looking for.
The Script Gallery in spreadsheets is mainly used for that application as well as for forms. But you can also have some customized services enabled in other portions of Google Apps. Check out this customized shared contacts script that syncs your personal contact group.
There is a range of development that you can do within Google Apps to make it customized to your own specifications. While there are limitations to the underlying structure of the Apps services, many types of automation and data gathering can be completed through simplified processes. To learn more about getting custom Google Apps Scripts, you can take a look at this resource to get a better idea of what Google Apps Script projects entail.