Google Sheets + Shopify

Update products in Shopify from new updates in Google Sheet rows

When this happens
Step 1: New or Updated Spreadsheet Row
Then do this
Step 2: Find Product by Title
Then do this
Step 3: Update Product

You keep a database of your Shopify products in Google Sheets, but making changes to a product description in one tool and having to repeat it in another is a pain. With this Zapier integration, the changes you make in your doc will be automatically reflected in your Shopify products. You can avoid human error, save time, and rest assured that your store and databases match!

How this Google Sheets-Shopify integration works

A new row is updated in Google Sheets
Shopify finds the product you're targeting by title
Zapier updates a product in Shopify

Apps involved

Google Sheets
Shopify

Try this template

Supported triggers and actions

What does this mean?

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant
New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Trigger
Instant

New Worksheet
Triggered when you create a new worksheet in a spreadsheet.
Trigger
Scheduled
Create Spreadsheet Column
Create a new column in a specific spreadsheet.
Action
Write

Create Spreadsheet Row
Create a new row in a specific spreadsheet.
Action
Write

Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
Shopify
Triggers when a new entry is added to a blog in your Shopify store.
Scheduled
Trigger
Shopify
Triggers when a new customer is added to your Shopify account.
Scheduled
Trigger
Shopify
Triggers whenever a cart is "abandoned" (only open carts) (with line item support).
Scheduled
Trigger
Shopify
Triggers whenever a order is "cancelled" (with line item support).
Scheduled
Trigger
Shopify
Triggers whenever a new purchase is "paid". You can choose a different order status like pending or refunded (with line item support).
Scheduled
Trigger
Shopify
Triggers when a new purchase is made (only open orders) (with line item support).
Scheduled
Trigger
Shopify
Triggers when a new purchase is made (of any order status).
Scheduled
Trigger
Shopify
Triggers when a new product is added to your Shopify store.
Scheduled
Trigger
Shopify
Triggers when a customer's information is updated.
Instant
Trigger
Shopify
Triggers when an order is updated (with line item support).
Scheduled
Trigger
Shopify
Creates a new blog post.
Scheduled
Action
Shopify
Creates a new customer.
Scheduled
Action
Shopify
Updates the quantity of an existing product variant.
Scheduled
Action
Shopify
Creates a new order (with line item support).
Scheduled
Action
Shopify
Creates a new product.
Scheduled
Action
Shopify
Creates a new product variant.
Scheduled
Action
Shopify
Updates an existing customer. Replaces only data that is set.
Scheduled
Action
Shopify
Updates an existing product. Replaces only data that is set.
Scheduled
Action
Shopify
Updates an existing product variant. Replaces only data that is set.
Scheduled
Action
Shopify
Finds a customer by name or email.
Scheduled
Action
Shopify
Finds a product by a title search.
Scheduled
Action
Shopify
Finds a product variant by a title search.
Scheduled
Action
Shopify
Finds or creates a specific customer.
Scheduled
Action
Shopify
Finds or creates a specific product by title v2.
Scheduled
Action
Shopify
Finds or creates a specific product variant by title.
Scheduled
Action