Sync BestWebSoft Contact Form to Google Sheets
Contact Form by BestWebSoft offers reCAPTCHA, multi-language support, and department-based email routing. LeadToSheet adds Google Sheets capture so you have a structured log alongside email notifications.
CMS: WordPress
Overview
Contact Form by BestWebSoft is a straightforward WordPress form plugin with reCAPTCHA integration, GDPR consent checkboxes, multi-language support, and department-based email routing. LeadToSheet captures every validated submission and streams it to Google Sheets, giving you a centralized record that is easier to manage than scattered email inboxes across departments.
Implementation checklist
- 1
Add the LeadToSheet script globally
Place the snippet in your theme footer or use the BestWebSoft header/footer plugin to inject it site-wide.
LeadToSheet snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Test with reCAPTCHA enabled
BestWebSoft forms often use reCAPTCHA. Submit a test form and verify that only validated submissions (those passing reCAPTCHA) appear in your Sheet.
Tip: LeadToSheet fires after reCAPTCHA validation, so spam submissions never reach your Sheet.
- 3
Submit to each department route
If you use department-based email routing, submit a test entry for each department. LeadToSheet captures the department field so you can filter entries in your Sheet.
Customization ideas
Centralize multi-department inquiries
Instead of checking separate email inboxes per department, filter the department column in your Google Sheet to see all inquiries in one place with a single click.
Track GDPR consent in a dedicated column
BestWebSoft's GDPR checkbox value is captured as a boolean column. Use this for compliance audits directly from your Sheet without querying the WordPress database.
Support multi-language form analysis
For multilingual WordPress sites, LeadToSheet captures the form language context. Filter by language to analyze inquiry volume across different locale audiences.
Troubleshooting
reCAPTCHA blocking all submissions
If reCAPTCHA is misconfigured and blocks every submission, no data reaches LeadToSheet either. Fix the reCAPTCHA keys in BestWebSoft settings first.
Department field not appearing in the Sheet
The department selector uses a specific field name set by the plugin. Submit a test entry and check your Sheet for a column matching the department dropdown name attribute.
Additional fields not syncing
The pro version of the plugin allows custom fields. Ensure each additional field has a unique name attribute in the plugin settings for proper Sheet column mapping.
Frequently asked questions
- Does LeadToSheet capture the department the form was routed to?
- Yes. The department dropdown value is treated as a regular form field and appears in its own column in your Google Sheet.
- Is the GDPR consent checkbox captured?
- Yes. The consent field appears as a boolean value in your Sheet, making it easy to filter for contacts who gave explicit consent.
- Does it work with BestWebSoft's additional plugins?
- LeadToSheet captures the HTML form output regardless of which BestWebSoft add-ons you use. Captcha, sender, and limit-attempts plugins all work alongside it.