---
title: "Apps Script Basics – Using Form Responses – Learning Google Workspace & Apps Script"
author: "Martin Hawksey"
date: 2022-03-02T21:05:31+00:00
modified: 2022-03-02T21:07:14+00:00
canonical_url: https://pulse.appsscript.info/p/2022/03/apps-script-basics-using-form-responses-learning-google-workspace-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/03/apps-script-basics-using-form-responses-learning-google-workspace-apps-script.md
categories:
  - "Beginner"
  - "Forms"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@barrielroberts"
  - "bazroberts.com"
featured_image: https://pulse.appsscript.info/files/2022/03/GAS2-5-10.png
description: "This post taken from Barrie Roberts' latest book “Beginner’s Guide to Google Apps Script 2 – Forms“, available on Amazon. The post covers some different ways that you can interact with Google Form responses and contains lots of useful code and tips that might be useful to other Google Apps Script developers."
---

# Apps Script Basics – Using Form Responses – Learning Google Workspace & Apps Script

![Apps Script Basics – Using Form Responses – Learning Google Workspace & Apps Script](https://pulse.appsscript.info/files/2022/03/GAS2-5-10.png)

> [https://www.bazroberts.com/2017/10/22/apps-script-basics-14-using-form-responses/](https://www.bazroberts.com/2017/10/22/apps-script-basics-14-using-form-responses/)
> In this post, we’re going to look at how we can work with the responses a form user submits.
> We’ll look at two main ways, 1) Getting the form responses from a Google Sheet, 2) Getting the form responses directly from a Google Form.
> To show some practical uses of this, we’ll do the following:
> 
> Set up a simple **problem-reporting log**, which will email the relevant parties the problem in a classroom. We’ll do this via the Sheet and via the Form.
> Get students’ pieces of writing submitted via a Google Form and **copy them to their individual sheets**, ready to have feedback added.
> Set up a simple **appointment system**, which will update itself as people take the appointments, leaving only the available ones on the Form.

This post taken from Barrie Roberts’ latest book “**Beginner’s Guide to Google Apps Script 2 – Forms**“, available on Amazon [here**](https://amzn.to/3y2D2gU). The post covers some different ways that you can interact with Google Form responses and contains lots of useful code and tips that might be useful to other Google Apps Script developers.

Source: *[Apps Script Basics – Using Form Responses – Learning Google Workspace & Apps Script*](https://www.bazroberts.com/2017/10/22/apps-script-basics-14-using-form-responses/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/03/apps-script-basics-using-form-responses-learning-google-workspace-apps-script/](https://pulse.appsscript.info/p/2022/03/apps-script-basics-using-form-responses-learning-google-workspace-apps-script/)*