Close a Form and Export Final Responses
A 3-step recipe with Google Forms. We can help you get access.
Recipe · 3 steps
Close a Form and Export Final Responses
with Google Forms
Stop collection on a form and take a clean final export of its responses.
- Close the form to new responses first, so the export below runs against a set that can no longer change. The form stays published by default, which shows responders a closed notice instead of an error.
- List the final set of responses. Collection is already closed, so this is a stable export; follow the next page token until it is absent to take the whole set.
- Read the form back to archive its final structure, publish settings, and the linked sheet id that holds the accumulated responses.
What you'll need to have ready
- formId: The id of the form to close.
- keepPublished: Whether the form stays published while closed. Left true, responders see a closed form rather than a broken link.
- pageSize: Maximum number of responses to return per page in the export.
For your developer
Arazzo workflow google-forms:close-form-and-export, 3 operations: setPublishSettings → listFormResponses → getForm. Specs on APIs.io.