# Zapier.com Connection

Using Zapier you can send automatically newly submitted respondent answers to any of the supported zapier application.

## 🚀 Zapier / ngSurvey setup

* To setup a zapier zap you may first create a new zap in your zapier account using the [ngSurvey Zapier application](https://zapier.com/developer/public-invite/73385/969b64f5042ca12ccdc64515da776dc1/).

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6cAJdb4KSmUEtZxap%2F-MC6f-P-YD-_yCwDYWUU%2Fimage.png?alt=media\&token=9fae3de6-a7a0-4e56-8d74-90a3ed3d28a9)

* In the next you will have to set the link between ngSurvey and Zapier by setting up the your ngSurvey account using the settings that you can find in your [ngSurvey developer page](https://docs.ngsurvey.com/personal-account/developer).

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6cAJdb4KSmUEtZxap%2F-MC6fZxfMUbWRa80_L3B%2Fimage.png?alt=media\&token=020c0d12-31c8-4a00-9795-7b93ab66a7f1)

* You may now select the survey from your surveys that will post to zapier the respondent answers as soon as a new respondent has submitted new answers. Click on the refresh fields to get the survey structure (questions, answers). 

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6cAJdb4KSmUEtZxap%2F-MC6fy-2BmxczjLJ99Qd%2Fimage.png?alt=media\&token=12216412-2d6f-4c62-988f-1ac13e80e973)

* Make sure to use the find data feature to find a sample respondent as we will need this sample respondent data to map our columns with zapier later on.

{% hint style="warning" %}
This requires to have at least 1 respondent that was saved for your survey.
{% endhint %}

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6hh0yFJ8b20CInhnt%2F-MC6hpkdR3F16LAsUCEZ%2Fimage.png?alt=media\&token=e655083b-5640-47ad-a9c2-f70a7a2fc46c)

{% hint style="success" %}
Now that we have setup ngSurvey with zapier we can connect it to any of the existing Zaps application.
{% endhint %}

## 🔗 Link to a Zapier zap

In this small example we will send the respondent data to a Google Sheet and create a new row in our sheet on each new respondent. 

1\) To do so select the Zapier Google Sheets app.

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6hh0yFJ8b20CInhnt%2F-MC6jULec2PfyL-i5IfA%2Fimage.png?alt=media\&token=96efa9b9-0e6f-4438-9fb3-53ec41091002)

  2\) You may now map the respondent answers to your Google sheet columns.

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6hh0yFJ8b20CInhnt%2F-MC6kJX3WYMIIwvMSD7S%2Fimage.png?alt=media\&token=aa1fb23b-1782-4958-a114-4670c913f0ff)

3\) Using the respondent sample data you can now assign our respondent answers to the Google sheet columns of your choice.

![](https://1025048312-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M8fLhS0bmfBRyq0HdUm%2F-MC6hh0yFJ8b20CInhnt%2F-MC6kpQ6H4_gYNUBLwuN%2Fimage.png?alt=media\&token=d3718b07-1edd-4357-8c38-b0c5aa260da3)

4\) Test your zap using the test respondent sample.

## ✅ That's it! 

You just setup a zap that receive your survey respondent answers and post them to a Google sheet using the Zapier Google Sheet application.