The Scenario
You are a VC analyst. The investment team just finished sourcing sprint and has 60 public company tickers in a Google Sheet. The lead partner wants a competitive landscape report by Friday at 5 PM with full company profiles: CIK, ISIN, CEO name, market cap, sector, exchange, and the latest EPS actual versus estimated for each.
You have the tickers in column A. Nothing else. Five days, sixty rows, seven data points per row.
The bad version of this week:
- You open the SEC EDGAR site, look up CIK for the first ticker, copy it into column B
- You switch to a financial data site for the ISIN, find it buried in the security details page
- You search for the CEO name, find three different spellings across three sources, pick the one that matches the most recent proxy filing
- By Wednesday afternoon you have done eleven companies
- You copy the remaining 49 rows to a junior analyst and ask them to finish by Thursday
- Friday morning they send you a sheet where "sector" is filled with whatever showed up first in a Google search.
The precise version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet. It reads your ticker list and calls the API Ninjas company profile and earnings endpoints for each row, writing a complete data set without you touching a browser.
Open the SheetXAI sidebar and type:
For each ticker in column A, fetch the full company profile from API Ninjas — including CEO, sector, market cap, and exchange — and fill columns B through F. Then look up the latest earnings report data (EPS actual vs estimated, revenue actual vs estimated) for every ticker and add it in columns G through J.
SheetXAI calls the profile endpoint for each ticker, then the earnings endpoint, and writes seven columns of structured data per row.
What You Get
A complete competitive landscape dataset:
- Column B: CEO name — from the API Ninjas company profile
- Column C: Sector — standardized sector label
- Column D: Market cap — in USD
- Column E: Exchange — NYSE, NASDAQ, etc.
- Column F: CIK or ISIN — as returned by API Ninjas
- Column G: EPS actual — latest reported
- Column H: EPS estimated — analyst consensus
- Column I: Revenue actual — latest reported
- Column J: Revenue estimated — analyst consensus
You did not open a single browser tab. Sixty rows, seven fields each, one prompt.
What If the Data Is Not Quite Ready
Competitive landscape sheets accumulate nuance. SheetXAI handles it inline.
When some tickers are international and use a different format
Your sourcing sprint included a few London-listed and Tokyo-listed companies with different ticker formats.
For tickers in column A ending in ".L" (London) or ".T" (Tokyo), use the appropriate exchange format when calling API Ninjas. Fetch profile and earnings data as normal and note the exchange in column E.
When you want to rank by market cap and flag top performers
The lead partner wants the top 10 by market cap highlighted before the report goes out.
After filling all profile data, sort the sheet by market cap in column D descending. Highlight the top 10 rows in the sheet green. Add a "Rank" column at the beginning numbered 1 through 60.
When the EPS beat/miss picture matters more than raw numbers
You want a simple beat-or-miss flag instead of four separate numbers.
For each ticker, compare EPS actual (column G) to EPS estimated (column H). Write "BEAT" in column K if actual exceeds estimated, "MISS" if it falls short, and "IN LINE" if within 2%. Do the same for revenue in column L.
When the full landscape build is one prompt
Sixty tickers, full profile, earnings data, beat/miss flags, sorted by market cap, ready for the Friday report.
For each ticker in column A, fetch the full company profile from API Ninjas (CEO, sector, market cap, exchange) and fill columns B–E. Fetch latest EPS actual, EPS estimated, revenue actual, and revenue estimated and fill columns F–I. Compare EPS actual vs estimated: write "BEAT," "MISS," or "IN LINE" into column J. Sort the sheet by market cap descending. Highlight the top 10 rows green. Write "Top 10" in column K for those rows.
The pattern: profile data, earnings data, derived flags, and sorting all in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open any ticker list, then ask SheetXAI to enrich it with company profiles and earnings data using API Ninjas. The API Ninjas integration is included in every SheetXAI plan. See also how to bulk-enrich a ticker list with live price and EPS or the API Ninjas in Google Sheets overview.