FormApp

What it does

Create Google Forms and read or update form responses.

Methods used

.addTextItem() .create() .getEditUrl() .getPublishedUrl() .getResponses() .openById() .setDestination()

Related snippets

Official Google docs

Explore

Related methods

.create()
Creates a new blank Google Form.
.getResponses()
Returns all submitted responses to the form.
.setDestination()
Sends new form responses to a spreadsheet.
.addTextItem()
Adds a short-answer text question to the form.
.openById()
Opens an existing form by its file ID.

More Apps Script

Better Sheets tutorials

Access Free API's with Google Sheets

Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with AP...

Intermediate

COUNTIF() IF() IMAGE() ISBLANK()

Add Columns Automatically

Create your own "Add Columns" button just like the add rows to the bottom.

Intermediate

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script

Advanced

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu Create Native-like Functions Get URL and Sheet ID's vi...

Advanced Intermediate

Automate Emails

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

Beginner

Automate Move Blank Rows

Automate the apps script we just created that moves blank rows from one ...

Intermediate

Automatically Align Top

Automate formatting cells to align top. Either by a time-based trigger o...

Automatically Clear Content | Refresh Reuse Recycle Templates

Create automatic functions to clear content.

Intermediate

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, ge...

Intermediate

Automatic Calculations

Create custom scripts to make your spreadsheets more like tools.

Beginner

Breaking Through Errors In Apps Script

See where to find errors in your apps script and how to fix them. You wi...

Intermediate

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and c...

Advanced

SUBSTITUTE()

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hou...

Advanced

ChatGPT Clone in Google Sheets Part 1

In this tutorial, learn how to create a ChatGPT-like interface using Goo...

ChatGPT Clone in Google Sheets Part 2

We fix the problem of OpenAI's API not remembering our last questions. A...

Advanced

Close Form After Certain Number of Responses

Create automatic triggers that close a form after a certain number of re...

Intermediate

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email vi...

Intermediate

ARRAYFORMULA() FILTER() JOIN() SPLIT()

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Curated sites, articles, and more web resources super easily into a Goog...

Beginner

Different Kinds of Automation

A brief description of types of automation. I go way more in depth in “M...

Beginner

IF()

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do...

Advanced

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in yo...

Intermediate

Explore Readable Hex Codes

Welcome to the captivating world of Readable Hex Codes! In this video, w...

Fast FAQS

New Tool for you: Fast FAQs. Create a quick 10 question FAQ for any new ...

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations: Allow User to Reopen form without Apps ...

Advanced

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

How To Change Date Format Automatically

Create automations to change date format based on the format you want, i...

Advanced

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show y...

Intermediate

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets

Intermediate

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far ...

Intermediate

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

Learn how to add multiple rows to your google sheets by hand, and automa...

Advanced Intermediate Beginner

How to Move Tab To End Easily with Apps Script

Create an apps script to move active tab to the far right.

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...

Advanced

FILTER() IFNA()

Introducing SheetFools

Free google sheets automations pranks you can use right now. Launching p...

Intermediate

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: w...

Advanced

IF() IMPORTRANGE()

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.

Advanced

IF() IMPORTRANGE()

Saving OpenAI API Calls inside of Google Sheets

Copy text output and input into a google sheet from your OpenAI API call...

Intermediate

Self Destructing Google Sheet

Create a sheet that can trash itself. It can delete itself instantly or ...

Intermediate

Shaman: AI Blog Writer

I will introduce you to the power of AI writing in Google Sheets using a...

Intermediate

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Revolutionary Method to Manage Your Video Stories! Learn how to delete o...

Advanced

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

Uncheck Every Checkbox in Google Sheets

Automatically uncheck a whole range of checkboxes. Or just do it yoursel...

Intermediate

Explore

Related methods

More Apps Script

Access Free API's with Google Sheets

Add Columns Automatically

Add Tasks to Google Tasks From Google Sheets

Advanced Coding in Google Sheets for Programmers

Automate Emails

Automate Move Blank Rows

Automatically Align Top

Automatically Clear Content | Refresh Reuse Recycle Templates

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatic Calculations

Breaking Through Errors In Apps Script

Build Your Own AI Writer in Google Sheets

Built a Cookie Clicker Clone in Google Sheets

ChatGPT Clone in Google Sheets Part 1

ChatGPT Clone in Google Sheets Part 2

Close Form After Certain Number of Responses

Create a PR Agency From Scratch

Curate Google Sheets Easily - Automatic Bookmarklet Maker

Different Kinds of Automation

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Every Google Drive File Created in Last 24 Hours

Explore Readable Hex Codes

Fast FAQS

Form Automations: Close Multiple Forms When Over Limit

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

How To Change Date Format Automatically

How to Create a Google Form Automatically

How to Create AI Images From Google Sheets

How To Duplicate a Tab and Move it to the End in Google Sheets

How to Insert Multiple Rows in Google Sheets (Easy to Hard)

How to Move Tab To End Easily with Apps Script

How to Power Testimonials with Google Forms and Sheets

Introducing SheetFools

Password Protecting Data In a Google Sheet

Password Protecting Data In a Google Sheet Part 2 The Basics

Saving OpenAI API Calls inside of Google Sheets

Self Destructing Google Sheet

Shaman: AI Blog Writer

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Twitter App Clone in a Google Sheet

Uncheck Every Checkbox in Google Sheets

Related blog posts

How to Send Google Forms Entries Automatically with Apps Script

What's Better Than Google Sheets?

How to Use Google Sheets as a Website Database