Built on WIX Headless

Tutorials / tutorial

How to Connect Google Sheets to Wix Harmony Without Code

· connect Google Sheets to Wix Harmony

How to Connect Google Sheets to Wix Harmony Without Code

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

RequirementDetail
PlanOne connection on Free / Supporter; Pro for unlimited
SheetHeader row + data rows
WidgetsTable, Repeater, Slideshow, Media Gallery, Calendar, Chart
Not supportedForm, 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):

  1. Pick a connect method:
  1. Choose the spreadsheet and sheet (tab), or paste a sheet URL for Share with app / Public link.
  2. Choose which columns to sync and confirm field types.
  3. 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

  1. Add Table, Repeater, Slideshow, Media Gallery, Calendar, or Chart.
  2. In the panel, set Data source to External Database.
  3. Select your connection—or Connect new database to open the dashboard flow and return with it selected.
  4. Map fields (columns, card content, media, dates, chart axes, and so on).
  5. Optionally enable search & filters where the widget already supports them.
  6. Publish.

Notes and limitations

Feature support

CapabilityGoogle SheetsWix CMS collection
Table / Repeater / Slideshow / Media Gallery / Calendar / ChartYesYes
Search & filters (on supported widgets)YesYes
FormNoYes
Dynamic Page / item linksNoYes
Catalog paymentsNoYes (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.

Updated:

Ready to try it on Harmony? Get a free starter site CMS for Harmony