Google Sheets + Shopify

Add new Shopify paid orders to Google Sheets rows

Send line items from your eCommerce tool over to your spreadsheet app, where you can sort and share your data. Use this integration to automatically save line items from new paid Shopify orders to Google Sheets as multiple rows--instead of squeezing all the line items into one spreadsheet row. With your data cleanly and clearly organized in Google Sheets, you can quickly get insights and analyze it.

When this happens...
New Paid Order
Triggers when an order is paid (with line item support).
TriggerInstant
automatically do this!
Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

New Blog
Triggers when a new blog is added to your Shopify store.
Trigger
Scheduled
Try It
New Customer
Triggers when a new customer is added to your Shopify account.
Trigger
Scheduled
Try It
- Risk Level
Trigger
Scheduled
Try It
New Cancelled Order
Triggers whenever an order is cancelled (with line item support).
Trigger
Instant
Try It
New Fulfilled Order
Triggers when an order is fulfilled (with line item support).
Trigger
Instant
Try It

New Paid Order
Triggers when an order is paid (with line item support).
Trigger
Instant
Try It
New Product
Triggers when a product is created.
Trigger
Instant
Try It

Updated Customer
Triggers when a customer's information is updated.
Trigger
Instant
Try It
Updated Order
Triggers when an order is updated (with line item support).
Trigger
Instant
Try It
- Order IDRequired
- Type of Line Item to AddRequired
- Reason for Edit
- Notify the Customer?
Action
Write
- BlogRequired
- TitleRequired
- Author NameRequired
- ContentRequired
- Featured Image URL
- Excerpt/Summary
- Tags
- Is Published?
Action
Write
- Product IDRequired
- Add New Image - File
- Add New Image - Alt Text
- Choose Existing Image
- Price
- Compare-at Price
- Charge Tax On This Variant?
- Cost Per Item
- SKU (Stock Keeping Unit)
- Barcode (ISBN, UPC, GTIN, etc.)
- Track Quantity?
- Continue Selling When Out of Stock?
- This Is a Physical Product
- Weight
- Weight Unit
- Country/Region of Origin
- Harmonized System (HS) code
- Position
- Requires Components
- Tax Code
Action
Write
- Email
- Product
- Product Variant
- Product Quantity
- Product Title
- Product Price
- Weight in Grams
- Note
- Discount - Type
- Discount - Amount
- Discount - Code
- Additional Details
- Tags
- Shipping Address Instructions
- Shipping Address - First name
- Shipping Address - Last name
- Shipping Address - Company
- Shipping Address - Phone
- Shipping Address - Address
- Shipping Address - Address con't
- Shipping Address - City
- Shipping Address - Country
- Shipping Address - State/Province/Region
- Shipping Address - Postal/Zip code
- Billing Address Instructions
- Billing Address - First name
- Billing Address - Last name
- Billing Address - Company
- Billing Address - Phone
- Billing Address - Address
- Billing Address - Address con't
- Billing Address - City
- Billing Address - Country
- Billing Address - State/Province/Region
- Billing Address - Postal/Zip code
Action
Write
- Adjust or Set quantity?Required
- The name of quantities to be changedRequired
- The reason for the quantity changesRequired
- LocationRequired
- Product
- Product VariantRequired
- Quantity to Set or Adjust
Action
Write
- TitleRequired
- Product Type
- Vendor
- Product Status
- Product Description
- Tags
- Collection ID
- Handle
- Note
- First Product Option
- Values for First Product Option
- Second Product Option
- Values for Second Product Option
- Third Product Option
- Values for Third Product Option
- Category
- Alt Text
- Media Content Type
- Original Source
Action
Write
- CustomerRequired
- TagsRequired
Action
Write
- CustomerRequired
- First Name
- Last Name
- Email Address
- Company Name
- Default Address
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Tags
- Phone Number
- Note
- Tax Exempt
- Tax Exemptions
- Accepts Marketing
Action
Write
- ProductRequired
- Product VariantRequired
- Title
- Price
- Compare at Price
- SKU
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Query - Name
- Query - Confirmation Number
- Query - Email
- Query - Customer ID
- Query - Location ID
- Query - SKU
- Query - Order ID
- Sort Key
- Reverse?
- Raw Query
Action
Search
- Owner ResourceRequired
- Owner IdRequired
Action
Search
- IdsRequired
Action
Search
- Product TitleRequired
Action
Search
- Product Variant SKURequired
Action
Search
- Name
- Email AddressRequired
- First Name
- Last Name
- Customer Phone
- Company Name
- Street Address
- Street Address Line 2
- City
- State
- State/Province Code
- Country
- Zip Code
- Address Phone
- Tags
- Note
- Accepts Marketing
- Tax Exempt
- Tax Exemptions
- Send E-Mail Invite
Action
Search or write

Google Sheets + Shopify

Add new Shopify paid orders to Google Sheets rows

Supported triggers and actions

New Blog

New Customer

New Fraudulent Order

New Cancelled Order

New Fulfilled Order

New Paid Order

New Product

Updated Customer

Updated Order

Add Line Item to Order

Create Blog Entry

Create Product Variant

Create Draft Order

Update Inventory Quantity (with line item support).

Create Product

Remove Tag from Customer

Update Customer

Update Product Variant

API Request (Beta)

Find Order

Find Metafields

Find Products by ID (With Line Item Support)

Find Product by Title

Find Product Variant by SKU

Find or Create Customer