Automate
your Google Sheets management with CodeWords
Overviews
How it works?
Connect your Google Sheets account
Link your Google account to access all your spreadsheets and worksheets. Pick the exact sheet you want to work with using the built-in file picker.
Choose your trigger
Decide what starts the workflow — a new Webflow form submission, a CMS item update, a payment confirmation, or even changes happening directly in your spreadsheet.
Map your data fields
Match the information from Webflow to specific columns in your spreadsheet. Form fields, CMS content, user details, and order information can all flow into the right places.
Set your action
Choose what happens in Google Sheets — add a new row, update existing records, find specific data, apply formatting, or create entirely new worksheets when needed.
Data flows seamlessly
Your workflow runs in the background every time the trigger fires. New leads get logged, inventory updates reflect on your site, and records stay synchronized without manual copying.
Format and Validate Data
Apply formatting, add data validation rules, and create conditional formatting automatically. Ensure your spreadsheets stay organized and data stays accurate.
React to Spreadsheet Changes
Trigger workflows the moment data in your spreadsheet changes. When someone updates a row, automatically notify your team, update other tools, or take action.
Analyze Data with AI
Pull spreadsheet data into AI-powered workflows to generate insights, create reports, and analyze trends. Turn raw numbers into actionable business intelligence automatically.
Configure
Build with Gmail
Log every form submission to organized spreadsheet rows
Capture contact forms, survey responses, quote requests, and newsletter signups as structured rows in Google Sheets. Each submission creates a new entry with timestamps, form fields, and user information perfectly organized for analysis or follow-up.
“You can’t do this anywhere else.”
Prompt, build,
accelerate.
When someone submits a form on your Webflow site or when any other trigger fires, the integration instantly adds a new row to your chosen spreadsheet with all the mapped data. You can also configure it to update existing rows instead of always creating new ones, or to search for specific records based on criteria you set.
Yes, you can set up triggers that watch for changes in your Google Sheets. When specific cells are updated or new rows are added, you can push those changes back to Webflow CMS collections, update inventory displays, or trigger other actions on your website. This creates true two-way synchronization.
The integration handles concurrent access smoothly. New rows get added even while you're working in the spreadsheet, and you'll see the updates appear in real-time just like normal Google Sheets collaboration. There's no risk of data loss or conflicts.
Absolutely. You can apply cell formatting, conditional formatting rules, data validation, and even merge cells as part of your workflows. For example, highlight high-value orders in green, flag incomplete submissions in red, or format dates and currency values to match your preferred style.
Use the find rows action to search for records matching specific criteria — like an email address or order ID. Once found, you can update those existing rows with new information. The upsert option combines both: it updates a row if found, or creates a new one if it doesn't exist yet.