> For the complete documentation index, see [llms.txt](https://docs.gearplug.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gearplug.io/english/set-up-your-integrations/google-spread-sheets/source-actions/get-data-from-a-row.md).

# Get data from a row

1. **Head over to “Gears”** in the top-right corner of your GearPlug App.

<figure><img src="https://lh3.googleusercontent.com/SeY42logzrt5-zRBfsOO74sUkb_-GBmYKZhykRlWTkJNssaT2IiERAMshmlUXUNY65tX-QMJqb5NEzga3g6x3H4bMQMnSr3XqMJE_aK7s1WatEzbnJ4xc9hpVjE-Qc28JQhxj9FiKv5nDNaljqwvEw" alt=""><figcaption></figcaption></figure>

2. **Pick Google Spread Sheets** as your source app and click “Create.”

<figure><img src="https://lh3.googleusercontent.com/ZcDzl6i0_F4JrKca8wdKNHnLhPbCEM-fN0GDQted0Cc66jtebhY5pbvFPb51qK-LtUAQUaAgHFOIhn3wOGPicwdYzrNMAupqq5slNBuylVsWE7H1srPClCpeO6bz6zBUC5rPfbDB5kh7zsUXyfoBgw" alt=""><figcaption></figcaption></figure>

3. **Click the red gear** next to the app’s name. This will show the existing connections. Pick the one you want to use and click “Continue.” If you haven’t created a Plug for the account you want to use, you may do it under “Create a new connection.”

<figure><img src="https://lh6.googleusercontent.com/o4DA1NFVKLCD3-6MfToRU78YEQLKg3YHPdAdDGrVMmEb4cj4I-2jqBlbB8PVjtyxF1HCjNwxgv-dm7CoXQ551SRTC3PF7j94L_dTEjtrRIEaeXJMYW2PpMQMQMk507V0tVXq4D0kXKfPbihsckYkYg" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
GearPlug will check whether the connection functions properly before moving on. If it doesn’t, you won’t be able to continue setting up your Gear.&#x20;
{% endhint %}

4. **Pick “Get data from a row”** in the drop-down menu and click the red gear. Pick the spread sheet and worksheet you wish to use. Then, Click “Create.”

<figure><img src="https://lh3.googleusercontent.com/6dGeSbpbZmLK6wDI1jV0-Yi8GJVB_K_4j5tDY-ZjXchJBW3Xy5s4l-OXGhz2-J_P1hpx3gqATQ8rDd3X165BJFWvXNbsDIT9ks31L-tYcHb0JwkLhNraSh6roDYmapOXWWtvWTwGaFIP-KJ1sQckrw" alt=""><figcaption></figcaption></figure>

5. **Create a test entry** in your sheet, filling in all the fields (columns) you need, when the pop-up window asking for a new record appears. This will execute the connection’s trigger: a new entry.

{% hint style="info" %}
**Create an entry in Google Spread Sheets**: GearPlug needs a new record to test whether it can extract the data successfully. After this record, all future entries will be registered automatically.
{% endhint %}

6. **Review the imported record** to verify everything works properly. If you’re satisfied, click “OK.”

<figure><img src="https://lh6.googleusercontent.com/E1-q2yTUJ7dYt2Xa1YnFYQT7z4g2Ek4SQ9av6rDVG2jl0ojbbXCEhX3Tepaj4ICwvC2AZ5EBocc6A0tw8cd7C7o_FGkgR3RS_bTR6k0YvXU57LTCX6kpAusP2y-eUtvKl62SgXNQNC4L95ZTVa1X2Q" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**Empty fields**: Under the imported record, you’ll find a drop-down list of “Empty Fields.” There, you’ll find fields you can import—but weren’t used in the contact form.
{% endhint %}

Done! Your source Plug is ready, and GearPlug will save all new records after this one. You may now set up your target Plugs.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.gearplug.io/english/set-up-your-integrations/google-spread-sheets/source-actions/get-data-from-a-row.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.
