> For the complete documentation index, see [llms.txt](https://docs.trysavvy.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.trysavvy.com/other-useful-docs/work-in-progress/pending/work-in-progress-how-to-bring-data-from-google-sheet.md).

# Work in Progress: How to Bring Data from Google Sheet

{% hint style="info" %}
The best way for us to make use of big chunks of information on the flow is in the form of a JSON Object. Google Sheet doesn't do that on its own, so we recommend going through an API called "Sheety".
{% endhint %}

### Step 1: Prepare your Google Sheet 

**Make the first row of your spreadsheet the header:** The first row of your sheet will be used as the header. This is the most important part of preparing your sheet, as the names you use here will be used as the property names in the returned objects. Each column in your sheet represents that property’s value.

{% hint style="info" %}
For more info on how it works click [here](https://sheety.co/docs/spreadsheet.html)
{% endhint %}

### Step 2: Get your Sheety Code

* Go to [sheety.co](https://sheety.co/) 
* Click on "Connect Google Sheet"
* Sign in with your Google Account
* Create a New Project "From Google Sheet"
* Paste the URL of your Google Sheet
* Click on "Create Project"
* Copy the example code, it should look something like this:

![](/files/SibeQebHFgRhnFLqscMO)

{% hint style="info" %}
Make sure to return your fetch. Even though the code that Sheety gives you looks like the above, it should actually say "return fetch(url)" and it should look like the last image on this page.
{% endhint %}

### Step 3: Create a Computed Field

* Go to the "All" Tab of the Left Sidebar
* Scroll down to the Computed Fields section and create a new one 
* Give it a cool, original name. Something like "google\_sheet"
* Scroll to the bottom of the Options Tab on the Right Sidebar
* Click on "Generate Sample Code", it will generate an empty function:
* Paste the code from Sheety inside the function

![](/files/9byFRRPr1NKz820PqSM9)

{% hint style="info" %}
Remember to change the code so it **returns** the JSON, or the part of the JSON that you need. 
{% endhint %}


---

# 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.trysavvy.com/other-useful-docs/work-in-progress/pending/work-in-progress-how-to-bring-data-from-google-sheet.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.