What do you want to automate

with Google Chat (Service Account Key) and PostgreSQL?

module.exports = defineComponent({
  props: {
    google_chat_service_account_key: {
      type: "app",
      app: "google_chat_service_account_key",
    }
  },
  async run({ steps, $ }) {
    // Required workaround to get the @google-cloud/storage package
    // working correctly on Pipedream
    require("@dylburger/umask")();
    const { google } = require("googleapis");

    const key = JSON.parse(this.google_chat_service_account_key.$auth.key_json);
    const auth = new google.auth.JWT({
      email: key.client_email,
      key: key.private_key,
      scopes: ["https://www.googleapis.com/auth/chat.bot"],
    });

    const chat = google.chat({ version: "v1", auth });
    // Returns spaces the bot has access to
    return await chat.spaces.list();
  },
})

import postgresql from "@pipedream/postgresql"

export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql

    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.postgresql.executeQuery(queryObj);
  },
})