Connect Google Sheets to ShipStation and automate your tasks

Why integrate Google Sheets with ShipStation

The Google Sheets to ShipStation integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.

Log every Shopify order to a Google Sheet automatically

When an order is placed in Shopify, MESA writes the relevant details — customer, line items, order value, fulfillment status — to the right sheet in real time. Your team works from a current, structured record without anyone running manual exports or copying data out of the Shopify admin.

Build a live ops dashboard your whole team can see

When Shopify order, inventory, and customer events occur, MESA pushes the details to Google Sheets as they happen. Your team tracks what's in motion from a single shared view without digging through the Shopify admin or waiting for a scheduled report.

Trigger Shopify workflows when a Google Sheet is updated

When a row is added or a value changes in a designated sheet — a product approved, a vendor confirmed, a reorder threshold flagged — MESA kicks off the corresponding action in Shopify. Your spreadsheet-based processes connect directly to your store operations without a manual handoff step between them.

Push every Shopify order to ShipStation the moment it's placed

When an order comes in, MESA sends it to ShipStation with the right shipping method, carrier, and fulfillment rules already applied. Your team picks up a ready-to-ship order, not a configuration task.

Route orders to the right warehouse based on what's in the cart

When an order contains specific products, a wholesale flag, or a regional destination, MESA reads the details and sends it to the correct ShipStation fulfillment location. Every order reaches the right facility without manual sorting.

Update Shopify the moment ShipStation marks an order shipped

When ShipStation generates a tracking number and marks an order fulfilled, MESA writes the update back to Shopify and triggers any downstream actions — a Klaviyo notification, a customer tag, a loyalty point. Your post-purchase workflow starts the moment fulfillment does.

Build any Google Sheets and ShipStation automation

MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running.

Customer Created

• Customer ID
• Create Date
• Modify Date
• Name
• Company
• Street1
• Street2
• City
• State
• Postal Code
• Country Code
• Phone
• Email
• Address Verified
• Marketplace Usernames
• Tags

Customer Updated

Item Created

• Order ID
• Order Number
• Order Date
• Create Date
• Modify Date
• Payment Date
• Ship By Date
• Order Status
• Customer ID
• Customer Username
• Customer Email
• Bill To
• Ship To
• Items
• Order Total
• Amount Paid
• Tax Amount
• Shipping Amount
• Customer Notes
• Internal Notes
• Gift
• Gift Message
• Payment Method
• Requested Shipping Service
• Carrier Code
• Service Code
• Package Code
• Confirmation
• Ship Date
• Hold Until Date
• Weight
• Dimensions
• Insurance Options
• International Options
• Advanced Options
• Tag Ids
• User ID
• Externally Fulfilled
• Externally Fulfilled By
• Label Messages

Order Created

Order Shipped

• Shipment ID
• Order ID
• Order Key
• User ID
• Order Number
• Create Date
• Ship Date
• Shipment Cost
• Insurance Cost
• Tracking Number
• Is Return Label
• Batch Number
• Carrier Code
• Service Code
• Package Code
• Confirmation
• Warehouse ID
• Voided
• Void Date
• Marketplace Notified
• Notify Error Message
• Ship To
• Weight
• Dimensions
• Insurance Options
• Advanced Options
• Shipment Items
• Label Data
• Form Data

Order's Items Shipped

Product Created

• Aliases
• Product ID
• Sku
• Name
• Price
• Default Cost
• Length
• Width
• Height
• Weight Oz
• Internal Notes
• Fulfillment Sku
• Create Date
• Modify Date
• Active
• Product Category
• Product Type
• Warehouse Location
• Default Carrier Code
• Default Service Code
• Default Package Code
• Default Intl Carrier Code
• Default Intl Service Code
• Default Intl Package Code
• Default Confirmation
• Default Intl Confirmation
• Customs Description
• Customs Value
• Customs Tariff No
• Customs Country Code
• No Customs
• Tags

Product Updated

Shipment Created

Row Created

• Details about the triggered event.

Row Updated (Advanced)

• Trigger a workflow after each spreadsheet edit.

Add Funds to Carrier Account

• Name
• Code
• Account Number
• Requires Funded Account
• Balance

Add Tag to Order

• Success
• Message

Assign User to Order

• Details about user assignment.

Create Label for Order

• Order ID
• Carrier Code
• Service Code
• Package Code
• Confirmation
• Ship Date
• Weight
• Dimensions
• Insurance Options
• International Options
• Advanced Options
• Test Label

Create Label for Shipment

• Carrier Code
• Service Code
• Package Code
• Confirmation
• Ship Date
• Weight
• Dimensions
• Ship From
• Ship To
• Insurance Options
• International Options
• Advanced Options
• Test Label

Create Order

Create Ship From Location

• Warehouse Name
• Origin Address
• Return Address
• Is Default

Deactivate Store

• Success
• Message

Delete Order

• Success
• Message

Delete Ship From Location

• Success
• Message

Get List of Carrier Packages

• Carrier Code
• Code
• Name
• Domestic
• International

Get List of Carrier Services

• Carrier Code
• Code
• Name
• Domestic
• International

Get List of Customers

Get List of Fulfillments

• Detailed work associated.

Get List of Marketplaces

• Name
• Marketplace ID
• Can Refresh
• Supports Custom Mappings
• Supports Custom Statuses
• Can Confirm Shipments

Get List of Orders

• Order ID
• Order Number
• Order Key
• Order Date
• Create Date
• Modify Date
• Payment Date
• Ship By Date
• Order Status
• Customer ID
• Customer Username
• Customer Email
• Bill To
• Ship To
• Items
• Order Total
• Amount Paid
• Tax Amount
• Shipping Amount
• Customer Notes
• Internal Notes
• Gift
• Gift Message
• Payment Method
• Requested Shipping Service
• Carrier Code
• Service Code
• Package Code
• Confirmation
• Ship Date
• Hold Until Date
• Weight
• Dimensions
• Insurance Options
• International Options
• Advanced Options
• Tag Ids
• User ID
• Externally Fulfilled
• Externally Fulfilled By
• Label Messages

Get List of Orders By Tag and Status

• Lists all orders that match the specified status and tag.

Get List of Products

Get List of Resource URL IDs

• ID

Get List of Ship From Locations

• Warehouse ID
• Warehouse Name
• Origin Address
• Return Address
• Create Date
• Is Default
• Seller Integration ID
• Ext Inventory Identity
• Register Fedex Meter

Get List of Users

• User ID
• User Name
• Name

Get Shipments

Get Shipping Rates

• Service Name
• Service Code
• Shipment Cost
• Other Cost

Get Stores

• Store ID
• Store Name
• Marketplace ID
• Marketplace Name
• Account Name
• Email
• Integration URL
• Active
• Company Name
• Phone
• Public Email
• Website
• Refresh Date
• Last Refresh Attempt
• Create Date
• Modify Date
• Auto Refresh
• Status Mappings

Hold Order

• Success
• Message

List Carriers

• Name
• Code
• Account Number
• Requires Funded Account
• Balance
• Nickname
• Shipping Provider ID
• Primary

Mark Order as Shipped

• Order ID
• Order Number

Reactivate Store

• Success
• Message

Refresh Store

• Initiate a store refresh.

Remove Tag on Order

• Success
• Message

Restore Order from On Hold

• Success
• Message

Retrieve Carrier

• Name
• Code
• Account Number
• Requires Funded Account
• Balance
• Nickname
• Shipping Provider ID
• Primary

Retrieve Customer

Retrieve Order

Retrieve Product

Retrieve Ship From Location

Retrieve Store

Retrieve Store Refresh Status

• Grab all details about the refresh status of a given store.

Unsassign User from Order

• Success
• Message

Update Order

• Order ID
• Order Number
• Order Key
• Order Date
• Create Date
• Modify Date
• Payment Date
• Ship By Date
• Order Status
• Customer ID
• Customer Username
• Customer Email
• Bill To
• Ship To
• Order Total
• Amount Paid
• Tax Amount
• Shipping Amount
• Customer Notes
• Internal Notes
• Gift
• Gift Message
• Payment Method
• Requested Shipping Service
• Carrier Code
• Service Code
• Package Code
• Confirmation
• Ship Date
• Hold Until Date
• Weight
• Dimensions
• Insurance Options
• International Options
• Advanced Options
• Tag Ids
• User ID
• Externally Fulfilled
• Externally Fulfilled By
• Label Messages

Update Product

Update Ship From Location

• Modify a ship from location's details.

Update Store

• Modify a store's details.

Void Shipment Label

• Cancel a shipment label.

Add Row

• Spreadsheet ID
• Updated Range
• Updated Rows

Add Sheet

• Spreadsheet
• Sheet Name

Bulk Add Rows

• Spreadsheet
• Sheet Name

Create New Spreadsheet

• Spreadsheet name
• Folder

Query Rows

• List a selection of rows in a spreadsheet based on a query.

Update Row

• Modify an existing row in your spreadsheet.