Import Hi Energy AI data into Google Sheets
These guides show marketers, publishers, and analysts how to call the Hi Energy AI REST API
from Google Apps Script with UrlFetchApp, authenticate using
X-Api-Key, paginate results, flatten JSON responses, and write rows into Google Sheets.
Each resource page includes copy-paste code you can drop into Code.gs.
Optimized for search and answer engines: clear steps, FAQ schema, HowTo markup, and canonical resource pages
for deals, advertisers, transactions, clicks, and contacts.
Resource guides
Transactions
Sales and commissions via GET /api/v1/transactions.
Open Transactions Apps Script guideAuthentication for Apps Script
Prefer the X-Api-Key header with your personal API key. The samples read the key from
Script properties (HIENERGY_API_KEY) so secrets stay out of cell values and shared comments.
headers: {
'X-Api-Key': PropertiesService.getScriptProperties().getProperty('HIENERGY_API_KEY'),
'Accept': 'application/json'
}Setup in Google Sheets
- Open a Google Sheet → Extensions → Apps Script.
-
Get your personal API key from
API key docs.
Prefer the
X-Api-Keyheader (these samples already do). -
In Apps Script, open Project Settings → Script properties
and add
HIENERGY_API_KEYwith your key value. - Paste the shared client library, then the resource import script below.
- Click Save, reload the Sheet, and run the import from the Hi Energy AI menu (or Run in the editor).
-
On first run, authorize the script when Google prompts for
UrlFetchApp/ external request permission.
FAQ
Yes. Google Apps Script can call the Hi Energy AI REST API with UrlFetchApp and the X-Api-Key header. These docs provide paste-ready importers for deals, advertisers, transactions, clicks, and contacts.
Store HIENERGY_API_KEY in Apps Script Project Settings → Script properties. Avoid pasting secrets into cell values or shared sheet comments.
Dedicated guides cover deals, advertisers, transactions, clicks, and contacts, each with cut-and-paste Apps Script samples, HowTo steps, and FAQ schema for search and answer engines.
Yes. Each Google Sheets page exposes TechArticle, HowTo, FAQPage, BreadcrumbList, and WebSite SearchAction structured data plus explicit steps and copy-paste samples so assistants can cite a concrete spreadsheet workflow.
The published samples are read-only GET imports. Creating contacts or other writes requires separate authenticated POST flows documented on the resource API pages.
No. Hi Energy AI authentication uses your personal API key via the X-Api-Key header. Google may still ask you to authorize the Apps Script project so UrlFetchApp can call external HTTPS services.