Skip to content
ClickRuntime

Connect Google Sheets to Webflow

Content teams plan in spreadsheets and publish in Webflow. Connecting the two lets your sheet drive the CMS: a keyword list becomes blog drafts and a list of pages gets FAQ sections, with the status written back so everyone can see what is done.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Webflow

Blog drafts and FAQ sections created in your Webflow CMS from rows in Google Sheets. These are ready-made starting points. Anything else you can describe works too.
Every 30 minutesAI

Add FAQ sections to Webflow pages listed in a sheet

Mark a page as ready in your sheet and five FAQs written from its content are saved into that page's Webflow CMS item, with the row marked done.

See how it works
On a scheduleAI

Turn a keyword sheet into Webflow blog drafts

Each day the next keyword in your sheet becomes a full blog post draft in your Webflow Blog collection, with the link written back to the sheet.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Webflow, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Webflow automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Webflow in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only publish items where "approved" is yes; others stay as drafts.

Each week, export all CMS items to a sheet tab with their last updated date.

Use cases

Why people connect Google Sheets and Webflow

How the two apps work together

  • A check every few minutes finds new or ready rows in Google Sheets.
  • The script creates or updates Webflow CMS items with mapped fields.
  • It can publish items and write the item ID back to the row.

  • Marketers managing CMS content

    Rows in a sheet become Webflow CMS items. Bulk updates are fast.

  • SEO teams publishing pages

    Keyword rows become blog posts or landing pages. Content scales.

  • Agencies updating client sites

    Content prepared in sheets is pushed to Webflow. Clients edit in sheets.

  • Teams auditing CMS content

    Webflow items are exported to a sheet. Gaps are easy to spot.

More apps

Google Sheets, Webflow and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Write content

For each keyword row, write a post with OpenAI and create a Webflow CMS draft.

Publish alert

When a Webflow item is published from my sheet, post the link to #marketing.

Researched posts

Research each topic row with Perplexity and create a Webflow draft with sources.

Setup

Connect Google Sheets and Webflow once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Webflow

CMS / Website builder

  1. Open your site in Webflow and go to Site settings, then Apps & integrations.
  2. Under API access, choose Generate API token and give it a name.
  3. Set the permission for each API to none, read or read and write, for example read on Forms and read on Ecommerce.
  4. Copy the token, then save it as a secret on Connections & secrets in the ClickRuntime dashboard.

FAQ

Questions about connecting Google Sheets and Webflow

Does it publish to my live site?
Only if you ask it to. By default items are saved as drafts in the Webflow CMS, so you can review them in the Designer before publishing.
What do I need from Webflow?
A site API token with CMS read and write access, and the ID of the collection to use. Both are saved in your ClickRuntime dashboard.
Which fields does it fill?
The ones you name, such as name, slug, post body, meta description or an FAQ rich text field. They must already exist in your collection.
Can my team still edit the sheet?
Yes. The automation only reads rows marked ready and writes a status and link back, so everyone can keep planning in the same sheet.
Can it upload images?
Yes. Image fields can be set from a URL.
Does it need a Webflow API token?
Yes. A site API token with CMS access, saved in the ClickRuntime dashboard.
Can it publish the site?
Yes. It can publish items or the site through the API.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Webflow should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude