> For the complete documentation index, see [llms.txt](https://docs.scry.finance/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.scry.finance/docs/open-oracle-framework/oracle-spreadsheet-management-and-creation.md).

# 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.