ConditionalVisibility

new-products-promo

save-shopify-orders-google-sheet-01-spreadsheet

save-shopify-orders-google-sheet-02-trigger-app

save-shopify-orders-google-sheet-03-permissions

save-shopify-orders-google-sheet-04-trigger-test

save-shopify-orders-google-sheet-05-action-setup

save-shopify-orders-google-sheet-06-connect-google-sheets

save-shopify-orders-google-sheet-07-select-spreadsheet

save-shopify-orders-google-sheet-08-fields

save-shopify-orders-google-sheet-09-order-number

save-shopify-orders-google-sheet-10-fields-filled

Highlighting the order number

Highlighting empty cell

Zapier tutorials

zapier-tutorial-shopify-sheets-00-hero

Google Sheets

Shopify

Once you've set up your Shopify store and started taking orders, keeping track of your sales is vital to maintaining a successful business.

How to automatically save Shopify orders to a Google Sheet

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

Creates a new gift card in your Shopify store.

Create Gift Card

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 an existing row is updated in a spreadsheet. Optimized for Team Drive.

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 spreadsheet row at the top of a spreadsheet (after the header row).

Create Spreadsheet Row at Top

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

When you have new paid orders, you'll want the details added to your database. This integration helps by automatically creating a record in Airtable with the details from a new paid order in Shopify. It's never been easier to track your paid orders.

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Airtable

Triggers when a new record is created or new or existing records when first added to a selected view.

New Record

Triggers when a record is created or updated.

New or Updated Record

Find Many Records (Advanced)

Find Record

Find or Create Record(s) (With Line Item Support)

Find or Create Record

Creates a new record with auto-populating fields.

Create Record

Create up to 10 new records (supports line items).

Create Records (Advanced)

Find and update an existing record, or create a new one.

Create or Update Record

Delete Record

Update Record

Create Airtable records for new paid orders in Shopify

Keep your new Shopify paid orders organized using this automation. After your customer submits a new paid order on Shopify, Zapier will automatically add it to your Microsoft Excel spreadsheet as a new row. That way, you can easily manage your orders in a spreadsheet and keep everything organized.

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

How to automatically save Shopify orders to a Google Sheet

Related articles

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