Create Order with Shopify API on New Spreadsheet Created (Instant) from Microsoft Excel API

Pipedream makes it easy to connect APIs for Shopify, Microsoft Excel and 2,700+ other apps remarkably fast.

Trigger workflow on

New Spreadsheet Created (Instant) from the Microsoft Excel API

Next, do this

Create Order with the Shopify API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Microsoft Excel trigger and Shopify action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Spreadsheet Created (Instant) trigger
1. Connect your Microsoft Excel account
2. Select a Folder ID
Configure the Create Order action
1. Connect your Shopify account
2. Configure Line Items
3. Optional- Configure Billing Address
4. Optional- Configure Shipping Address
5. Optional- Select a Financial Status
6. Optional- Configure Discount Code
7. Optional- Configure Fulfillment
8. Optional- Select a Fulfillment Status
9. Optional- Configure Send Receipt
10. Optional- Configure Send Fulfillment Receipt
11. Optional- Configure Tax Lines
12. Optional- Configure Currency
13. Optional- Configure Note
14. Optional- Select a Inventory Behavior
15. Optional- Configure Shipping Lines
16. Select a Customer ID
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Spreadsheet Created (Instant) on Microsoft Excel

Description:Emit new event when a new Excel spreadsheet is created.

Version:0.0.1

Key:microsoft_excel-new-item-created

View on GitHub

Microsoft Excel Overview#

The Microsoft Excel API on Pipedream allows you to automate spreadsheet tasks, manipulate data, and integrate Excel with other apps and services. Through Pipedream, you can create serverless workflows that react to events, perform operations on Excel files like reading, writing, updating cells, and managing worksheets. This API turns Excel into a powerful tool for data analysis, report generation, and task automation without manual intervention.

Trigger Code#

import common from "../common/base-webhook.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  dedupe: "unique",
  key: "microsoft_excel-new-item-created",
  name: "New Spreadsheet Created (Instant)",
  description: "Emit new event when a new Excel spreadsheet is created.",
  version: "0.0.1",
  type: "source",
  hooks: {
    ...common.hooks,
    async deploy() {
      this._setLastCreatedTs(Date.now());
    },
  },
  methods: {
    ...common.methods,
    _getLastCreatedTs() {
      return this.db.get("lastCreatedTs");
    },
    _setLastCreatedTs(lastCreatedTs) {
      this.db.set("lastCreatedTs", lastCreatedTs);
    },
    filterRelevantSpreadsheets(spreadsheets) {
      const lastCreatedTs = this._getLastCreatedTs();
      let maxTs = lastCreatedTs;
      const relevant = [];
      for (const spreadsheet of spreadsheets) {
        const ts = Date.parse(spreadsheet.createdDateTime);
        if (ts > lastCreatedTs) {
          relevant.push(spreadsheet);
          maxTs = Math.max(ts, maxTs);
        }
      }
      this._setLastCreatedTs(maxTs);
      return relevant;
    },
    generateMeta(item) {
      return {
        id: `${item.id}`,
        summary: `Item ${item.name} created`,
        ts: Date.parse(item.createdDateTime),
      };
    },
  },
  sampleEmit,
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Microsoft Excel	`microsoftExcel`	`app`	This component uses the Microsoft Excel app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
N/A	`http`	`$.interface.http`	This component uses `$.interface.http` to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the `run()` method of the component.
Folder ID	`folderId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

Microsoft Excel uses OAuth authentication. When you connect your Microsoft Excel account, Pipedream will open a popup window where you can sign into Microsoft Excel and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Microsoft Excel API.

Pipedream requests the following authorization scopes when you connect your account:

User.Reademailoffline_accessopenidprofileFiles.ReadWriteFiles.Read.AllUser.ReadCrossTenantInformation.ReadBasic.All

About Microsoft Excel#

You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.

Action#

Create Order on Shopify

Description:Creates a new order. For full order object details [See the documentation](https://shopify.dev/docs/api/admin-graphql/latest/mutations/ordercreate)

Version:0.0.7

Key:shopify_developer_app-create-order

View on GitHub

Shopify Overview#

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

Action Code#

import shopify from "../../shopify_developer_app.app.mjs";
import utils from "@pipedream/shopify/common/utils.mjs";

export default {
  key: "shopify_developer_app-create-order",
  name: "Create Order",
  description: "Creates a new order. For full order object details [See the documentation](https://shopify.dev/docs/api/admin-graphql/latest/mutations/ordercreate)",
  version: "0.0.7",
  type: "action",
  props: {
    shopify,
    lineItems: {
      type: "string[]",
      label: "Line Items",
      description: "A list of line item objects, each containing information about an item in the order. Example: `{ \"variantId\": \"gid://shopify/ProductVariant/44572675571992\", \"quantity\": 1, \"title\": \"Title\" }`. More details in [Shopify Order Object](https://shopify.dev/docs/api/admin-graphql/latest/objects/order)",
    },
    billingAddress: {
      type: "object",
      label: "Billing Address",
      description: "The mailing address associated with the payment method. More details when searching **billing_address** in [Shopify Order Object](https://shopify.dev/docs/api/admin-graphql/latest/objects/order)",
      optional: true,
    },
    shippingAddress: {
      type: "object",
      label: "Shipping Address",
      description: "The mailing address to where the order will be shipped. More details when searching **billing_address** in [Shopify Order Object](https://shopify.dev/docs/api/admin-graphql/latest/objects/order)",
      optional: true,
    },
    financialStatus: {
      type: "string",
      label: "Financial Status",
      description: "The status of payments associated with the order. Can only be set when the order is created",
      options: [
        "PENDING",
        "AUTHORIZED",
        "PARTIALLY_PAID",
        "PAID",
        "PARTIALLY_REFUNDED",
        "REFUNDED",
        "VOIDED",
      ],
      optional: true,
    },
    discountCode: {
      type: "object",
      label: "Discount Code",
      description: "A discount applied to the order. Example: `{ \"code\": \"SPRING30\", \"type\": \"fixed_amount\", \"amount\": \"30.00\" }`. More details when searching **discount_codes** in [Shopify Order Object](https://shopify.dev/docs/api/admin-graphql/latest/objects/order)",
      optional: true,
    },
    fulfillment: {
      type: "object",
      label: "Fulfillment",
      description: "Fulfillment associated with the order. For more information, see the [Fulfillment Object](https://shopify.dev/docs/api/admin-graphql/latest/input-objects/OrderCreateFulfillmentInput)",
      optional: true,
    },
    fulfillmentStatus: {
      type: "string",
      label: "Fulfillment Status",
      description: "The order's status in terms of fulfilled line items",
      options: [
        "FULFILLED",
        "NULL",
        "PARTIAL",
        "RESTOCKED",
      ],
      optional: true,
    },
    sendReceipt: {
      type: "boolean",
      label: "Send Receipt",
      description: "Whether to send an order confirmation to the customer",
      optional: true,
    },
    sendFulfillmentReceipt: {
      type: "boolean",
      label: "Send Fulfillment Receipt",
      description: "Whether to send a shipping confirmation to the customer",
      optional: true,
    },
    taxLines: {
      type: "string[]",
      label: "Tax Lines",
      description: "An array of tax line objects, each of which details a tax applicable to the order. Example: `[ { \"rate\": 0.06, \"price\": 11.94, \"title\": \"State Tax\", \"channel_liable\": true } ]`. More details when searching **tax_lines** in [Shopify Order Object](https://shopify.dev/docs/api/admin-graphql/latest/objects/order)",
      optional: true,
    },
    currency: {
      type: "string",
      label: "Currency",
      description: "The three-letter code ([ISO 4217](https://en.wikipedia.org/wiki/ISO_4217) format) for the shop currency",
      optional: true,
    },
    note: {
      type: "string",
      label: "Note",
      description: "An optional note that a shop owner can attach to the order",
      optional: true,
    },
    inventoryBehavior: {
      type: "string",
      label: "Inventory Behavior",
      description: "The behaviour to use when updating inventory",
      options: [
        {
          value: "BYPASS",
          label: "Do not claim inventory",
        },
        {
          value: "DECREMENT_IGNORING_POLICY",
          label: "Ignore the product's inventory policy and claim inventory",
        },
        {
          value: "DECREMENT_OBEYING_POLICY",
          label: "Follow the product's inventory policy and claim inventory, if possible",
        },
      ],
      optional: true,
    },
    shippingLines: {
      type: "string[]",
      label: "Shipping Lines",
      description: "An array of objects, each of which details a shipping method used. More details when searching **shipping_lines** in [Shopify Order Object](https://shopify.dev/docs/api/admin-graphql/latest/objects/order)",
      optional: true,
    },
    customerId: {
      propDefinition: [
        shopify,
        "customerId",
      ],
    },
  },
  async run({ $ }) {
    const response = await this.shopify.createOrder({
      options: {
        sendReceipt: this.sendReceipt,
        sendFulfillmentReceipt: this.sendFulfillmentReceipt,
        inventoryBehaviour: this.inventoryBehavior,
      },
      order: {
        lineItems: utils.parseJson(this.lineItems),
        billingAddress: utils.parseJson(this.billingAddress),
        shippingAddress: utils.parseJson(this.shippingAddress),
        financialStatus: this.financialStatus,
        discountCode: utils.parseJson(this.discountCode),
        fulfillment: utils.parseJson(this.fulfillment),
        fulfillmentStatus: this.fulfillmentStatus,
        taxLines: utils.parseJson(this.taxLines),
        currency: this.currency,
        customer: {
          toAssociate: {
            id: this.customerId,
          },
        },
        note: this.note,
        shippingLines: utils.parseJson(this.shippingLines),
      },
    });
    if (response.orderCreate.userErrors.length > 0) {
      throw new Error(response.orderCreate.userErrors[0].message);
    }
    $.export("$summary", `Created new order with ID \`${response.orderCreate.order.id}\``);
    return response;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Shopify	`shopify`	`app`	This component uses the Shopify app.
Line Items	`lineItems`	`string[]`	A list of line item objects, each containing information about an item in the order. Example: `{ "variantId": "gid://shopify/ProductVariant/44572675571992", "quantity": 1, "title": "Title" }`. More details in Shopify Order Object
Billing Address	`billingAddress`	`object`	The mailing address associated with the payment method. More details when searching billing_address in Shopify Order Object
Shipping Address	`shippingAddress`	`object`	The mailing address to where the order will be shipped. More details when searching billing_address in Shopify Order Object
Financial Status	`financialStatus`	`string`	Select a value from the drop down menu:`PENDINGAUTHORIZEDPARTIALLY_PAIDPAIDPARTIALLY_REFUNDEDREFUNDEDVOIDED`
Discount Code	`discountCode`	`object`	A discount applied to the order. Example: `{ "code": "SPRING30", "type": "fixed_amount", "amount": "30.00" }`. More details when searching discount_codes in Shopify Order Object
Fulfillment	`fulfillment`	`object`	Fulfillment associated with the order. For more information, see the Fulfillment Object
Fulfillment Status	`fulfillmentStatus`	`string`	Select a value from the drop down menu:`FULFILLEDNULLPARTIALRESTOCKED`
Send Receipt	`sendReceipt`	`boolean`	Whether to send an order confirmation to the customer
Send Fulfillment Receipt	`sendFulfillmentReceipt`	`boolean`	Whether to send a shipping confirmation to the customer
Tax Lines	`taxLines`	`string[]`	An array of tax line objects, each of which details a tax applicable to the order. Example: `[ { "rate": 0.06, "price": 11.94, "title": "State Tax", "channel_liable": true } ]`. More details when searching tax_lines in Shopify Order Object
Currency	`currency`	`string`	The three-letter code (ISO 4217 format) for the shop currency
Note	`note`	`string`	An optional note that a shop owner can attach to the order
Inventory Behavior	`inventoryBehavior`	`string`	Select a value from the drop down menu:`{ "value": "BYPASS", "label": "Do not claim inventory" }{ "value": "DECREMENT_IGNORING_POLICY", "label": "Ignore the product's inventory policy and claim inventory" }{ "value": "DECREMENT_OBEYING_POLICY", "label": "Follow the product's inventory policy and claim inventory, if possible" }`
Shipping Lines	`shippingLines`	`string[]`	An array of objects, each of which details a shipping method used. More details when searching shipping_lines in Shopify Order Object
Customer ID	`customerId`	`string`	Select a value from the drop down menu.

Action Authentication#

Shopify uses API keys for authentication. When you connect your Shopify account, Pipedream securely stores the keys so you can easily authenticate to Shopify APIs in both code and no-code steps.

Get your Access Token

Create a custom app in Shopify to obtain your Admin API access token. See our detailed instructions here

Enter your Admin API access token below, and save it in a secure location (we recommend using a password manager such as 1Password)

About Shopify#

Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.

More Ways to Connect Shopify + Microsoft Excel#

Other Popular Integrations#

Add Products to Custom Collections with Shopify Developer App API on New Item Updated (Instant) from Microsoft Excel API

Microsoft Excel + Shopify

Create Order with Shopify API on New Spreadsheet Created (Instant) from Microsoft Excel API

Pipedream makes it easy to connect APIs for Shopify, Microsoft Excel and 2,700+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Get your Access Token

1-24of2,700+apps by most popular

1
-
24
of
2,700+
apps by most popular