Formidable Forms to Google Sheets
Formidable Forms builds applications, not just contact forms. SheetLinkWP handles the complex data structures - calculated fields, repeaters, and entry meta - that break simpler connectors.
Why Formidable Needs a Smarter Sheets Connector
Formidable positions itself as an application builder - Views, calculated fields, repeaters, lookup fields, and a REST API. Generic integrations like Zapier treat all this as flat key-value pairs. Complex data gets truncated, ignored, or mangled.
The Complex-Data Challenge
- Zapier: repeater rows flattened or only first row captured; calculated field values sometimes come as formula strings
- WPSyncSheets: basic repeater support, no calculated field handling, no conditional routing
- Custom development: full control but significant dev time and ongoing maintenance
How to Connect Formidable Forms to Google Sheets
Step-by-step setup guide
- 1
Install SheetLink Forms
Download SheetLink Forms from sheetlinkwp.com, then upload and activate via your WordPress dashboard.
- 2
Deploy Apps Script Webhook
Open your Google Sheet, go to Extensions > Apps Script, paste the receiver, deploy as web app, and copy the URL.
- 3
Map Formidable Field Keys
In SheetLink > Connections, select your Formidable Form and paste the webhook URL. Field keys are auto-detected. For repeaters, choose flattened (comma-delimited) or expanded (one row per entry).
- 4
Test with Complex Entry
Submit a test with calculated fields and repeater rows. Verify correct data flattening in your Sheet.
SheetLinkWP Features for Formidable Users
Repeater Flattening
Choose single-cell delimited or one-row-per-entry expansion for repeater fields.
Calculated Field Capture
Server-side computed values are captured - not the formula string. Accurate data every time.
Entry Meta Sync
Capture entry ID, creation date, update date, IP, user ID, and custom meta alongside form data.
Conditional Routing
Route by form or field value. Different Formidable applications can go to different Sheets.
AI Lead Scoring
Score applications and include the score as a column in your Sheet. Available as an optional add-on.
Feature Comparison
| Feature | Zapier | WPSyncSheets | SheetLinkWP |
|---|---|---|---|
| Repeater field support | First row only | Basic | Full (flatten or expand) |
| Calculated field values | Sometimes formula | Yes | Yes (server-computed) |
| Entry meta | Extra API calls | Limited | Built-in toggle |
| Conditional routing | Multi-path (paid) | No | Built-in |
| Monthly cost | $29.99+ | $4.08 (~$49/yr) | $0 (core included) |
| Per-submission fee | Yes | No | No |
| Retry queue | Paid tiers | No | Yes |
| UTM capture | Manual setup | No | Automatic |
Frequently Asked Questions
How does SheetLinkWP handle Formidable Forms repeater fields?
Two options: flatten into a comma-delimited single cell, or expand with one row per repeater entry (order data repeated on each row).
Are calculated field values sent to Google Sheets?
Yes. SheetLinkWP captures the server-side computed value, not the formula string.
Can I route different Formidable Forms to different spreadsheets?
Yes. Create separate connections for each form, or use conditional routing to direct based on field values.
Does it work with Formidable Views?
SheetLinkWP triggers on form submission. If a form is embedded via a View, submissions are still captured.
Is Formidable Forms Pro required?
SheetLinkWP works with Formidable Lite, but repeaters, calculated fields, and Views are Pro features.
Other Supported Integrations
Your Forms Build Applications. Your Connector Should Keep Up.
Repeaters, calculations, conditional routing - all handled. Lifetime deals from $39.