• Google Sheets logoGoogle Sheets logo
  • Shopify logoShopify logo

Google Sheets + Shopify Integrations

How to connect Google Sheets + Shopify

Zapier lets you send info between Google Sheets and Shopify automatically—no code required.

When this happens...
automatically do this!

BetaZapier Transfer

Seamlessly send all of your data directly from one app to another in a one-time event

Learn more

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier’s Terms of Service and Privacy Policy
By signing up, you agree to Zapier’s Terms of Service and Privacy Policy
Google Sheets logo
Shopify logo

Do Even More with Google Sheets + Shopify

With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Google Sheets + Shopify workflows do more for them.

  • Google Sheets triggers, actions, and search
    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
  • Google Sheets triggers, actions, and search
    New Spreadsheet Row
    Triggered when a new row is added to the bottom of a spreadsheet.
    Trigger
    Instant
  • Google Sheets triggers, actions, and search
    New Spreadsheet
    Triggered when you create a new spreadsheet.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    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
  • Google Sheets triggers, actions, and search
    New or Updated Spreadsheet Row
    Triggered when a new row is added or modified in a spreadsheet.
    Trigger
    Instant
  • Google Sheets triggers, actions, and search
    New Worksheet
    Triggered when you create a new worksheet in a spreadsheet.
    Trigger
    Scheduled
  • Google Sheets triggers, actions, and search
    Create Spreadsheet Column
    Create a new column in a specific spreadsheet.
    Action
    Write
  • Google Sheets triggers, actions, and search
    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

How Google Sheets + Shopify Integrations Work

  1. Step 1: Authenticate Google Sheets and Shopify.
    30 seconds
  2. Step 2: Pick one of the apps as a trigger, which will kick off your automation.
    15 seconds
  3. Step 3: Choose a resulting action from the other app.
    15 seconds
  4. Step 4: Select the data you want to send from one app to the other.
    2 minutes
  5. That’s it! More time to work on other things.

Google Sheets Tutorials

Shopify Tutorials

google-sheets logo
google-sheets logo

About Google Sheets

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

Related categories

Similar apps

Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
Quip integrations

Quip

Documents
shopify logo
shopify logo

About Shopify

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

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

Or
By signing up, you agree to Zapier’s Terms of Service and Privacy Policy