Stream ARForms entries to Google Sheets
Connect ARForms to Google Sheets with LeadToSheet to capture popup submissions, calculated fields, and WooCommerce checkout data in a live spreadsheet your team already uses.
CMS: WordPress
Overview
ARForms combines a real-time visual editor with features like mathematical formulas, popup form triggers, and WooCommerce checkout field injection. LeadToSheet adds a persistent, queryable copy of every submission in Google Sheets. This is ideal for teams that need to filter calculated totals or cross-reference order data without logging into WordPress.
Implementation checklist
- 1
Drop in the LeadToSheet script
Paste the SDK snippet into your WordPress footer via Appearance > Theme Editor, a code snippets plugin, or ARForms' custom HTML block.
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 with formula fields
ARForms formula fields compute values before submission. Fill out a test entry that triggers a calculation to confirm the computed result appears as a column in your sheet.
Tip: Calculated values are submitted as plain text, so they display correctly in Sheets without extra formatting.
- 3
Test popup and multi-step triggers
If you use ARForms popup or multi-step layouts, trigger a full walkthrough. LeadToSheet captures the final step's payload, including data from earlier steps.
Customization ideas
Track WooCommerce checkout fields
ARForms can inject fields into WooCommerce checkout. LeadToSheet captures these alongside standard order data, giving you a single sheet with both lead info and purchase context.
Use conditional logic for tab routing
Set a visible read-only text field that changes based on ARForms conditional rules, then configure LeadToSheet to send entries to different sheet tabs depending on that field's value. Hidden fields (input[type='hidden']) are excluded from capture.
Build reporting on formula outputs
Because calculated field values land in Sheets as numbers, you can immediately build pivot tables, charts, or SUMIF formulas across all submissions.
Troubleshooting
Popup form submissions not appearing
Popup forms load via AJAX after the page renders. The SDK uses a MutationObserver to detect dynamically injected forms, so popup forms are captured automatically regardless of when they appear. Ensure the SDK is loaded on every page where popups may appear.
Mathematical formula values showing as zero
ARForms computes formula fields on blur. If your test skips fields, the formula may not recalculate. Tab through every field before submitting to ensure computed values are correct.
Conditional fields not creating columns
Hidden conditional fields are only submitted when their display condition is met. Test with scenarios that reveal every conditional branch to generate all column headers.
Resources
Frequently asked questions
- Can LeadToSheet capture ARForms entries submitted through the real-time editor preview?
- No. Preview mode does not trigger real form submissions. Only published forms on live pages generate entries that sync to Google Sheets.
- Does ARForms' built-in spam protection still work?
- LeadToSheet fires at the browser submit event, before server-side validation completes. Honeypot and reCAPTCHA checks run server-side, so some spam entries may appear in your sheet. Use LeadToSheet's dashboard spam filtering to manage these.
- How are multi-step form entries handled?
- LeadToSheet waits for the final step's submission event. Data from all steps is combined into a single row, matching how ARForms stores the entry internally.