Send Kali Forms leads to Google Sheets
Pair Kali Forms' beginner-friendly builder with LeadToSheet to automatically push text-based submissions and payment data into a Google Sheet.
CMS: WordPress
Overview
Kali Forms is designed for WordPress beginners who need drag-and-drop simplicity with advanced extras like payment processing and SMS notifications. LeadToSheet extends Kali Forms by creating a persistent record of every text-based submission in Google Sheets, giving you searchable, filterable data that is easier to work with than WordPress admin tables.
Implementation checklist
- 1
Add the LeadToSheet script to your site
Paste the snippet into your theme footer or use a header/footer plugin. No Kali Forms configuration changes are needed.
LeadToSheet SDK snippet
<script>(function(w,d,s,u,k,e){if(w.__formsync){return}w.__formsync={q:[],k:k,endpoint:e};var js=d.createElement(s);js.src=u;js.async=1;js.onload=function(){w.__formsync.init&&w.__formsync.init({ clientKey:k })};d.head.appendChild(js);})(window,document,'script','https://www.leadtosheet.com/sdk.min.js','YOUR_CLIENT_KEY','https://www.leadtosheet.com/api/ingest');</script> - 2
Submit a test entry with all field types
Fill out every field type your form uses and submit. Verify that text fields, dropdowns, and payment data appear correctly in your Google Sheet.
Tip: LeadToSheet captures text-based field values submitted in the browser. File uploads and digital signatures are processed server-side and will not appear in your sheet.
- 3
Verify payment field capture
Payment fields processed via Stripe or PayPal render inside cross-origin iframes and are not captured by the SDK. Use the payment provider's webhook to reconcile transactions with your sheet data.
Customization ideas
Track SMS notification delivery
Kali Forms can send SMS on submission. Add a visible read-only field noting the SMS recipient number. Hidden fields (input[type='hidden']) are excluded from capture. This lets your sheet link each entry to its notification target for follow-up tracking.
Automate follow-ups from Sheets
Use Apps Script to trigger email follow-ups or Slack notifications the moment a new submission row appears in your Google Sheet.
Payment reconciliation dashboard
Pair LeadToSheet form data with your Stripe or PayPal dashboard exports to build a pivot table that reconciles form entries against payments for end-of-month reporting.
Troubleshooting
File uploads and signatures not in sheet
LeadToSheet only captures text-based form field values submitted in the browser. File uploads, digital signatures, and other binary data are handled server-side by Kali Forms and will not appear in your Google Sheet. This is expected behaviour, not a bug.
Payment forms redirecting before capture
Some payment gateways redirect users to an external page. LeadToSheet captures form data before the redirect occurs, but confirm the redirect happens after submission, not during field validation.
Resources
Frequently asked questions
- Will LeadToSheet capture Kali Forms' conditional logic fields?
- Yes. Only fields visible at the time of submission are included. Hidden conditional fields are excluded, keeping your sheet clean.
- Are file uploads and digital signatures captured?
- No. LeadToSheet only captures text-based form field values. File uploads and digital signatures are processed server-side by Kali Forms and do not appear in your Google Sheet. Use Kali Forms' entries panel for those.
- Can I sync Kali Forms submissions alongside other form plugins?
- Yes. LeadToSheet captures submissions from any HTML form on the page. If you use multiple form plugins, all of them sync to your sheet with the same script.