Whether you are looking to generate custom reports, create functional tables, custom functions, or integrate Sheets with other Google services, Google Apps Script can help you achieve it.

For now, you can access the script editor through the public preview build of the Google Home app or the web. You can find some sample scripted automations over at Google's developer center.

Google Home’s script editor has gone live. The script editor will allow you to create more advanced smart home automations. The script editor is now available for all Preview users.