You can connect Google Sheets to a Wix Harmony (or Classic/Studio) site without code using CMS for Harmony External databases. After you connect a spreadsheet in the dashboard, set a widget’s Data source to External Database and map columns like CMS fields. Supported widgets: Table, Repeater, Slideshow, Media Gallery, Calendar, and Chart. Free and Supporter include one connection; Pro unlocks unlimited. Form, Dynamic Page, item page links, and catalog payments stay on Wix CMS collections—not sheet connections.
Requirements
| Requirement | Detail |
|---|---|
| Plan | One connection on Free / Supporter; Pro for unlimited |
| Sheet | Header row + data rows |
| Widgets | Table, Repeater, Slideshow, Media Gallery, Calendar, Chart |
| Not supported | Form, Dynamic Page, Dynamic Page links from rows, catalog payments on sheets |
Step 1 — Check your connection limit
Free and Supporter include one external database connection; Pro unlocks unlimited. Open the CMS for Harmony dashboard to connect. If you need another connection on a free plan, upgrade when prompted.
Step 2 — Connect a sheet in the dashboard
Open External databases → Connect external database (Google Sheets):
- Pick a connect method:
- Share with app — share the sheet with the app email as Viewer (no Google sign-in).
- Public link — spreadsheet shared as “Anyone with the link can view”.
- Sign in with Google — authorize your Google account (may show an unverified-app warning until Google verifies the app).
- Choose the spreadsheet and sheet (tab), or paste a sheet URL for Share with app / Public link.
- Choose which columns to sync and confirm field types.
- Save. The connection appears with status and synced column count.
Later: Manage fields, Resync columns, open the sheet in Google, or disconnect.
Step 3 — Use the sheet in a widget
- Add Table, Repeater, Slideshow, Media Gallery, Calendar, or Chart.
- In the panel, set Data source to External Database.
- Select your connection—or Connect new database to open the dashboard flow and return with it selected.
- Map fields (columns, card content, media, dates, chart axes, and so on).
- Optionally enable search & filters where the widget already supports them.
- Publish.
Notes and limitations
- First row = headers; empty header cells are skipped.
- After Resync, review field types if you renamed or added columns.
- Sheet-backed widgets can still use search/filters where those widgets already do.
- Row clicks to Dynamic Pages are not available for Google Sheets.
- Keep Wix CMS collections when you need Forms, Dynamic Pages and item page links, or catalog payments.
Feature support
| Capability | Google Sheets | Wix CMS collection |
|---|---|---|
| Table / Repeater / Slideshow / Media Gallery / Calendar / Chart | Yes | Yes |
| Search & filters (on supported widgets) | Yes | Yes |
| Form | No | Yes |
| Dynamic Page / item links | No | Yes |
| Catalog payments | No | Yes (Pro) |
FAQ
Can I connect Google Sheets to Wix Harmony without code?
Yes—with CMS for Harmony External databases on Table, Repeater, Slideshow, Media Gallery, Calendar, or Chart. One connection is included on Free/Supporter; Pro unlocks unlimited.
Does Google Sheets work with the Form widget?
No. Form and Dynamic Page stay on Wix CMS collections.
Can I sell sheet rows with Add to cart?
No. Catalog payments apply to Wix CMS collections with Enable payments, not sheet connections.
Do I need to know Google Apps Script?
No. Connection and field mapping are done in the CMS for Harmony dashboard and widget panels.
Related reading
- External databases (Google Sheets)
- Table · Repeater · Calendar · Chart
- Can You Use a CMS in Wix Harmony?
- Wix CMS (Wix Help Center — for collection-based workflows when Sheets is not enough)