What do you want to automate

with Phemex and Google Sheets?

import crypto from "crypto";
import { axios } from "@pipedream/platform";

// Helper function to generate HMAC SHA256 signature
function generateSignature(secret, path, queryString, expiry, body = "") {
  // Concatenate according to Phemex rules: Path + QueryString + Expiry + Body
  const signedString = `${path}${queryString}${expiry}${body}`;
  return crypto.createHmac("sha256", secret).update(signedString).digest("hex");
}


export default defineComponent({
  props: {
    phemex: {
      type: "app",
      app: "phemex",
    }
  },
  async run({ steps, $ }) {
    const path = "/accounts/accountPositions"; //Your Phemex API URL Path, QueryString, and body as needed
    const queryString = "currency=BTC";
    const body = ""; // For GET requests, no body

    // Expiry: current Unix time + 60 seconds
    const expiry = Math.floor(Date.now() / 1000) + 60;

    // Generate signature
    const signature = generateSignature(
      this.phemex.$auth.api_secret,
      path,
      queryString,
      expiry,
      body
    );

    // Build headers
    const headers = {
      "x-phemex-access-token": this.phemex.$auth.api_key,
      "x-phemex-request-expiry": expiry,
      "x-phemex-request-signature": signature,
    };

    // Construct full URL
    const url = `${this.phemex.$auth.api_url}${path}?${queryString}`;

    // Make request
    return  await axios($, {
      method: "GET", //Change the HTTP method accordingly, add body if needed
      url,
      headers,
    });
  },
})

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}`,
      },
    })
  },
})