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