# Google Sheet

## Table of content <a href="#h_0cb3b151b7" id="h_0cb3b151b7"></a>

1\. [Start with the Integration setup](#h_2c617bf52c)

2.[ Edit and Uninstall Integration](#h_c7729f37f4)

### Start with the Integration setup <a href="#h_2c617bf52c" id="h_2c617bf52c"></a>

### 1. [Go to Qwary & Select Your Existing Survey](https://app.qwary.com/integrate/survey/UBC-VeRpehU=) <a href="#h_af16cc7432" id="h_af16cc7432"></a>

### 2. Click on Integrate <a href="#h_e8c2982cc2" id="h_e8c2982cc2"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556898/776d5668fa1bcc28989f35c5/screenshot_d25d7d55-be6c-4908-b523-987183b0379a.png" alt=""><figcaption></figcaption></figure>

### 3. Click on Connect <a href="#h_4c25d8fe29" id="h_4c25d8fe29"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556900/4853aa46e852ff56500f063b/screenshot_b164517c-ae26-4d25-acde-8aa91074464b.png" alt=""><figcaption></figcaption></figure>

### 4. Click on Sign in with Google <a href="#h_c825a603e8" id="h_c825a603e8"></a>

It will redirect you to Google Login Page.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556901/70c9d40e1914e8610d22e1ef/screenshot_de109acb-92ef-4e9d-b77b-37bcf37061a9.png" alt=""><figcaption></figcaption></figure>

### 5. log in to your Google account <a href="#h_05740baa8c" id="h_05740baa8c"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556904/b4d0706aa9b348aaa6902b35/edited_image_d503588d-2986-40de-aed4-30d7f0e814a8.png" alt=""><figcaption></figcaption></figure>

### 6. Click on Allow <a href="#h_56c7b8d45a" id="h_56c7b8d45a"></a>

By clicking Allow, you are allowing Qwary to read google Sheets from your google drive and update the sheet.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556907/373d213454ad0444e94848a8/screenshot_c5b1faff-2fb6-47fc-bb34-796e6c922080.png" alt=""><figcaption></figcaption></figure>

### 7. Click on the dropdown SELECT SPREADSHEET ID <a href="#h_1f1dcb500d" id="h_1f1dcb500d"></a>

It will list all google sheets from your drive.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556910/f638421ac2d156ec52380c23/screenshot_9630aa19-7805-40a2-8586-80a3874dbd41.png" alt=""><figcaption></figcaption></figure>

### 8. Click on the Dropdown SELECT SPREADSHEET NAME <a href="#h_76fa38d490" id="h_76fa38d490"></a>

Select the sheet that you want to update.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556911/8321f16bd0d344796877cfb6/screenshot_6c03bc03-bd33-4ec3-90d7-b64b843cb1b2.png" alt=""><figcaption></figcaption></figure>

### 9. Click on Survey Question… <a href="#h_f5e256319c" id="h_f5e256319c"></a>

Now you can start mapping your survey values with Google Sheet Columns.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556914/5641094082968677187cc24c/screenshot_ac2b6bc9-5a0e-4db2-8f7b-5f1d9dd8bdfd.png" alt=""><figcaption></figcaption></figure>

### 10. Click on Survey Question <a href="#h_97f14d81ad" id="h_97f14d81ad"></a>

You can map survey questions, variables, response metadata, and contact information.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556919/aa986e0f478d3e8fe1345b51/screenshot_a501e520-cd5e-4c52-9ba2-e00dd8caffb4.png" alt=""><figcaption></figcaption></figure>

### 11. Map Survey Question <a href="#h_cbf04528d6" id="h_cbf04528d6"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556922/0fb14ed9d92163094ab6ff00/screenshot_40a06e39-03d8-400c-87dd-63cc27045c7a.png" alt=""><figcaption></figcaption></figure>

### 12. Repeat the process to complete all mapping <a href="#h_c4a850fa47" id="h_c4a850fa47"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556923/aa89687d80f801a8c86a4d59/screenshot_c7db7a38-afd9-4f20-a7b0-cb05b6adcf08.png" alt=""><figcaption></figcaption></figure>

### 13. Click on Survey Question <a href="#h_1cd4fb1179" id="h_1cd4fb1179"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556928/8b5ea544d4ceb1c6dc5e65bb/screenshot_6e7d60a5-7cc2-465c-8ce3-87b344a0f0e9.png" alt=""><figcaption></figcaption></figure>

### 14. Click on Please tell us more <a href="#h_479b3276ef" id="h_479b3276ef"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556931/97385418c0ce765d79e56b5f/screenshot_63f7d0aa-42a1-4f98-a38f-14c6100cd8ce.png" alt=""><figcaption></figcaption></figure>

### 15. Click on SAVE <a href="#h_c1e81a7ad5" id="h_c1e81a7ad5"></a>

We have completed the integration setup. Congratulations 🎊🎊🎊🎊

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594556935/d6836e2711ed9e9a58f9fd94/screenshot_085f32c8-9477-4c2b-88fe-37469f1a9c71.png" alt=""><figcaption></figcaption></figure>

### Now we will learn to edit and uninstall the integration <a href="#h_c7729f37f4" id="h_c7729f37f4"></a>

### 1. Click on Google Sheets… <a href="#h_4b84eeae5d" id="h_4b84eeae5d"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594560039/81b8fbc28df4c6a70be66a74/screenshot_4e25f668-0be7-412c-80b4-c4e8b60bb5bc.png" alt=""><figcaption></figcaption></figure>

### 2. Click on highlight <a href="#h_02204cdbd5" id="h_02204cdbd5"></a>

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594560043/280bd135081069fbeaada1f8/screenshot_71634b7f-f779-4f48-bb8f-ee195c9b1f8f.png" alt=""><figcaption></figcaption></figure>

### 3. Click on Edit Configuration <a href="#h_248a08f2cd" id="h_248a08f2cd"></a>

You can remap integration with edit configuration.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594560047/b4ab2027596d425cf63982f9/screenshot_60ef1ea6-4329-4958-83fa-f85edd1c4d77.png" alt=""><figcaption></figcaption></figure>

### 4. Click on Delete <a href="#h_0e24832e03" id="h_0e24832e03"></a>

Delete will uninstall and remove the integration. Responses won't be synched to google Sheets anymore.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594560050/1ed9daa9739ab73874f2baa6/screenshot_ceb1648b-cf3e-45e4-8533-0046fa86da3d.png" alt=""><figcaption></figcaption></figure>

### 5. Click on Delete <a href="#h_de065db327" id="h_de065db327"></a>

We have successfully uninstalled the integration.

<figure><img src="https://qwary.intercom-attachments-1.com/i/o/594560052/3ed727e60fda8267fc245378/screenshot_83c2d81c-d724-43a3-9def-8a84c0208509.png" alt=""><figcaption></figcaption></figure>
