Project overview
2410 developed a custom HTML and JavaScript form to be embedded in a SquareSpace site. The form collected three inputs (Grade, Range, Zip), sent them to a Google Sheet via Zapier, and dynamically retrieved calculated results from specific cells in the sheet.
Later, the solution was extended to include formula-based outputs (=Families(...) and =Pods(...)) calculated in the spreadsheet and displayed on the website.
2410 helped me connect Google Sheet to a SquareSpace website through Zapier and sheet APIs. Great work and fast.
Seller communication level: 4. Recommend to a friend: 5. Service as described: 5.
- baburhabib1024
Key features delivered
- Custom user form with input validation
- Integration with Zapier to forward form data to Google Sheets
- Backend polling to retrieve computed results
- Timeout handling and retry mechanism
- Formula field support in Google Sheets
- Multi-field result display on frontend
Screenshots
Custom front-end form input field for capturing the child's grade level, part of the SquareSpace-embedded form.
Zapier automation step: Catch Hook used to receive data from the website form and trigger backend processes.
Technology stack
HTML
JavaScript
Zapier
Google Sheets API
SquareSpace