Hello Jonathan,
While Google Cloud SQL allows users to create triggers on Postgres database it is not something that comes under the scope of Google Cloud Platform. Triggers on Cloud SQL are similar to triggers created on locally hosted Postgres DB instance. I have found a useful link for you to learn how to create triggers in Postgres.
I hope this helps. Feel free to contact us again should you require any further assistance.