# How to use the lookup table?

{% embed url="<https://youtu.be/uMfWev0tA-g>" %}

Say for example that we want to send emails to managers of different departments depending on the department selected during form-filling by the employee. This can be easily and simply achieved with the help of Lookup Tables.

#### 1. Open your Google form and choose the parameter in which you plan to select emails (Make sure the parameter type is of either Text, Multiple-choice, Time, or Date only for the Lookup feature to work.)&#x20;

Here the parameter is the department, so approval emails shall be sent depending on the department selected by the employee eg if Finance is chosen then the approval shall only be sent to the Finance department manager/managers.

&#x20;

<figure><img src="https://images.tango.us/workflows/26fa25fb-3f76-4e11-88b2-343dcbbc3a33/steps/578e8fb9-ef61-4b88-8bff-7bc30e855548/9d14d2d7-d8b4-48ab-931d-e3707220ca60.png?crop=focalpoint&#x26;fit=crop&#x26;fp-x=0.4932&#x26;fp-y=0.5828&#x26;fp-z=1.1664&#x26;w=1200&#x26;border=2%2CF4F2F7&#x26;border-radius=8%2C8%2C8%2C8&#x26;border-radius-inner=8%2C8%2C8%2C8&#x26;blend-align=bottom&#x26;blend-mode=normal&#x26;blend-x=0&#x26;blend-w=1200&#x26;blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n&#x26;mark-x=109&#x26;mark-y=51&#x26;m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz05ODEmaD03MzQmZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D" alt="" width="563"><figcaption></figcaption></figure>

#### 2. Go to approval section on the add-on and Click 'Add Dynamic Email'

![Step 2 screenshot](https://images.tango.us/workflows/26fa25fb-3f76-4e11-88b2-343dcbbc3a33/steps/1686b717-beb3-4a50-aff9-5a9351177039/e3053673-f370-4a10-99ef-0a44f132b1dd.png?crop=focalpoint\&fit=crop\&fp-x=0.7191\&fp-y=0.7190\&fp-z=1.7809\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=597\&mark-y=474\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz01NjAmaD03NSZmaXQ9Y3JvcCZjb3JuZXItcmFkaXVzPTEw)

#### 3. Select the parameter you plan to filter by ( here it is Department)

make sure that this is also the first column in the lookup table&#x20;

<figure><img src="/files/IwTdVFKJkr0rg46h5SBA" alt=""><figcaption></figcaption></figure>

#### 4. Now click on Google Sheet.

<figure><img src="/files/2dz8GaIeVQLR02zl8Lvg" alt="" width="281"><figcaption></figcaption></figure>

#### 5. Create a new sheet that contains the Data for Lookup and also your email flow.

Remember to add the filter parameter (department here) in column A, and the emails following that.

&#x20;

<figure><img src="/files/NMnok1hYCsngWluLVXbF" alt=""><figcaption><p>Step 4 screenshot</p></figcaption></figure>

#### 6. Click on the Lookup Table button

![Step 5 screenshot](https://images.tango.us/workflows/26fa25fb-3f76-4e11-88b2-343dcbbc3a33/steps/0f58c997-7a64-4b9d-b114-af7f375fef98/8cc1117b-770d-4ff5-b42f-3f800ec2bc1e.png?crop=focalpoint\&fit=crop\&fp-x=0.8333\&fp-y=0.8329\&fp-z=3.0000\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n)

#### 7. In the Lookup settings select your lookup sheet (here Organization schema) and select the column with emails where you want the approvals to go. (Here we select Manager 1 Column)

![Step 6 screenshot](https://images.tango.us/workflows/26fa25fb-3f76-4e11-88b2-343dcbbc3a33/steps/07586223-c872-4374-906f-b9b00478df15/381911ed-3001-4244-a621-56773b595bdb.png?crop=focalpoint\&fit=crop\&fp-x=0.3933\&fp-y=0.2965\&fp-z=2.0000\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=156\&mark-y=261\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz03MjEmaD0zODcmZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D)

#### 78 Click on Save and Close

![Step 7 screenshot](https://images.tango.us/workflows/26fa25fb-3f76-4e11-88b2-343dcbbc3a33/steps/b6a03536-3248-4bd2-b8ba-dd28410ec539/a0c56e55-c3f5-421b-95d3-2539414683f4.png?crop=focalpoint\&fit=crop\&fp-x=0.3610\&fp-y=0.7421\&fp-z=2.0000\&w=1200\&border=2%2CF4F2F7\&border-radius=8%2C8%2C8%2C8\&border-radius-inner=8%2C8%2C8%2C8\&blend-align=bottom\&blend-mode=normal\&blend-x=0\&blend-w=1200\&blend64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL21hZGUtd2l0aC10YW5nby13YXRlcm1hcmstdjIucG5n\&mark-x=225\&mark-y=492\&m64=aHR0cHM6Ly9pbWFnZXMudGFuZ28udXMvc3RhdGljL2JsYW5rLnBuZz9tYXNrPWNvcm5lcnMmYm9yZGVyPTYlMkNGRjc0NDImdz03MDImaD0xMTImZml0PWNyb3AmY29ybmVyLXJhZGl1cz0xMA%3D%3D)

#### 9. You can then repeat this can create multiple levels of dynamic recipients so emails go to the other columns in your sheet.


---

# 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://approval-docs.boloforms.com/guides/gsuite-add-on/how-to-use-the-lookup-table.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.