# Google Sheet Task

## 📥 What is the Google Sheet Task ?

The Google sheet task will automatically save the respondent and all his answers in a Google Sheet of your choice.

{% hint style="warning" %}
To setup Google Sheets and let ngSurvey access your spreadsheets you will need to link a [Google Service Account](https://docs.ngsurvey.com/installation-setup/system-settings/google) to your ngSurvey account from your [account settings](https://docs.ngsurvey.com/personal-account) page .
{% endhint %}

## 🔅 Google Sheet Task properties

* **`Spreadsheet`** to which the target sheet belongs.  
* **`Sheet`** that will keep the respondent answers.

Make sure that the spreadsheet you want to use has been shared with your [Google Service Account](https://docs.ngsurvey.com/personal-account) using the Share button inside the Google Sheets user interface. 

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MBKo7vjQ11Jh3WvlX9g%2F-MBKtrxl7F_f3hBA6Sld%2Fimage.png?alt=media\&token=62c52096-747f-4c92-b5fd-0200abf65972)

##  📚 Respondent row format

The target format of the respondent and its responses is one column per question that will hold the respondent answer in it. If the question has a mixed of text and selection [answer types](https://docs.ngsurvey.com/form-management/form-designer/answers/answer-types) ngSurvey will use one column for the question and one extra column for each answer type that is text based like a [comment field](https://docs.ngsurvey.com/form-management/form-designer/questions/question-types/standard/text-comment-field) for example.

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MBKo7vjQ11Jh3WvlX9g%2F-MBKruxJ8iQhRi0vlAYf%2Fimage.png?alt=media\&token=60409fe2-6a91-40f3-acd6-9309416228c2)

{% hint style="info" %}
🧙 The first column will automatically created with the questions and answers labels. If a [reporting alias](https://docs.ngsurvey.com/form-management/reports) has be setup for either the question or answer it will be used instead of the label. 
{% endhint %}