How to sync Webflow CMS collections to Google Sheets with a Webflow Cloud route

A Webflow Cloud guide explains how to create a server-to-server sync that exports a Webflow CMS collection into a Google Sheets tab through a protected Next.js Route Handler. The setup requires a Webflow site and read-only CMS API token, a Google service account with the Sheets API enabled and spreadsheet access, a Next.js 15+ app using npm, and a shared secret to authorize sync requests. The route paginates through Webflow collection items, converts selected field data into rows alongside IDs, draft and archive states, and publication timestamps, obtains a Google access token by signing a JWT with Web Crypto, writes the results to Sheets, and clears leftover rows from prior larger exports. Credentials are stored as Webflow Cloud environment variables, with tokens, private keys, and the sync secret marked as secrets, while deployment requires accounting for the app mount path in the public endpoint URL. The guide emphasizes Cloudflare Workers compatibility by avoiding Node file-system access and the unsupported Next.js edge runtime directive, retaining a portable custom constant-time secret comparison, and handling PEM newline formatting. Once deployed, any trusted scheduler or command-line client can trigger the POST endpoint, enabling non-Webflow users to audit current CMS content in Sheets without manual CSV exports or Designer access.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.