Google App Script
Run a custom Google Apps Script with selected form variables — flexible automation beyond a simple sheet append.
In the builder: select a widget → On Click or On Change → Add action → Google App Script
Behavior
When the action runs, Calcopolis POSTs the selected payload to your Apps Script web app URL.
- Requires a Google App Script integration.
- You control what the script does (Sheets, Docs, Gmail, custom logic).
- Payload selects which variables are sent.
Setup fields
Deploy your Apps Script as a web app, then configure:
| Field | Description |
|---|---|
| App Script URL | Endpoint URL of the deployed web app. |
| X-Client-Id | Client identifier (if your script validates it). |
| X-Client-Secret | Shared secret header value. |
| Auth2 | OAuth settings when required. |
| Payload | Form variables to include in the request body. |
Action name
Internal label in the builder action list. Use distinct names when the same widget runs multiple actions.
FAQ
How is this different from Save to Google Sheets?
Save to Google Sheets focuses on appending rows with column mapping. Google App Script sends a variable payload to your script — you implement any Google Workspace workflow.
Testing the script
- Deploy Apps Script as web app; copy the URL.
- Map one test variable in Payload.
- Fire the action in Preview and check Apps Script execution logs in Google.
Security
Treat X-Client-Secret like a password. Rotate it if exposed. Prefer HTTPS endpoints only.