Google Sheets Add-On

Use this method to install the add-on directly from Google Sheets in a few clicks.

Step 1 — Open the Add-ons Marketplace

1. Open a Google Sheets spreadsheet.
2. Go to Extensions → Add-ons → Get add-ons.

3. In the Google Workspace Marketplace, search for Trading Economics.
4. Click Install on TRADING ECONOMICS Sheets Add-on.

Step 2 — Sign In Popup

A Google popup will appear asking you to sign in to the TRADING ECONOMICS Sheets Add-on.

1. Click Continue.

Step 3 — Grant Permissions

In the next Google popup, grant the required access permissions.

1. Click Select all.
2. Click Continue.

Step 4 — Open the Add-On

After the permissions are accepted:

1. Go to Extensions.
2. Click TRADING ECONOMICS Sheets Addon to access indicators, calendar, markets, and settings.

3. Click Settings and enter your Trading Economics API key to start fetching data.

Use this method if you want to install the add-on by pasting the project files directly into Apps Script.

Step 1 — Open the Apps Script Editor

1. Open your Google Sheets spreadsheet.
2. In the menu bar, go to Extensions → Apps Script.

The Apps Script editor will open in a new browser tab.

Step 2 — Add the Script Code

1. In the Apps Script editor, click on the default Code.gs file in the left panel.
2. Delete all existing content in the editor.
3. Copy the full contents of Code.gs and paste it into the editor.
4. Press Ctrl + S (or Cmd + S on Mac) to save.

Step 3 — Configure the Manifest

The appsscript.json manifest declares the OAuth permissions the add-on needs to communicate with Google Sheets and the Trading Economics API.

1. In the Apps Script editor, click Project Settings (the gear icon in the left panel).
2. Check the box labelled “Show ‘appsscript.json’ manifest file in editor”.
3. Go back to the Editor view — appsscript.json will now appear in the file list.
4. Click on appsscript.json, delete all existing content, and paste in the following:

{
  "timeZone": "Etc/UTC",
  "dependencies": {},
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8",
  "oauthScopes": [
    "https://www.googleapis.com/auth/script.storage",
    "https://www.googleapis.com/auth/spreadsheets",
    "https://www.googleapis.com/auth/script.container.ui",
    "https://www.googleapis.com/auth/script.external_request"
  ]
}

5. Press Ctrl + S (or Cmd + S on Mac) to save.

Step 4 — Add the Sidebar HTML File

1. In the Apps Script editor, click the + icon next to Files in the left panel and choose HTML.

2. Name the new file exactly Sidebar (the editor will append .html automatically).
3. Delete all existing content in the new file.
4. Copy the full contents of Sidebar.html and paste it into the editor.
5. Press Ctrl + S (or Cmd + S on Mac) to save.

Step 5 — Activate the Add-On

1. Go back to your Google Sheets spreadsheet and refresh the page.
2. After a few seconds, a new TE menu will appear in the menu bar.
3. Click TE → Settings and enter your Trading Economics API key to start fetching data.

Ensure your spreadsheet has enough rows (10,000+) before making a request.

• If you need more rows, scroll to the bottom and click “Add” to add more rows.

1 - The first time you use the Add-On, a warning might appear stating “This app isn’t verified.”

• Click on “Advanced”
• Click on “Go to (project name) (unsafe)” to continue using our Add-On.

This warning appears because the script runs under your own Google account. The code is fully open source and visible in the repository.