Google Sheets Sync
Manage your products using a Google Spreadsheet.
If you prefer working with spreadsheets, you can sync your product catalog from Google Sheets.
Setting up Google Sheets
Create your spreadsheet
Create a Google Spreadsheet with the required columns (see format below).
Make it accessible
Share the spreadsheet so Tiny Shops can read it. Set sharing to "Anyone with the link can view."
Enter the Spreadsheet ID
In Products, select "Use Google Sheets" and paste your Spreadsheet ID.
Find your Spreadsheet ID in the URL: https://docs.google.com/spreadsheets/d/YOUR_SPREADSHEET_ID/edit
Required column format
Your Google Sheet should have these columns in the first row:
| Column | Description | Example |
|---|---|---|
product_id | Unique identifier | sneakers-001 |
title | Product name | Running Sneakers |
description | Product description | Lightweight running shoes |
images | Space-separated image URLs | https://... https://... |
price | Regular price | 49.99 |
currency | Currency code | USD, RUB, BYN |
category | Product category | Shoes |
item_amount | Stock quantity | 100 |
How sync works
- Edit products directly in your Google Sheet
- Changes sync automatically to your storefront
- When customers place orders, stock updates write back to the sheet
Changing spreadsheets
You can switch to a different spreadsheet at any time from the Products page. Click Change Spreadsheet and enter the new ID.
Switching to database mode
If you outgrow Google Sheets, you can switch to the built-in database editor. This is a one-way migration — your sheet data will be imported into the database.