Guide

How to Import Shopify Products from Google Sheets

Last updated: November 16, 2026

Keep your Shopify product data in one shared Google Sheet, then import it once or use Pro or Scale to pick up future changes automatically on a schedule.

Google Sheets is useful when a catalog is maintained by several people or changes often. Instead of exporting a new file after every edit, you can give Simple CSV a public CSV URL for one tab of the sheet.

This guide covers the full setup:

  • Prepare a Google Sheet for a Shopify product import
  • Publish only the tab Simple CSV needs
  • Build and test a public CSV URL
  • Run a one-time import or schedule recurring updates on Pro or Scale
  • Fix an access-denied error without exposing private working data

Shopify and Direct Google Sheets Imports

No, not natively. Shopify's built-in product importer accepts a file uploaded from your computer. It cannot watch a Google Sheet or fetch a spreadsheet from a URL.

Simple CSV fills that gap. Google Sheets can publish one tab as CSV at a public URL, and Simple CSV can read that URL to create products or update existing ones in Shopify. The source still follows normal CSV rules. You maintain it as a live sheet instead of repeatedly exporting and uploading files.

When a Google Sheet Fits Better Than a Local CSV

A published Google Sheet fits product data that several people edit or that changes regularly.

  • One source of truth. Buyers, catalog managers and operations staff can work in the same sheet instead of passing file versions around.
  • No re-export and re-upload cycle. The URL stays the same while the values in the published tab change.
  • Scheduled updates. A Pro or Scale schedule can fetch the current CSV at the chosen time. Changed files update Shopify, while unchanged files are skipped after a fully successful scheduled run.
  • A safer publishing boundary. A dedicated export tab can contain only the columns Shopify needs while formulas, notes and costs stay in private working tabs.

For help with identifiers, encoding or spreadsheet auto-formatting, read the Excel and Google Sheets pitfalls in the full CSV guide. For recurring supplier data, see the supplier feed sync guide.

Step 1. Format Your Sheet Like a Shopify CSV

A Google Sheet does not change the product-data rules. Keep one header row at the top and one product or variant row beneath it, following the same structure you would use in a CSV file.

  • Use a single export tab. A CSV URL returns one tab, not a workbook with several tabs.
  • Keep one clean header row. Remove title rows and repeated headers in the data. Simple CSV skips blank lines above the first row that contains data.
  • Do not merge cells. Every value must belong to one row and one column.
  • Protect SKUs and barcodes. Select identifier columns and choose Format → Number → Plain text before pasting values, so leading zeros remain and long numbers do not become scientific notation.
  • Use public image URLs. If the sheet contains an Image Src column, every image URL must load without a sign-in.

Your headers can use Shopify's standard names or you can map your own column names to Shopify fields in Simple CSV. Either way, test a few rows before importing the complete catalog.

Step 2. Make the Sheet Public

Simple CSV fetches the sheet without your Google login, so the exact CSV URL must be public. There are two ways to create it.

Option A. Publish to web (recommended)

  1. Ask the file owner to open the sheet and choose File → Share → Publish to web.
  2. In the first dropdown, select the specific tab that contains your import data.
  3. In the format dropdown, choose Comma-separated values (.csv).
  4. Click Publish and confirm.
  5. Copy the URL ending in /pub?output=csv.

This is the preferred method because it publishes the selected tab as a durable CSV feed. It can remain available even if general link sharing for the working spreadsheet is restricted later. To stop access, you must explicitly stop publishing the document.

Option B. Share the normal sheet URL for a single-tab file

  1. Ask the file owner to click Share and set General access to Anyone with the link.
  2. For a spreadsheet with a single tab, copy the normal Google Sheets URL from the browser.
  3. Paste that URL directly into Simple CSV.

This is the easiest option for a single-tab file. For a spreadsheet with multiple tabs, use Option A so the file owner can publish the exact tab you need. A shared link is more fragile. The import stops working if someone changes General access back to Restricted or a Workspace administrator disables external sharing.

Always test the exact URL in a private or incognito browser window. A published URL should download a CSV or display comma-separated data. A normal shared URL should open the sheet without asking you to sign in.

Step 3. Import or Schedule the Sync

Once the public URL works in a private window, use it as the source for a Simple CSV import.

  1. Start a URL import in Simple CSV and paste the published CSV URL or public single-tab Google Sheets URL.
  2. Choose Import new products.
  3. Map the sheet's columns to the Shopify product fields you want to change.
  4. Choose a language, tone and mapped text fields in AI Rewrite, or choose Skip this step to continue without rewriting.
  5. Preview the result and run a small test before importing every row.

After you submit the Sheet URL, Simple CSV shows download progress before it validates the file. It shows a percentage when Google reports the total size, or the downloaded size so far when it does not.

For a new-product import, use Override status for all new products on the Preview page to make every new product Active, Draft or Unlisted. Unlisted products can be opened and bought through a direct link, but they stay out of Shopify-powered search, collections and recommendations. The choice overrides a mapped Status column or the default status. If you save the import as a Pro or Scale schedule, the same override is used whenever the scheduled file is processed.

To change products that are already in Shopify, follow the Google Sheets update guide. It covers match keys, update-only runs and mapping only the fields the Sheet should control.

The mapping screen shows Loading mapping fields… until the field list is ready. Save and continue stays in a loading state until then. Wait before continuing, especially with hundreds of columns or large XML feeds.

On Pro and Scale, including trials, use Choose products after Mapping to import or update only products matching conditions. For example, import only Philips from a 10,000-product supplier feed. Free continues with the whole file.

On Pro and Scale, conditions are saved with the mapping and reused on scheduled runs. Open Choose products with the filter icon before the play icon in the automation’s Actions row to edit them. A missing condition column stops the run. While conditions are set, out-of-feed cleanup is disabled.

Learn how to choose products with conditions.

After Choose products and before Preview, AI Rewrite appears on every plan for Import and Update. Choose a language, tone and mapped text fields for unique product copy in your brand’s voice. Select Skip this step to continue without rewriting. Only the first product is rewritten for the preview. Read how AI Rewrite works and check the result for errors.

On every plan, AI Rewrite offers optional Brand voice and Protected terms settings for your whole store. Brand voice guides description prose, with the chosen tone taking priority. Protected terms stay exactly as written, with case-sensitive, whole-word matching. These settings do not turn rewriting on.

Keep original text cannot be combined with a target language. Choose another tone to translate. Same as source with Keep original text skips rewriting.

If AI Rewrite rewrites the first product’s title, description or product type, Preview offers Show original text. It switches all three fields to the source text for comparison. The import still publishes rewritten copy. Choose Show rewritten text to switch back. The button is hidden when none of these fields were rewritten.

When an Import or Update uses AI Rewrite, its status page lists the fields being rewritten, target language and tone. It confirms brand voice and protected terms when set, without showing your answers or terms. Reload the page after the run finishes to see “were rewritten” instead of “are being rewritten”. When rewriting starts, the activity log adds one Info line with the same summary. Individual product lines do not list rewritten fields. With AI Rewrite off, neither the section nor the summary line appears.

With AI Rewrite on, Full file dry run rewrites only the first 5 data rows. Remaining rows keep their source text. The whole file is still checked without changing Shopify. The status section and log summary explain this limit.

On Pro and Scale, changing the AI Rewrite language or tone, store-wide brand voice or protected terms makes the next scheduled run process the file again, even when the file itself is unchanged. Previously rewritten text can be reused when the text and rewrite settings still match.

A one-time import reads the sheet once. On Free, select Start import on the Summary page, or Try import (100 rows) if the sheet is over the plan's limit. On Pro or Scale, select Save & Run now to save the setup and queue one run without creating a schedule. Select Save & Schedule when you want to create or edit a recurring schedule. Simple CSV then re-fetches the same URL at each scheduled time. After a fully successful scheduled run, it skips the file when the published CSV and settings are unchanged. Select Run now on the automation if you need to apply that unchanged file again. The scheduled URL import walkthrough covers mapping, matching and scheduling in more detail.

Change the inventory location

On Pro and Scale, open Simple CSV from Shopify Admin and edit the existing automation’s schedule. If it maps inventory, Inventory location lists your active Shopify locations with the saved location selected. Choose another location and select Update.

Each automation still updates one location. The new choice applies to future runs only. It does not transfer or clear stock at the previous location. Runs already queued or running keep their original location.

After you change the location, the next run processes the feed again even if the file itself is unchanged.

Automations without mapped inventory have no location selector. If Simple CSV cannot load your locations, it shows a warning and keeps the saved location.

On Summary, “Full file dry run” checks the whole file without changing Shopify. On Pro and Scale, “Run first 100 rows” makes real changes in Shopify. This limited run processes the first 100 data rows and includes complete products at the cutoff. It is separate from Free’s file limit.

If you choose “Import without checking SKU or barcode”, a later full import creates the products from the limited run again. Check your setting for existing products before continuing.

Read how to use a limited live run and return to the full file.

Fix an "Access Denied" Error

The most common cause is that the sheet is still set to Restricted or no longer opens publicly. Test the exact URL in a private window first. It should open without asking you to sign in.

For step-by-step troubleshooting, see how to fix Google Sheets access errors →

Best Practices for Google Sheets Imports

  • Publish a dedicated export tab. Keep formulas and working notes elsewhere. Expose only final values and columns needed for the import.
  • Remove private business data. Do not publish costs, margins, internal notes, customer data or supplier credentials. Public means anyone with the URL can access it.
  • Keep identifiers stable. Treat SKU and barcode columns as Plain text and do not recycle identifiers across products.
  • Limit what updates. Map only the columns the sheet owns to avoid overwriting carefully edited Shopify fields.
  • Test before scheduling. Run a small manual import, check the affected products and only then enable a recurring schedule on Pro or Scale.
  • Re-test access after sharing changes. If a security review or account change affects the spreadsheet, verify the URL again in a private window.

Google Sheets FAQ

Frequently Asked Questions

Does the whole Google Sheets file need to be public or just one tab?

With the recommended Publish to web method, only the selected tab needs to be published. A normal shared link exposes the whole spreadsheet, so use Publish to web or a dedicated single-tab file when other tabs must remain private.

Will Shopify see my Google Sheet edits automatically?

Only if you set up a scheduled import on Pro or Scale. A one-time URL import reads the sheet once. A Pro or Scale schedule re-fetches the published CSV URL at the configured time. When the published file and settings are unchanged after a fully successful scheduled run, Simple CSV skips it without touching Shopify.

Is there a size limit for Google Sheets imports?

The same plan limits apply as for any URL import: the Free plan supports up to 100 rows, while Pro and Scale support unlimited rows.

Can I use a Google Sheet for product images too?

Yes. Put a fully public image URL in the Image Src column or map your image URL column to Image Src in Simple CSV. The image itself must be publicly accessible.

It worked before and now says access denied. What changed?

The sheet or published tab was likely made private or a Google Workspace sharing policy changed. Re-test the exact import URL in a private browser window and follow the Google Sheets access denied troubleshooting steps for more help.

Can I password-protect the sheet and still import it?

No. Simple CSV must be able to fetch the CSV without signing in, entering a password or using your Google account session. Use a dedicated public export tab and keep private data elsewhere.

Run an Import from Google Sheets

Publish a clean export tab before adding it to Simple CSV. The Free plan lets you test up to 100 rows before moving the import to a Pro or Scale schedule.