Sends new form responses to a spreadsheet.
class FormApp method .setDestination()
FormApp is the Apps Script service.
.setDestination() is the method name you will see after a dot in your code.
What it does
Why it's used
- Send new responses straight into a spreadsheet tab.
- The usual setup for form-to-sheet automation.
Common errors
- Forgetting parentheses on setDestination. Write FormApp.setDestination(), not FormApp.setDestination or setDestination by itself.
- Skipping dots between chained calls. Each step needs a dot, like FormApp.setDestination().
- Adding spaces where they do not belong. Write FormApp.setDestination(), not FormApp .setDestination(), FormApp.setDestination (), or FormApp . setDestination().
- Wrong capitalization. Use FormApp and setDestination, not formapp or setdestination.
1 Snippets using this method
Explore
Related methods
-
.getResponses()
Returns all submitted responses to the form.
-
.create()
Creates a new blank Google Form.
-
.getPublishedUrl()
Returns the public link respondents use to fill out the form.
-
.openById()
Opens an existing form by its file ID.
-
.getEditUrl()
Returns the link to edit the form.
More Apps Script
2 Better Sheets tutorials
Automate Emails
Related blog posts
Written guides about FormApp.setDestination().