Built a Zapier‑based system that lets the client manage Stripe payments and Webflow CMS directly from Google Sheets. A bidirectional sync keeps Sheets, Stripe, and Webflow perfectly aligned, removing manual entry and reducing errors.
Key Features
Two‑Way Sync: Changes in Sheets update Stripe customers, payments, and Webflow CMS items—and platform updates flow back to Sheets.
Payments Automation: Create/update customers, invoices, subscriptions, and refunds from simple row edits.
Stripe Action: Create/update customer, charge/invoice/subscription, or process refund.
Webflow Action: Create/update CMS item; publish if flagged.
Sync Back: Write resulting IDs, URLs, and statuses to Sheets; update mirrors when Stripe/Webflow change.
Notify & Log: Post success/failure; store timestamps and error messages for audit.
Challenges & Solutions
Race Conditions: Added queueing and dedupe keys; used Step Delays and conditional Paths.
API Limits: Implemented batching and exponential backoff with Webhooks/Code steps.
Data Consistency: Centralized ID mapping and enforced required fields via protected ranges and validation.
Results
Zero manual re‑entry between finance, CMS, and tracking sheets.
Fewer errors and faster updates across platforms.
Single source of truth in Sheets with live statuses and links.
Goal
Deliver a robust, low‑code automation that lets non‑technical users run Stripe billing and Webflow content entirely from Google Sheets—reliable, auditable, and fast.
Like this project
Posted Jan 12, 2026
Manage payments and CMS from Sheets with real-time two-way sync—no manual entry, fewer errors, faster operations.