Integrate the Google Appsheet API with the Shopify Developer App API

Setup the Google Appsheet API trigger to run a workflow which integrates with the Shopify Developer App API. Pipedream's integration platform allows you to integrate Google Appsheet and Shopify Developer App remarkably fast. Free for developers.

Popular Google Appsheet and Shopify Developer App Triggers#

New Abandoned Cart from the Shopify Developer App API

Emit new event each time a user abandons their cart.

Try it

New Article from the Shopify Developer App API

Emit new event for each new article in a blog.

Try it

New Cancelled Order (Instant) from the Shopify Developer App API

Emit new event each time a new order is cancelled.

Try it

New Customer Created (Instant) from the Shopify Developer App API

Emit new event for each new customer added to a store.

Try it

New Draft Order (Instant) from the Shopify Developer App API

Emit new event for each new draft order submitted to a store.

Try it

Popular Google Appsheet and Shopify Developer App Actions#

Add Products to Custom Collections with the Shopify Developer App API

Adds a product or products to a custom collection or collections. See the docs

Try it

Add Tags with the Shopify Developer App API

Add tags. See the documentation

Try it

Create Article with the Shopify Developer App API

Create a new blog article. See The Documentation

Try it

Create Blog with the Shopify Developer App API

Create a new blog. See The Documentation

Try it

Create Custom Collection with the Shopify Developer App API

Create a new custom collection. See the documentation

Try it

Overview of Google Appsheet#

The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.

Connect Google Appsheet#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_appsheet: {
      type: "app",
      app: "google_appsheet",
    }
  },
  async run({steps, $}) {
    const data = {
      "Action": "Find",
      "Properties": `{
          "Locale": "en-US",
          "Selector": "Filter(Sheet1, true)",
          "Timezone":
          "Pacific Standard Time"
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
      headers: {
        "ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
      },
      data,
    })
  },
})

Overview of Shopify Developer App#

The Shopify Admin REST & GraphQL API unleashes a myriad of possibilities to automate and enhance online store operations. It provides programmatic access to Shopify functionalities, allowing users to manage products, customers, orders, and more. Leveraging the Shopify Admin API within Pipedream, developers can create custom workflows that automate repetitive tasks, sync data across platforms, and respond dynamically to events in Shopify.

This integration can be used as a custom app on your store, or for automating actions on behalf of merchants through your Shopify app.

Looking for integrating into the Shopify Partner API for your apps, themes or referrals? Check out our Shopify Partner API integration.

Connect Shopify Developer App#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    shopify_developer_app: {
      type: "app",
      app: "shopify_developer_app",
    }
  },
  async run({steps, $}) {
    const data = {
      "query": `{  
        shop { 
          id 
          name
          email 
        } 
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://${this.shopify_developer_app.$auth.shop_id}.myshopify.com/admin/api/2024-04/graphql.json`,
      headers: {
        "X-Shopify-Access-Token": `${this.shopify_developer_app.$auth.access_token}`,
        "Content-Type": `application/json`,
      },
      data,
    })
  },
})