---
title: "Handling Google Forms checkbox responses with Google Apps Script"
author: "Phil Bainbridge"
date: 2023-04-11T18:50:56+00:00
canonical_url: https://pulse.appsscript.info/p/2023/04/handling-google-forms-checkbox-responses-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2023/04/handling-google-forms-checkbox-responses-with-google-apps-script.md
categories:
  - "Beginner"
  - "Forms"
  - "Snippet"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2023/04/Google20Form20Checkbox20responses.png
description: "Latest contribution from Phil Bainbridge which might interest beginners: \"the following Google Apps Script is an example of one way to get the responses from a Checkbox-type question on a Google Form and how you might go about differentiating them.\""
---

# Handling Google Forms checkbox responses with Google Apps Script

![Handling Google Forms checkbox responses with Google Apps Script](https://pulse.appsscript.info/files/2023/04/Google20Form20Checkbox20responses.png)

> Get Google Form responses for checkbox-type questions and perform further actions depending on their values.
> Get all checkbox responses from a Form

The following Google Apps Script is an example of one way to get the responses from a Checkbox-type question on a Google Form and how you might go about differentiating them.

This came up for a project I was working on where I need to put a Yes/No value into 3 separate Google Sheet cells based on 3 options in a question. The slight challenge is that all of the responses come out as a single array for this question, containing the strings of the values that have been ticked only.

Source: *[The Gift of Script: Google Form Checkbox responses*](https://www.pbainbridge.co.uk/2023/04/google-form-checkbox-responses.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2023/04/handling-google-forms-checkbox-responses-with-google-apps-script/](https://pulse.appsscript.info/p/2023/04/handling-google-forms-checkbox-responses-with-google-apps-script/)*