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

Sends new form responses to a spreadsheet.

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.

Explore

Related methods

Better Sheets tutorials

Automate Emails

Automate Emails

Set up automated email notifications based on Google Sheets data. Super ...
Automatic Calculations

Automatic Calculations

Create custom scripts to make your spreadsheets more like tools.
Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curated sites, articles, and more web resources super easily into a Goog...
Different Kinds of Automation

Different Kinds of Automation

A brief description of types of automation. I go way more in depth in “M...
How to Create a Google Form Automatically

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show y...
How to Power Testimonials with Google Forms and Sheets

How to Power Testimonials with Google Forms and Sheets

I show you how I use a Google Form and a Google Sheet to power the testi...

Related blog posts

Written guides about FormApp.setDestination().

Browse the blog