# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.qwary.com/product-guide/integration/google-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.