ConditionalVisibility

new-products-promo

059949a359b53c1cfa16ca00dc95ecbe

ee89c66331e43be74014d49066434b94

bcc32b2a270332a8ae18f1da31c0622b

e8a5b7427766f98a9597f050a89c2172

4a035f6c3e8ba2ec563153459d44536b

d326ae55f7f7cb86fd223e701b8019e0

cfa2a9d012f0f78ec6d110d02ddb9ec9

eb237247bb5b265237b28d0d431c0da2

e4f52e5797709818afbdaea0ecac8fa2

202db3cbe10d3d7d457c858a15171006

32e0cf9a1b0ec8627a1d6e608656431f

f6359c2f49b874ae6ec12c78379be333

6eee4e9220c9bb42cddc47766e3060a1

fdbe41928fbf3dc6abfcc8266aa4582f

4bb49754fc0d3e940b4b45983d95a807

4d8cffd9bf9541e8e4ba6442ae6bca18

53b3ca9c918dfdf571c7d991cebb6a15

ff972414d5c31c8a54889a3eb1edb39f

20e6ca084cfc56531f787b7902c8cfbb

bec62c906dadaa819fbbea99422bc506

a1cef1e904f5bbfa8e78545c9523f321

Zapier feature guides

00-zapier-formatter-logo

BigCommerce

BookingSync

Chargify

Close

Ecwid

Freshbooks New

Google Sheets

Harvest

Infusionsoft

Livestorm

Magento 2.X

PayPal

ProWorkflow

QuickBooks Online

ShipStation

Shopify

Wave

WooCommerce

Xero

Zapier

Zoho Invoice

What exactly is a line item? If you’ve ever received a receipt for a purchase, or filled out an invoice, you’ve already seen them: A line that includes each product’s name, price, or quantity, repeated for every product.

How to automatically copy every detail from orders and invoices

The Zapier guide to line items

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.

Shopify is a simple way to create an online store to list products, collect credit card payments, and ship your goods.

Triggers when a new blog is added to your Shopify store.

New Blog

Triggers when a new entry is added to a blog in your Shopify store.

New Blog Entry

Triggers when a new customer is added to your Shopify account.

New Customer

Triggers when a customer account is enabled.

Customer Account Enabled

Triggers when an Order Risk Level is medium, high or both.

New Fraudulent Order

Triggers whenever a cart is "abandoned" (only open carts) (with line item support).

New Abandoned Cart

Triggers whenever a order is "cancelled" (with line item support).

New Cancelled Order

Triggers whenever an order is cancelled (with line item support).

Triggers when a new draft order is created

New Draft Order

Triggers whenever a new purchase is "paid". You can choose a different order status like pending or refunded (with line item support).

New Paid Order

Triggers when an order is fulfilled (with line item support).

New Fulfilled Order

Triggers when a new purchase is made (only open orders) (with line item support).

New Order

Triggers when an order is created (with line item support).

Triggers when an order is paid (with line item support).

New Product

Triggers when a refund or partial refund occurs.

New Refund

Triggers when a new purchase is made (of any order status).

New Order (Any Status)

Triggers when a new product is added to your Shopify store.

Triggers when a new tag is added to a customer.

New Tag Added to Customer

Triggers when a customer's information is updated.

Updated Customer

Triggers when an Inventory Item quantity is updated.

Updated Inventory

Triggers when an order is updated (with line item support).

Updated Order

Triggers when a Product is updated, ordered or when a variant is added, removed, or updated.

Updated Product

Triggers when a tag has either been added or removed from an order.

Updated Tag in Order

Find Customer

Find Order

Gets all fulfillment orders for a given order ID.

Get Fulfillment Orders by Order ID

Get Order by ID

Searches for Metafields data for a given resource (example order Metafields).

Find Metafields

Finds the Transactions associated to an Order.

Find Order Transactions

Finds multiple Products by IDs. Returned as line items.

Find Products by ID (With Line Item Support)

Finds a list of products by searching the titles.

Find Products by Title (With Line Item Support)

Find Product by Title

Finds a product by handle. Titles can also be used if handles are not customized.

Find Product by Title or Handle

Finds a list of product variants by searching the titles.

Find Product Variants by Title (With Line Item Support)

Find Product Variant by SKU

Finds a product variant by a title search.

Find Product Variant by Title

Find or Create Customer

Finds or creates a specific product by title.

Find or Create Product

Finds or creates a specific product by title v2.

Finds or creates a specific product by title v3.

Finds or creates a specific product variant by title.

Find or Create Product Variant

Find or Create Product Variant V2

Add Line Item to Order

Add Tag to Customer

Create Blog Entry

Create Company

Create Product Variant

Create Customer

Creates a new draft order (with line item support).

Create Draft Order

Creates a fulfillment for one or many fulfillment orders that are associated with the same order and are assigned to the same location.

Create Fulfillment

Updates the quantity of an existing product variant.

Update Inventory Quantity

Updates the quantity of existing product variants.

Update Inventory Quantity (with line item support).

Creates a new order (with line item support).

Create Order

Create Product

Publishes a product to a channel (e.g., a sales channel).

Publish Product

Removes one or more tags from a customer.

Remove Tag from Customer

Create Transaction

Updates an existing customer. Replaces only data that is set.

Update Customer

Update Order

Updates an existing product. Replaces only data that is set.

Update Product

Updates an existing product variant. Replaces only data that is set.

Update Product Variant

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Add new Shopify paid orders to Google Sheets rows

Automatically created paid invoices in Xero when your Stripe customers are charged with this Stripe Xero integration. After you set up this integration, every time there is a new Stripe charge, a new Xero invoice is created. It's automatic accounting at its best.

Stripe is a developer-friendly way to accept payments online and in mobile apps. Stripe's suite of APIs powers commerce for thousands of companies of all sizes, processing billions of dollars for businesses each year.

The Zapier guide to line items

How to automatically copy every detail from orders and invoices

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.