Sync Zigaform to Google Sheets automatically
Capture cost estimation outputs, booking form details, and multi-step entries from Zigaform in a Google Sheet that updates the moment a visitor submits.
CMS: WordPress
Overview
Zigaform specialises in Bootstrap-based forms with built-in cost estimation and booking/appointment capabilities. LeadToSheet turns each completed estimate or booking into a spreadsheet row, giving sales teams immediate visibility into prospect budgets and appointment requests without waiting for email notifications or checking the WordPress dashboard.
Implementation checklist
- 1
Load the LeadToSheet SDK
Place the script tag in your WordPress footer. Zigaform's Bootstrap markup renders standard form elements that the SDK recognises automatically.
LeadToSheet SDK snippet
<script async src="https://www.leadtosheet.com/api/sdk?k=YOUR_CLIENT_KEY"></script> - 2
Submit a cost estimation form
Fill out a complete cost estimation with all options selected. Confirm the calculated total and each selected line item appear as columns in your Google Sheet.
Tip: Zigaform computes estimates client-side. The final total is submitted as a regular field value.
- 3
Test a booking/appointment form
Select a date, time, and service to verify that appointment details sync correctly. Date fields should appear in a Sheets-compatible format.
Customization ideas
Build a quote pipeline in Sheets
With cost estimation values landing as numbers, create a sales pipeline sheet that tracks estimates from initial quote through to close, using Sheets formulas to calculate win rates.
Route bookings to a calendar
Use Apps Script to read new booking rows and create Google Calendar events automatically, bridging Zigaform appointments with your team's schedule.
Segment by multi-step progress
Zigaform multi-step forms can include a visible read-only field tracking the total steps. Hidden fields (input[type='hidden']) are excluded from capture. Use this to identify which step users most often abandon when comparing against completed entries.
Troubleshooting
Bootstrap CSS conflicts
Zigaform loads Bootstrap for form styling. If your theme also loads Bootstrap, version conflicts can cause forms to render incorrectly or submit events to fail. Use a Bootstrap isolation plugin or dequeue the duplicate.
Cost estimation showing as blank
The estimation total is computed via JavaScript on the client. If the user submits before the calculation completes (e.g. on a slow connection), the value may be empty. Add a required validation to the total field.
Appointment date formatting issues
Zigaform date pickers may use non-standard formats. If Google Sheets does not recognise the date, set the date picker format in Zigaform to YYYY-MM-DD for universal compatibility.
Resources
Frequently asked questions
- Are cost estimation line items captured individually?
- Yes. Each selected option in a Zigaform cost estimation form submits as a separate field. LeadToSheet creates a column for each, alongside the computed total.
- Are file uploads captured from Zigaform?
- No. LeadToSheet only captures text-based form field values. File uploads are processed server-side by Zigaform and do not appear in your Google Sheet. Use Zigaform's entries panel to access uploaded files.
- Does Zigaform's conditional logic affect data capture?
- Only visible conditional fields are submitted. LeadToSheet respects this behaviour, so your sheet only contains data the user actually provided.