# How to Record Customer Responses Using DoubleTick’s Bot Studio and  Google Sheets Integration

**Step-by-Step Guide**

* **Log In to DoubleTick** \
  \
  1\)Start by logging into your DoubleTick account to access the Bot Studio.<br>
* **Navigate to Bot Studio** \
  \
  1\)Go to the Bot Studio section. \
  \
  2\)On the left-hand side, you'll see all available triggers and actions.<br>
* **Create a New Bot** \
  \
  1\)Click on the "Create New Bot" button. \
  \
  2\)Select a Trigger (e.g., "Message Received" or "Button Clicked") that initiates the bot flow.

<figure><img src="/files/6tjiHahVU2fa36WCy04u" alt=""><figcaption></figcaption></figure>

* **Add a Question** \
  \
  1\)Add a Send Message component to the bot flow. \
  \
  2\)In the Body section, type your question. For instance: “What is your age." \
  \
  3\)Click on Response to specify that the customer’s reply will be captured<br>
* **Create a Flow (Optional) If you have follow-up questions:** \
  \
  1\)Connect the Response component to additional Send Message components. \
  \
  2\)Repeat the process for each question you wish to include in the flow.

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

* **Integrate Google Sheets**\
  &#x20;\
  1\) Step 1: Authenticate Google Account \
  \
  &#x20;   a)Add a Google Sheet Action to your bot flow. \
  \
  &#x20;   b)Click on "Sign In with Google" to authenticate. \
  \
  &#x20;   c)Select your Google account and grant the necessary permissions.           &#x20;

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

&#x20;       2\)Step 2: Choose a Spreadsheet \
\
&#x20;          a)Click on the "Select a Spreadsheet" button. \
\
&#x20;          b)A dropdown will appear showing available sheets. Choose the one where you want to store.     &#x20;

<figure><img src="/files/5v3E6L963TjPqr1SZ6fD" alt=""><figcaption></figcaption></figure>

* **Step 3: Map Variables to Headers** \
  \
  1\)DoubleTick automatically reads the headers from the first row of the selected sheet.\
  \
  2\)Identify the variables you wish to capture from the conversation. For instance: \
  \
  &#x20;  a)**Age**: Click on the curly brackets {}, select the age component, and map it to the appropriate \
  &#x20;      header\
  &#x20;   b)**Address**: Repeat the same process for the address.<br>
* Step 4: Save and Enable the Bot \
  \
  1\)Once your flow is ready and Google Sheets integration is complete, save the bot. \
  \
  2\)Enable the bot to make it live

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

***

**Example Use** \
\
Case Let’s say you want to collect customer feedback. Here’s how the bot flow could look:

1. The bot asks, “How would you rate your experience with DoubleTick on a scale of 1-10?”
2. The customer responds with a number (e.g., 8).
3. The bot records this response in the Google Sheet under the header "Rating."
4. If there’s a follow-up question, the flow continues until all required data is collected


---

# 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://learn.doubletick.io/automations-and-integrations/how-to-record-customer-responses-using-doubleticks-bot-studio-and-google-sheets-integration.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.