The Scenario
You're a productivity coach. You've been using Exist yourself for six months, and you've started recommending it to clients. Now one of them wants to understand their data — not just read the Exist dashboard, but see a structured summary they can share with you during sessions.
You want to pull all discovered correlations out of Exist and into a Google Sheet: attribute A, attribute B, correlation coefficient, p-value, and the human-readable description. One row per correlation. Something you can filter, sort, and paste into a client document.
Except you've never touched the Exist API, and the idea of reading API documentation to pull a JSON array into a sheet sounds like an afternoon you don't have.
The bad version:
- Find the Exist correlations endpoint in the developer docs, get an API token, run the request in a browser or Postman, and stare at the nested JSON response
- Copy the relevant fields from each correlation object by hand into a spreadsheet row — attribute_a, attribute_b, correlation, p_value, description — for each of the 30+ correlations Exist has discovered
- Realize the p-value is expressed as a float and you want it formatted as a percentage, so go back and reformat the entire column
You have a client call in two hours. Spending 90 minutes on data extraction isn't in the agenda.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the context, connects to Exist through its built-in integration, and writes the correlation data straight into your cells.
Fetch all current correlations from Exist and write attribute A, attribute B, correlation coefficient, p-value, and the human-readable description into my Google Sheet starting at A1, with headers in row 1
What You Get
- Row 1: headers — Attribute A, Attribute B, Correlation, P-Value, Description
- One row per discovered correlation
- Correlation coefficient as a decimal (e.g., 0.72)
- P-value as a decimal, formatted to 4 places
- Description field from Exist's own language (e.g., "On days when you sleep more, your mood tends to be higher")
What If the Data Is Not Quite Ready
You want to filter to only statistically significant results
Fetch all Exist correlations and write them into my Google Sheet, but only include rows where the p-value is below 0.05, and sort by correlation coefficient descending
The description text is too long and you want a truncated version
Pull all my Exist correlations into my Google Sheet with attribute A, attribute B, correlation coefficient, and a shortened description — no more than 80 characters per description
You want strength labels instead of raw coefficients
Fetch all my Exist correlations and write them into my Google Sheet with columns for both attribute names, the correlation coefficient, and a label — "strong" for |r| > 0.7, "moderate" for |r| > 0.4, "weak" otherwise
The full correlation pull plus a summary pivot in one shot
Pull all my Exist correlations into Sheet1 with all fields, then in Sheet2 create a pivot showing each attribute and how many significant correlations it appears in, sorted by count descending
One prompt. Two outputs. You walk into the client call with the full table and the summary already built.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet you're using for personal data review, then ask it to export your Exist correlation table. For the raw underlying data, see the spoke on exporting attribute values, or return to the Exist integration hub for the full picture.