# Oracle Spreadsheet Management and Creation

To set up your Spreadsheet for Scry Node, simply copy this template or use as a guide for how to structure your sheet.\
\
**Creation**

1. Go to \
   [https://docs.google.com/spreadsheets/d/1syqS8Gpl7ZS9UC\_Wr6giY057XebJu3bZKXhIDsN-DJ0/](https://docs.google.com/spreadsheets/d/1syqS8Gpl7ZS9UC_Wr6giY057XebJu3bZKXhIDsN-DJ0/edit#gid=0)\
   Copy this template or use as a guide for how to structure your sheet. \
   \
   **Feed Name**\
   The name for the feed, used as general info\
   **ETH/USD**\
   \
   **Feed ID**\
   The ID for the feed in the oracle\
   **0**\
   \
   **API Endpoint**\
   The API Endpoint to source data from. This can be any API\
   <https://api.coingecko.com/api/v3/simple/price?ids=ethereum&vs_currencies=usd>\
   \
   \
   **Update Frequency (s)**\
   How often you want the feed to be updated with fresh data, also determines how often to map slots for historical lookup\
   **3600**\
   \
   **Decimals**\
   How many dec for the data to be stored in, recommended the raw base amount for Crypto assets, such as 10\*\*18 for ETH values.\
   **18**\
   \
   **Parser**\
   The JSON path to walk down for the value to return\
   For an API request to Coingecko like\
   <https://api.coingecko.com/api/v3/simple/price?ids=ethereum&vs_currencies=usd>\
   which returns<br>

   ```
   {"ethereum":{"usd":1609.34}}
   ```

&#x20;       The path would be\
&#x20;       **ethereum,usd**

&#x20;       **Description**\
&#x20;       The Description for the feed

2\. Follow <https://support.google.com/googleapi/answer/6158862?hl=en> to acquire your API key

3\. You can now access the needed info from your oracle with the following values\
**SHEETID=** URLID - **1syqS8Gpl7ZS9UC\_Wr6giY057XebJu3bZKXhIDsN-DJ0**\
**SHEETTITLE=** The TITLE for the specific sheet - **Polygon**\
**SHEETAPI=**&#x41;PI KEY

<figure><img src="/files/9ujecmOzzjg1oLFNJcU9" alt=""><figcaption></figcaption></figure>

**New Feeds**\
1\. Simply put new Feeds into the sheet with ID and needed info for the APIs, run setup.js and then restart your node.


---

# 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.scry.finance/docs/open-oracle-framework/oracle-spreadsheet-management-and-creation.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.