Per an earlier post:
Google Apps can do a lot on their own, but to really get the benefits, you need to use the Google Add-ons available in Forms, Docs, Sheets.
Check out Add-ons make the world go round for a listing of some of my favorite add-ons. Some add-ons are also legacy scripts that you can get from the old Google Sheets.
More Google-iciousness is available on fennovation.org.