Connect Shopify and Google Sheets

Both apps 157Shopify 95Google Sheets 62

• Trigger
  New cart

  Triggered when a cart is created.

• Trigger
  New customer

  Polling trigger that fires for each newly created Shopify customer. Fetches the 50 most recently created customers (sorted by creation date, newest first) via the GraphQL Admin API customers connection.

• Trigger
  New customer (instant)

  Triggered when a customer is added.

• Trigger
  New order

  Polls Shopify for orders (most recent first), returning a list of orders.

• Trigger
  New order (instant)

  Triggered when an order is created.

• Trigger
  New paid order

  Triggered when an order is paid.

• Trigger
  New product

  Triggers when a new product is created in Shopify. Polls the GraphQL Admin API products connection (first 50, sorted by createdAt ascending) and returns each product's id, title, handle, vendor, product_type, status, created_at, updated_at.

• Trigger
  Order fulfilled

  Triggered when an order is fulfilled.

• Trigger
  Order partially fulfilled

  Triggered when an order is partially fulfilled.

• Trigger
  Two-way sync new or updated customers

  Polling fetch body for the two-way customer sync trigger. Lists Shopify customers ordered oldest-to-newest by updated_at (GraphQL customers connection, sortKey: UPDATED_AT, reverse:false, first:250) so newly created or updated customers are surfaced for two-way synchronization.

• Trigger
  Updated cart

  Triggered when a cart is updated.

• Trigger
  Updated customer

  Triggered when a customer is updated.

• Trigger
  Updated fulfillment status

  Polling trigger: fetches recently-updated Shopify orders (any status) and returns each order's fulfillment status.

• Trigger
  Updated order

  Polls Shopify for recently updated orders (any status), most-recently-updated first.

• Trigger
  Updated order (instant)

  Triggered when an order is updated.

• Trigger
  Updated order payment status

  Polling trigger: fires when an order's payment (financial) status changes. Lists the 50 most recently updated orders via the GraphQL Admin API (orders sorted by UPDATED_AT desc) and dedups on order id + financial status so a new event fires only when the payment status changes.

• Trigger
  Updated product

  Polling trigger: fires for products that were recently updated. Fetches up to 50 products sorted by update time (most recent first) via the Shopify GraphQL Admin API, projecting id, title, handle, vendor, product_type, status, created_at and updated_at for each.

• Action
  Activate Inventory Item at Location

  Stocks an inventory item at a store location so it can hold quantity there, and returns the location's available quantity.

• Action
  Add customer

  Create a new Shopify customer (first name, last name, email, phone, note, tags) via the GraphQL Admin API customerCreate mutation. Returns the created customer's id, email, phone, first/last name and created_at.

• Action
  Add metafield to customer

  Add (set) a metafield on a Shopify customer, with the customer as the metafield owner. Inputs: Customer ID, Namespace, Key, Type (default single_line_text_field), Value. Returns the created/updated metafield's id, namespace, key, type, value.

• Action
  Add metafield to product

  Adds a metafield to the specified product.

• Action
  Add or update customer

  Creates a new customer if the email does not exist, otherwise updates the existing customer.

• Action
  Add product image

  Adds a new product image from the image at the specified URL.

• Action
  Add Product Option

  Adds one or two new options (for example Size or Color) to an existing product and gives every existing variant a value for them. Does nothing if the product already has an option with that name.

• Action
  Add tags to customer

  Adds one or more tags to the customer with the specified email. An error occurs if more than one customer is found. Existing tags on the customer are not removed.

• Action
  Add tags to order

  Adds the given comma-separated tags to a Shopify order (GraphQL Admin API tagsAdd mutation). Existing order tags are preserved; tagsAdd merges new tags onto the current set. Inputs: Order ID (numeric REST id, converted to a gid://shopify/Order GID), Tags (comma-separated). Returns the order GID (id) and the full resulting tag list (tags).

• Action
  Add transaction to order

  Add a transaction to an order. Captures payment for the order's authorized amount. Inputs: Kind (default capture), Amount, Currency, Parent Transaction ID, plus the Order ID setting. Returns the transaction id, kind, status and order id.

• Action
  Adjust Inventory Quantity

  Change an inventory item's available quantity at a location by a positive or negative amount.

• Action
  Apply gift card adjustment

  Apply an adjustment (credit) to a Shopify gift card's balance. Inputs: Gift Card ID, Amount, optional Note. Returns the resulting credit transaction id, note, amount, creation time, and the gift card's numeric id.

• Action
  Change product option names

  Update a Shopify product's core fields and (re)name its product options. Inputs: Product ID plus optional Title, Body HTML, Handle, Type, Published scope, Tags, Template suffix, Vendor, and Option 1/2/3 name. Returns the updated product id, title, options (name+position), and updated_at.

• Action
  Change product option names and values

  Change a product's option names and their values. Inputs: Product ID, Option 1/2/3 Name, Option 1/2/3 Values (comma-separated). Returns the product id, title, and the resulting options array.

• Action
  Complete draft order

  Completes a draft order.

• Action
  Create Metafield Definition

  Create a metafield definition (namespace, key, type, validations) for an owner type.

• Action
  Create Order with Calculated Tax

  Creates an order for a product variant, with Shopify calculating the tax from the shipping address, and returns the order totals and tax lines.

• Action
  Create or Update Theme File

  Create or replace a file in a theme. The store's Shopify app needs the write_themes scope.

• Action
  Create product

  Creates a new product.

• Action
  Create product variant

  Creates a new variant on an existing Shopify product. Inputs: SKU, Price, Weight, Barcode, Option1-3, Compare At Price, Inventory Quantity, plus the Product ID setting. Returns the created variant id, sku, price, title, option1, product_id and inventory_item_id.

• Action
  Create Product with Variants

  Create a product with up to three options and its variants (price, SKU, barcode, inventory settings) in one step.

• Action
  Delete item from location

  Disconnect (deactivate) an inventory item from a location, removing the inventory level — GraphQL Admin API equivalent of.

• Action
  Delete product

  Deletes an existing product.

• Action
  Delete product variant

  Deletes an existing product variant.

• Action
  Delete Theme File

  Delete a file from a theme. The store's Shopify app needs the write_themes scope.

• Action
  Find custom collection by name

  Returns details for the specified custom collection. If the custom collection is not found, an error occurs.

• Action
  Find customer by email

  Find a Shopify customer by email address. GraphQL Admin API: customers(first:1, query:"email:...") connection query; returns the first matching customer's email and numeric (legacyResourceId) customer_id.

• Action
  Find location by name

  Find a Shopify location by its exact name and return its Location ID. Fails if no location matches or if more than one location shares the name. (GraphQL Admin API port of the REST locations.json lookup.)

• Action
  Find orders

  Finds orders based upon search criteria. Emits the IDs of any matching orders. Use the "get order" action to fetch details for found orders.

• Action
  Find product by title

  Finds a product by a title search. An error occurs if zero or multiple match.

• Action
  Find product variant by SKU

  Find a single Shopify product variant by its SKU. Searches product variants for an exact SKU match, fails if zero or more than one variant matches. Returns the variant's id, sku, price, title, product id, inventory item id, and the full variant object.

• Action
  Find product variant by title

  Finds a product variant by a title search. An error occurs if zero or multiple match.

• Action
  Get all product ids in custom collection

  Returns all products (and their numeric ids) in a given custom collection.

• Action
  Get Base URL

  Returns the connected Shopify store's base URL and derives the store subdomain (store_name) from it. Pure-compute helper; makes no Shopify API call (nothing to migrate to GraphQL).

• Action
  Get customer

  Retrieve a single Shopify customer by Customer ID. Returns the customer's id, email, phone, state, first/last name, tags, created/updated timestamps, total spent, and orders count.

• Action
  Get customer metafield value

  Get a customer's metafield value by namespace and key. Returns its type, value, and numeric metafield id.

• Action
  Get fulfillment order

  Returns details for the specified order ID and fulfillment order ID. If either the order or fulfillment order is not found, an error occurs. Use the "get fulfillment order ids for order" action to fetch the fulfillment order ids for an order.

• Action
  Get fulfillment order ids for order

  Get the fulfillment order IDs for a Shopify order. Given a numeric Order ID, returns the count of fulfillment orders and their IDs.

• Action
  Get fulfillment order line items

  Lists the line items on a fulfillment order, with the quantity still left to fulfill.

• Action
  Get inventory item

  Returns details for the specified inventory item.

• Action
  Get inventory quantity

  Get available inventory quantity for an inventory item, optionally filtered to a single location.

• Action
  Get locations

  Retrieve the list of Shopify store locations. Returns each location's id, legacyResourceId, name, active state, and address.

• Action
  Get metafields for customer

  Get all metafields for a Shopify customer by Customer ID. Returns the list of metafield records (id, namespace, key, value, type) for the customer.

• Action
  Get metafields for product

  Retrieve all metafields for a product (up to 250). Takes the numeric Product ID setting and returns the list of metafields (id, namespace, key, value, type).

• Action
  Get order

  Get an order from Shopify by its numeric Order ID. Reads the order via the GraphQL Admin API (order(id:) query) and returns its name, email, currency, created date, total price, financial status, fulfillment status, and the full order object.

• Action
  Get product

  Returns all fields for the specified product ID. If the product is not found, an error occurs.

• Action
  Get product count: active products

  Returns a count of active products.

• Action
  Get product count: all products

  Returns a count of all products.

• Action
  Get product count: archived products

  Returns the number of archived products in the Shopify store.

• Action
  Get product count: draft products

  Returns the number of draft products in the Shopify store (status:draft).

• Action
  Get product metafield value

  Returns the value of a single product metafield identified by Namespace and Key for the given Product ID.

• Action
  Get Product Options

  Get a product's options and their values.

• Action
  Get product variant

  Get a single Shopify product variant by its numeric Variant ID. Returns id, sku, price, title, inventory_quantity, product_id, inventory_item_id, and the full variant object.

• Action
  Get product variant by SKU

  Look up a single Shopify product variant by its SKU. Searches product variants for the given SKU, fails if zero or more than one match. Returns the matched variant's id, sku, price, title, product id, inventory item id, and the full variant object.

• Action
  Get Sales Tax Rates by Location

  Returns the sales tax lines and total tax rate that apply at each active store location.

• Action
  Get Theme File

  Get a theme file's contents by theme and filename.

• Action
  Move fulfillment order line item

  Changes the location which is assigned to fulfill a number of unfulfilled fulfillment order line items.

• Action
  Order - add discount code

  Append a discount code to an in-progress order object before it is submitted to Shopify. GraphQL-shaped: the discount entry carries DraftOrderAppliedDiscountInput fields (title/code, value, valueType FIXED_AMOUNT|PERCENTAGE, amount) so the assembled order is ready for the draftOrderCreate / draftOrderUpdate GraphQL mutation. Mirrors the REST builder that appended {code, amount, type} to order.discount_codes; same inputs (Code, Type, Amount, Order) and outputs (order, discount_codes).

• Action
  Order - add line item

  Appends a line item to an in-memory order object (built by Order - initialize) before the order is created. Carries the same inputs (Variant ID, Quantity, Price, Total discount, Origin location ID, Is gift card, Fulfillment status).

• Action
  Order - add line item property

  Adds a custom line-item property (name/value pair) to the LAST line item of an in-flight Shopify order object being assembled in the Order builder chain (initialize -> add line item -> add line item property -> create). Pure in-memory mutation of the draft order; no API call. Returns the updated order object and its JSON encoding. (No REST->GraphQL change applies: this op never called the REST Admin API; it is a local order-builder helper. The eventual draftOrderCreate/orderCreate happens in the separate 'Order - create' op.)

• Action
  Order - add line item tax line

  Adds a tax line to the last line item of an in-memory order payload (builder, no API call). This op shapes the legacy order JSON structure; it does not call Shopify. Same inputs/outputs as the REST builder. Note: this never touched the Shopify REST API, so there is no GraphQL request equivalent — per-line-item user-supplied tax_lines are a REST Order-payload construct with no GraphQL counterpart (GraphQL computes tax lines server-side).

• Action
  Order - create

  Creates a new order.

• Action
  Order - initialize

  Starts a new Shopify order in your automation from the customer email, currency, billing and shipping addresses, tags, taxes and status you choose. It does not contact Shopify: pass the result through the Order - add steps (line items, discount codes) and then Order - create to place the order.

• Action
  Remove tags from customer

  Remove one or more comma-separated tags from a Shopify customer (looked up by email). GraphQL Admin API port: finds the customer via a customers(query:"email:...") query, then calls the tagsRemove mutation with the customer GID and the tag list. Returns the customer's numeric id and remaining tags.

• Action
  Remove tags from order

  Removes the given comma-separated tags from a Shopify order (by Order ID). Uses the GraphQL Admin API tagsRemove mutation; tags not present are ignored. Returns the order id and its remaining tags.

• Action
  Send customer invite

  Sends an account invite to a customer specified by their email address.

• Action
  Set Product Variant Metafield

  Create or update a metafield value on a product variant.

• Action
  Two-way sync add or update a customer

  Two-way sync: find a Shopify customer by email (or by the previously mapped customer id) and update it, otherwise create a new customer. Sets email, name, phone, note, tags, marketing consent and a single address. GraphQL Admin API port of the legacy REST customers create/update flow. Returns the customer id and updated_at.

• Action
  Update customer

  Updates an existing customer.

• Action
  Update Customer Default Address

  Updates a customer's default address, or adds one as the default if they have none. Fields left blank are not changed.

• Action
  Update Customer Email Marketing Consent

  Sets a Shopify customer's email marketing consent state and opt-in level.

• Action
  Update inventory item

  Updates a Shopify inventory item (sku, cost, tracked, country code of origin, harmonized system code). Takes the numeric Inventory Item ID.

• Action
  Update inventory quantity

  Set the absolute available inventory quantity for an inventory item at a specific location. GraphQL inventorySetQuantities mutation (name: available) replacing the REST inventory_levels/set.json endpoint. Returns the resulting available quantity, inventory item id, and location id.

• Action
  Update order

  Update an existing Shopify order's financial status by Order ID. Returns the order's numeric id, name, updated timestamp, and financial status.

• Action
  Update order as fulfilled

  Marks an order's fulfillment order as fulfilled by creating a fulfillment, optionally attaching tracking number/company and notifying the customer. GraphQL fulfillmentCreateV2 mutation.

• Action
  Update order line item as fulfilled

  Creates a fulfillment for an order's fulfillment order (optionally a specific line item) with tracking info, via the GraphQL fulfillmentCreateV2 mutation.

• Action
  Update product

  Update an existing product in Shopify (GraphQL Admin API, productUpdate mutation). Updates title, description, vendor, product type, tags, and/or status on the product identified by the Product ID setting; only provided fields are changed. Returns the product id, title, handle, status, updated timestamp, and admin GraphQL id.

• Action
  Update product variant

  Updates an existing variant of a Shopify product — its price, compare-at price, SKU, barcode, weight and option values. Fields left blank keep their current values.

• Trigger
  Aggregate Metric Changed

  Fires when an aggregate metric (sum/avg/count/…) over a column changes.

• Trigger
  Cell Range Values Changed

  Fires when the values in a specific cell range change.

• Trigger
  Conditional Format Rule Changed

  Fires when a conditional-format rule changes.

• Trigger
  Data Validation Rule Changed

  Fires when a data-validation rule changes.

• Trigger
  Developer Metadata Changed

  Fires when developer metadata changes.

• Trigger
  Filtered Range Values Changed

  Fires when the values in a filtered range change.

• Trigger
  New Rows

  Fires when new rows are appended to a Google Sheet.

• Trigger
  New Sheet Added

  Fires when a new sheet (tab) is added to a spreadsheet.

• Trigger
  New Spreadsheet Created

  Fires when a new spreadsheet is created in the account.

• Trigger
  Spreadsheet Metadata Changed

  Fires when spreadsheet metadata changes.

• Trigger
  Spreadsheet Properties Changed

  Fires when spreadsheet properties change.

• Trigger
  Spreadsheet Row Changed

  Fires when a row matching a query changes.

• Trigger
  Spreadsheet Search Match

  Fires when a spreadsheet matching search criteria is found.

• Trigger
  Table Query Result Changed

  Fires when the result of a SQL-style table query changes.

• Trigger
  Table Schema Changed

  Fires when a table's column schema changes.

• Trigger
  Worksheet Names Changed

  Fires when worksheet (tab) names change.

• Action
  Add Row

  Append a row to a Google Sheet

• Action
  Aggregate Column Data

  Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).

• Action
  Auto-Resize Rows or Columns

  Auto-fit row heights or column widths over an index range via autoResizeDimensions.

• Action
  Change Sheet Properties

  Update a worksheet's grid properties (row/column count) using an explicit field mask.

• Action
  Clear Basic Filter

  Remove the basic filter from a sheet via clearBasicFilter.

• Action
  Clear Spreadsheet Row(s)

  Clear the values in a range (formatting preserved).

• Action
  Copy Range

  Copy a source cell range to a destination range within the spreadsheet.

• Action
  Copy Worksheet

  Copy a worksheet into a destination spreadsheet.

• Action
  Create Chart

  Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.

• Action
  Create Conditional Formatting Rule

  Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.

• Action
  Create Multiple Spreadsheet Rows

  Append many rows in one call.

• Action
  Create Spreadsheet

  Create a new Google Sheets spreadsheet with the given title.

• Action
  Create Spreadsheet Column

  Insert a blank column at a given index.

• Action
  Create Spreadsheet Row

  Append a single row of values to a sheet range.

• Action
  Create Spreadsheet Row at Top

  Insert a blank row just below the header (row 2), then write the given values into it in one operation.

• Action
  Create Worksheet

  Add a new worksheet (tab) to an existing spreadsheet.

• Action
  Delete Chart

  Delete an embedded chart via deleteEmbeddedObject.

• Action
  Delete Sheet

  Delete a worksheet from a spreadsheet by sheetId (gid).

• Action
  Delete Spreadsheet Row(s)

  Delete a contiguous block of rows by index.

• Action
  Find and Replace

  Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).

• Action
  Find Spreadsheet

  Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).

• Action
  Find Worksheet

  Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.

• Action
  Format Cell Range

  Apply background color and bold formatting to a cell range via repeatCell.

• Action
  Format Spreadsheet Row

  Apply a background color across an entire row via repeatCell over a row range.

• Action
  Get Conditional Format Rules

  List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).

• Action
  Get Data Range

  Read all values in one or more ranges via batchGet.

• Action
  Get Data Validation Rules

  Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).

• Action
  Get Many Spreadsheet Rows (Advanced)

  Read multiple ranges at once via batchGet.

• Action
  Get Row by ID

  Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.

• Action
  Get Sheet Names

  Return the titles of all sheets (tabs) in the spreadsheet.

• Action
  Get Spreadsheet by ID

  Fetch spreadsheet metadata (title, sheets, gids, grid properties).

• Action
  List Charts

  List all embedded charts (chartId + title) across every sheet in the spreadsheet.

• Action
  Lookup Spreadsheet Row

  Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Lookup Spreadsheet Rows (Advanced)

  Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Move Chart

  Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.

• Action
  Rename Sheet

  Rename a worksheet's title.

• Action
  Search Spreadsheets

  Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.

• Action
  Set Basic Filter

  Apply a basic filter to a range on a sheet via setBasicFilter.

• Action
  Set Data Validation

  Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.

• Action
  Sort Range

  Sort a cell range by one column in ascending or descending order.

• Action
  Update Chart

  Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.

• Action
  Update Conditional Format Rules

  Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.

• Action
  Update Data Validation Rule

  Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).

• Action
  Update Spreadsheet Row

  Overwrite the values at a specific range.

• Action
  Update Spreadsheet Row(s)

  Update one or more disjoint ranges in a single batch.

• Action
  Upsert Row

  Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.