Skip to content
ClickRuntime

Connect Google Sheets to Shopify

Shopify holds your orders and stock, and a spreadsheet is where most store owners plan, report and share with others. Linking the two keeps sales logs, reorder lists and content trackers up to date in Google Sheets without exports, and lets edits in a sheet flow back to the store.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Shopify

Sales logs, reorder planning, late-order tracking and product content, kept in step between Shopify and Google Sheets. These are ready-made starting points. Anything else you can describe works too.
Weekly

Log weekly Shopify sales to a sheet

Every Monday a new row in your sheet records last week's orders, revenue, average order value and top product.

See how it works
WeeklyAI

Draft blog posts from products, tracked in a sheet

Each week one product gets a blog draft in Shopify, and your content sheet records the title, date and link.

See how it works
On a schedule

Plan reorders from Shopify sales in a sheet

Each morning your Reorders sheet shows every product's stock, daily sales rate, days left and how many to reorder.

See how it works
Every 15 minutesAI

Write product descriptions in a sheet and push approved ones to Shopify

New products in your sheet get AI-written descriptions with French and German translations, and rows you approve update the product in Shopify.

See how it works
Hourly

Log late Shopify orders to a sheet

Every hour, paid orders that have missed your dispatch time are added to a sheet, and you get a Slack alert for each new one.

See how it works
Every 30 minutes

Copy new Shopify customers to Google Sheets

New Shopify customers are added to a Customers tab with name, email, marketing consent, country, orders and amount spent.

See how it works
The moment it happens

Log Shopify refunds to Google Sheets

Each Shopify refund is added to a Refunds tab with the order number, refunded items, amount and note as soon as it is issued.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Shopify, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Shopify automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Shopify in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Update Shopify prices from the sheet only for rows where New price differs by less than 30 percent from the current price, and flag larger changes for me.

Each night, add a row for any Shopify order with a discount code, and total revenue per code in a Codes tab.

Use cases

Why people connect Google Sheets and Shopify

How the two apps work together

  • Shopify webhooks send new orders and refunds to a ClickRuntime trigger link instantly, and each is written to the sheet.
  • Scheduled runs read Shopify products and inventory and update sheet tabs.
  • The sheet can be checked every few minutes for rows that should update Shopify, such as price changes.

  • Order log for bookkeeping

    Store owners keep each order in a sheet with date, items, tax and total for their accountant.

  • Inventory overview

    Ops staff want current stock for every variant in one sheet. A scheduled refresh keeps it current.

  • Bulk price updates

    Merchandisers edit prices in a sheet. Rows marked Update change prices in Shopify by SKU.

  • Sales reporting by product

    Owners track units and revenue per product each week in a sheet for planning.

More apps

Google Sheets, Shopify and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Weekly product report in Slack

Every Monday, write last week's Shopify units and revenue by product to our sheet and post the top 5 in #sales on Slack.

Daily totals to sheet and QuickBooks

Each night, write the day's Shopify sales to our Daily tab and create a sales receipt in QuickBooks for the total.

Low stock list by email

Each morning, update stock levels from Shopify in our Inventory sheet and email the supplier through Gmail a list of items under 5 units.

Setup

Connect Google Sheets and Shopify once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Shopify

E-commerce

  1. In the Dev Dashboard at dev.shopify.com, create an app.
  2. Create and release a version with the Admin API scopes your automations need, such as read_orders, read_products and write_products.
  3. Install the app on your store. The store must belong to the same Shopify organization as the app.
  4. From the app's Settings, copy the Client ID and Client secret.
  5. In the ClickRuntime dashboard, open Connections, choose Shopify and enter your shop domain, Client ID and Client secret.

FAQ

Questions about connecting Google Sheets and Shopify

Does it overwrite what I type in the sheet?
No. Automations add rows at the bottom or fill the columns they own. Your own columns, notes and formulas are left alone.
Can my team edit the sheet while it runs?
Yes. It is a normal Google Sheet. Keep the header row and column order the same so new rows land in the right place.
Which Google account does it use?
The Google account you connect in your ClickRuntime dashboard. The sheet needs to be one that account can edit.
Can I change products in Shopify from the sheet?
Yes, for automations built for it. The product descriptions automation updates Shopify only for rows you mark as approved.
Does it support product variants?
Yes. Each variant can be its own row, matched by SKU or variant ID.
Can it backfill past orders?
Yes. A one-time run can write past orders to the sheet.
Can it handle refunds in the order log?
Yes. Refunds can be added as separate rows or update the original order's row.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Shopify should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude