What do you want to automate

with Google Sheets and Oracle Cloud Infrastructure?

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_sheets: {
      type: "app",
      app: "google_sheets",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://www.googleapis.com/oauth2/v1/userinfo`,
      headers: {
        Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
      },
    })
  },
})

import * as common from "oci-common";
import * as identity from "oci-identity";

export default defineComponent({
  props: {
    oracle_cloud_infrastructure: {
      type: "app",
      app: "oracle_cloud_infrastructure",
    },
  },
  async run({ steps, $ }) {
    const tenancyId = this.oracle_cloud_infrastructure.$auth.tenancy_id;
    const userId = this.oracle_cloud_infrastructure.$auth.user_id;
    const fingerprint = this.oracle_cloud_infrastructure.$auth.fingerprint;
    const regionStr = this.oracle_cloud_infrastructure.$auth.region;
    const privateKey = this.oracle_cloud_infrastructure.$auth.private_key;

    // Convert the region string into a Region object
    const region = common.Region.fromRegionId(regionStr);

    // Create a simple authentication provider using your credentials.
    // If your private key has a passphrase, replace null with the passphrase.
    const provider = new common.SimpleAuthenticationDetailsProvider(
      tenancyId,
      userId,
      fingerprint,
      privateKey,
      null, // passphrase (if needed)
      region
    );

    // Create an IdentityClient using the provider.
    const identityClient = new identity.IdentityClient({
      authenticationDetailsProvider: provider,
    });

    // Prepare a request to list compartments for your tenancy.
    const listCompartmentsRequest = {
      compartmentId: tenancyId,
    };

    // Call the OCI API to list compartments.
    const response = await identityClient.listCompartments(listCompartmentsRequest);
    
    // The response object contains details such as items (the list of compartments).
    return response;
  },
});