Call Trends API from Excel VBA with WinHttp

A VBA job talks to Trends API with one POST to https://api.trendsapi.ai/api, a Bearer key, and a JSON body that names a mode. There is no official VBA add-in. WinHttp sends the request. VBA-JSON parses the envelope, then parses the body string a second time. Pulled on 2026-09-27, Google Search for vba scored 31.0 for the week of 2026-09-26, down 3.12% from 32.0. excel vba scored 29.0, down 9.38% from 32.0. visual basic scored 36.0, up 5.88% from 34.0. vba 12M was 31.0 versus 43.0, down 27.91%. YTD was 31.0 versus 24.0, up 29.17%. Do not copy 29.0 onto 31.0. Do not treat vba 7 Search 11.0, up 22.22% from 9.0, as the language token. The same helper that stores those rows also pulls a live Google Trends board; a rank-13 token that weekly Search printed at 100.0 versus 10.0 is documented in Tucker Wetmore live rank versus weekly Search.

How does a VBA client call Trends API?

POST https://api.trendsapi.ai/api
Authorization: Bearer <api_key>
Content-Type: application/json

{"mode":"get_growth","source":"google search","keyword":"vba","percent_growth":["7D","30D","3M","12M"]}

' Requires VBA-JSON (JsonConverter) imported into the workbook
Dim http As Object
Dim payload As String
Dim envelope As Object
Dim inner As Object

payload = "{""mode"":""get_growth"",""source"":""google search"",""keyword"":""vba"",""percent_growth"":[""7D"",""30D"",""3M"",""12M""]}"

Set http = CreateObject("WinHttp.WinHttpRequest.5.1")
http.Open "POST", "https://api.trendsapi.ai/api", False
http.SetRequestHeader "Authorization", "Bearer " & Environ("TRENDSAPI_API_KEY")
http.SetRequestHeader "Content-Type", "application/json"
http.Send payload

Set envelope = JsonConverter.ParseJson(http.responseText)
' body is a JSON string; parse it a second time
Set inner = JsonConverter.ParseJson(envelope("body"))

VBA has no HTTP client in the standard library. WinHttp and VBA-JSON are the pieces this helper uses. Module docs live at:

https://learn.microsoft.com/office/vba/language/reference/user-interface-help/createobject-function
https://github.com/VBA-tools/VBA-JSON

The response envelope is {"statusCode": int, "body": string}. body is a JSON string and must be parsed a second time before reading recent_value. A PowerShell client that does the same double parse is on PowerShell Trends API. A Python client is on Python Trends API.

What did get_growth return for VBA language tokens?

get_growth for vba on google search tips on 2026-09-26. Store the exact strings. The language token, the Excel phrase, the language name, the version token, and the macros token are different series.

get_time_series for vba on Google Search closed at 31 on 2026-09-26, matching get_growth 31.0. Adjacent weeks: 32 on 2026-09-19, 38 on 2026-09-12, 39 on 2026-09-05, 34 on 2026-08-29. Peak in this pull is 100 on 2022-02-12 and 2022-02-19. The 2026 high is 86 on 2026-06-06, with 78 on 2026-05-16 and 76 on 2026-06-13. Tip 31 is a slide off that June 2026 high, not a new peak. 3M printed -54.41% versus 68.0. 30D printed -8.82% versus 34.0. 7D printed -3.12% versus 32.0. YTD printed +29.17% versus 24.0. A job that alerts on 7D -3.12% while YTD sits at +29.17% is reading a one-week dip, not a year-to-date drop.

excel vba closed at 29.0, down 9.38% from 32.0. 3M was 29.0 versus 77.0 (-62.34%). YTD was 29.0 versus 24.0 (+20.83%). The Excel phrase and the language token share a YTD sign and split on 7D magnitude. Do not copy 29.0 onto vba 31.0. visual basic closed at 36.0, up 5.88% from 34.0. 7D signs diverge: visual basic +5.88% versus vba -3.12%. 30D signs also diverge: visual basic +20.0% versus vba -8.82%. vba 7 closed at 11.0, up 22.22% from 9.0. 14D was 11.0 versus 29.0 (-62.07%). 3M was 11.0 versus 67.0 (-83.58%). Do not alert VBA adoption off a version 7D move. macros closed at 73.0, down 10.98% from 82.0. 12M was 73.0 versus 61.0 (+19.67%). That token is a diet-and-Excel collision, not a language series.

Neighbors this session: powershell Search 53.0, up 3.92% from 51.0, 12M 53.0 versus 71.0 (-25.35%), YTD 53.0 versus 33.0 (+60.61%). python programming Search 26.0, down 44.68% from 47.0, 12M 26.0 versus 24.0 (+8.33%). lua programming Search 35.0, down 5.41% from 37.0, 12M 35.0 versus 67.0 (-47.76%). A LuaSocket helper for that phrase is on Lua Trends API. There is no VBA package registry. macros Search 73.0 is still a Search series, not gallery volume.

How do YouTube, News, and Wikipedia disagree with Search?

YouTube get_growth for vba closed at 39.0 versus 33.0 (+18.18%). get_time_series closed at 39, matching growth. Adjacent weeks: 33 on 2026-09-19, 36 on 2026-09-12, 32 on 2026-09-05, 32 on 2026-08-29. Peak in this pull is 100 on 2021-10-09. The 2026 high is 48 on 2026-06-27. 7D signs diverge: YouTube +18.18% versus Search -3.12%. 12M YouTube was 39.0 versus 38.0 (+2.63%) while Search 12M was -27.91%. YTD YouTube was 39.0 versus 30.0 (+30.0%), close to Search YTD +29.17%.

Google News for vba closed at 15.0 versus 17.0 (-11.76%). The payload marked data_quality low. 14D printed growth 999999 versus 0.0. Report 15.0 versus 0.0. 30D was 15.0 versus 36.0 (-58.33%). 3M, 12M, and YTD also printed 999999 versus 0.0. Keyword News and the Google News Top News board are different feeds. Source docs for Search sit at Google Trends.

Wikipedia get_growth for Visual Basic for Applications resolved to Visual basic for applications. August 2026 scored 6.4 with 20 pageviews versus July 8.5 with 26 pageviews. 12M was 6.4 / 20 versus August 2025 4.6 / 15, volume +33.33%. Peak in this pull is 100.0 / 284 in May 2022. Twenty August views is not the high-traffic language article. Compare Wikipedia on volume. Do not join 20 pageviews onto Search 31.0. Source docs for Wikipedia sit at Wikipedia Trends.

How does a VBA job pull a live board?

POST https://api.trendsapi.ai/api
Authorization: Bearer <api_key>
Content-Type: application/json

{"mode":"get_top_trends","type":"Google Trends","limit":25}

payload = "{""mode"":""get_top_trends"",""type"":""Google Trends"",""limit"":25}"
http.Open "POST", "https://api.trendsapi.ai/api", False
http.SetRequestHeader "Authorization", "Bearer " & Environ("TRENDSAPI_API_KEY")
http.SetRequestHeader "Content-Type", "application/json"
http.Send payload
Set envelope = JsonConverter.ParseJson(http.responseText)
Set inner = JsonConverter.ParseJson(envelope("body"))

get_top_trends takes a feed type, not a keyword. Pair the live snapshot with sort=rank_change on 1d and 7d. On 2026-09-27T10:01:33Z the live Google Trends board ranked tucker wetmore at 13. Weekly Search for that string closed at 100.0 versus 10.0. A workbook that only stores 7D Search for vba at 31.0 misses that board. Mode docs live at Docs.

What belongs in a VBA watchlist?

Store vba, excel vba, visual basic, vba 7, and macros as separate Search series. Add YouTube vba because 7D signs already disagree. Add Wikipedia volume for the resolved title, not the 0-100 score. Skip a VBA package registry column: that source does not exist. Six Search keywords plus one live Google Trends board is 7 calls. Four weekly runs fit the free 100-request cap. Starter is 5,000, Pro 25,000, Business 100,000. Only successful 200 responses count.