---
title: "Get The Last Response from a Google Form"
author: "Sourabh Choraria"
date: 2019-12-17T10:10:18+00:00
modified: 2019-12-17T10:10:21+00:00
canonical_url: https://pulse.appsscript.info/p/2019/12/get-the-last-response-from-a-google-form/
markdown_url: https://pulse.appsscript.info/p/2019/12/get-the-last-response-from-a-google-form.md
categories:
  - "Forms"
  - "Solutions"
tags:
  - "@AdamGeisen"
  - "tamingthetech.com"
featured_image: https://pulse.appsscript.info/files/2019/12/image.png
description: "Most of the time, when I write Google Scripts that address a Google Form, I almost always access the data through the spreadsheet of responses. But sometimes, getting back to the Form itself is necessary...."
---

# Get The Last Response from a Google Form

![Get The Last Response from a Google Form](https://pulse.appsscript.info/files/2019/12/image.png)

![](https://pulse.appsscript.info/files/2019/12/image.png)

> Most of the time, when I write Google Scripts that address a Google Form, I almost always access the data through the spreadsheet of responses. But sometimes, getting back to the Form itself is necessary. In those cases, I use this code to access the final response. It’s not quite as simple as it seems.

The script below accesses the last response to a form, gets the email, timestamp, and answers and then adds them to a Google Sheet.

Source: [*Get The Last Response from a Google Form***](https://tamingthetech2--tamingthetech.repl.co/reader.html?a=1576566425794)

---

*Published by [Sourabh Choraria](https://pulse.appsscript.info/p/author/scriptgs/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/12/get-the-last-response-from-a-google-form/](https://pulse.appsscript.info/p/2019/12/get-the-last-response-from-a-google-form/)*