Most Google products, including Sheets and Docs have had a script editor called Apps script for a while, but it's not used often.

The new Google Home Script Editor is, just a day after its reveal, already available to all users in a public preview.

Google has offered up Gemini AI to set up automations for you. While Gemini was helpful in using the script editor, it was far from painless, and you likely won't need the script editor much.