How to connect Google Sheets to the Webflow CMS

Webflow imports and exports CMS items as CSV files, one collection at a time, by hand. To keep a Google Sheet and a CMS collection in step, use a sync app such as Cellferry: connect Google, pair a sheet tab with a collection, check which column goes to which field, preview, then sync now or on a schedule. Edits on either side carry over, and a cell changed in both places is flagged instead of overwritten.

Steps

1. Install Cellferry and approve your site. Open the site in the Webflow Designer, then Cellferry from the Apps panel.
2. Connect Google. Cellferry asks only for the spreadsheets you create with it or pick with Google's file picker. It can't see anything else in your Drive.
3. Create a sync. Choose a collection, then Create a new spreadsheet for this collection (every field becomes a column) or Pick a spreadsheet from Google Drive and choose a tab.
4. Check the columns. Row 1 holds the column names, and columns pair with fields of the same name. Change any pairing, or add a field as a new column. Cellferry adds a Webflow ID column (which item the row is) and a Sync status column (what happened to the row).
5. Pick how it syncs. Direction, conflict rule and schedule, described below. Save.
6. Press Preview. Cellferry reads both sides and lists every change it would make, writing nothing. Then press Sync now.

On the first sync, rows without a Webflow ID are matched to existing items with the same slug, so you don't get duplicates.

What goes in each cell

One way or both ways

• Both ways: each cell goes the way it changed since the last sync.
• Sheet to Webflow only: the sheet is the master copy.
• Webflow to sheet only: the reverse.

When the same cell changed in both places, Cellferry changes neither by default, writes "Conflict in ..." in the row's status, and you pick Keep sheet or Keep Webflow. Or set a rule: the sheet wins, or Webflow wins. Formula cells are read and sent to Webflow but never overwritten.

New rows, removed rows and publishing

New rows become new CMS items (an empty slug is made from the name), and new Webflow items are added to the bottom of the sheet; either can be turned off. When a synced row disappears from the sheet you choose to keep the item, archive it or delete it, and if more than 5 rows and a fifth of the synced rows vanish at once, Cellferry stops and asks first. After a sync that changed items, it can publish just those items or the whole site.

Schedules, limits and undo

Syncs run every 15 or 30 minutes, hourly, every 3, 6 or 12 hours, or daily, and every 5 or 10 minutes on Pro, plus optionally about a minute after items change in Webflow. Cellferry paces itself under Webflow's and Google's API limits. Standard covers 2,000 records per site, Pro 10,000. Activity keeps 30 days of syncs, and Undo last sync puts back what the last sync changed on both sides.

What it costs

Standard is $49 a month or $490 a year per site (2,000 records, 5 syncs). Pro is $129 a month or $1,290 a year per site (10,000 records, every 5 minutes, 20 syncs). Workspace is $299 a month or $2,990 a year for every site in one Webflow workspace. Each site gets a 14-day trial with 1,000 synced changes, starting with your first real sync; previews don't count.