Save to Google Sheets
Append submitted form data as a new row in a connected Google Sheets document.
In the builder: select a widget → On Click or On Change → Add action → Save to Google Sheets
Behavior
When the action runs, Calcopolis sends mapped field values to your Google Apps Script web app, which appends a row to the sheet.
- Requires a Google Sheets integration (Apps Script endpoint + auth).
- Column mapping ties sheet columns to form variable Names.
- Runs when the action fires — typically on Submit.
Setup fields
Create a Google Apps Script deployment, then configure the integration and action:
| Field | Description |
|---|---|
| App Script URL | Web app URL that receives POST data and writes to the sheet. |
| X-Client-Id | Client identifier for your Apps Script (if required). |
| X-Client-Secret | Shared secret for the script endpoint. |
| Auth2 | OAuth configuration when the script requires Google sign-in. |
| Mapping | Map each sheet column to a form variable. |
Action name
Internal label in the builder action list. Use distinct names when the same widget runs multiple actions.
FAQ
Do I need a Google Apps Script?
Yes. Calcopolis calls your script URL; the script is responsible for opening the spreadsheet and appending the row. Deploy the script as a web app with execute access set appropriately.
Why is the row empty or missing columns?
| Symptom | Check |
|---|---|
| Empty cells | Mapping must reference exact variable Names |
| Script error | Test the Apps Script URL with a manual POST from curl or Postman |
| Auth failure | Verify X-Client-Id, X-Client-Secret, and Auth2 match the script |
Google Sheets vs Send Webhook?
Save to Google Sheets is tailored for spreadsheet append with column mapping. Send Webhook posts JSON to any HTTP endpoint — use it for CRMs and generic automations.