Add Google Sheets to your Form to Email plugin
Form to Email sends submissions straight to your inbox. LeadToSheet adds a Google Sheets copy so you have a permanent, searchable record beyond your email.
CMS: WordPress
Overview
Form to Email is a lightweight WordPress plugin for basic contact forms. It creates customizable forms via shortcode and sends every submission as an email. There is no entry storage or export. LeadToSheet solves this by creating a Google Sheets log of every submission, giving you a structured archive that email alone cannot provide.
Implementation checklist
- 1
Add the LeadToSheet script to your site footer
Paste the snippet into your footer template or use a code injection plugin. Form to Email renders standard HTML forms that the SDK detects immediately.
LeadToSheet 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 message
Fill out your Form to Email form and verify you receive both the email notification and a new row in your Google Sheet.
Tip: Form to Email has minimal field validation. Include all field types you use (text, email, textarea) in your test.
- 3
Check field-to-column mapping
Review your Sheet after the first submission. Rename columns if the plugin's default field names are not descriptive enough for your workflow.
Customization ideas
Replace email-only archiving
Emails get buried and are impossible to analyze. Your Google Sheet becomes the primary record, with email serving as a real-time notification only.
Add response-tracking workflows
Create a Status column in your Sheet and use Google Sheets' dropdown validation to track which inquiries have been responded to and which are still pending.
Capture context email lacks
Form to Email sends only field values. LeadToSheet adds the page URL, referrer, browser info, and timestamp to every row for richer context.
Troubleshooting
Email arrives but no Sheet row
The email is sent server-side while LeadToSheet operates client-side. Check that the script is loading correctly in your browser developer tools console.
Sheet row appears but no email
This is a server-side email delivery issue (SMTP misconfiguration). Your Sheet data is safe. Fix your WordPress email settings using an SMTP plugin.
Custom field names showing as field_1, field_2
Form to Email may use generic name attributes. Edit your form shortcode to specify descriptive name values for each field so Sheet columns are meaningful.
Resources
Frequently asked questions
- Does LeadToSheet interfere with the email delivery?
- No. Form to Email handles email server-side. LeadToSheet captures client-side. They are completely independent processes.
- Can I search old submissions that were only emailed?
- Only submissions made after LeadToSheet is installed appear in your Sheet. For older submissions, you would need to manually import from email.
- Is this overkill for a simple contact form?
- A one-line script tag is minimal effort. The Google Sheet gives you search, filter, and sharing capabilities that email notifications fundamentally lack.