The Scenario
You've been tracking with Exist for eight months. Sleep, mood, steps, productive time, gym sessions, screen time — the dashboard shows you the correlations, but you want to run your own numbers. Not Exist's numbers. Yours.
You have a Google Sheet set up with a few chart templates waiting. All you need is the raw data in rows. And you need 90 days of it, across every attribute you track.
The bad version:
- Log into the Exist developer dashboard, find the attributes endpoint, manually construct a date range query, and copy the JSON response into a text file
- Open the text file, parse out attribute names and values by eye, and paste each attribute's values column by column into the sheet — repeating this for each of the eight attributes you track
- Discover that the date format from the API doesn't match the date format your chart formulas expect, and spend another 20 minutes reformatting column A
This is data entry work dressed up as analysis prep. You didn't start tracking your health to do data entry — and you're not going to rerun this every time you want a fresh look at the numbers.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet, talks to Exist through its built-in integration, and writes the results directly into your cells. No API setup, no JSON parsing.
Fetch all my Exist attribute values for the last 90 days and write each attribute name, date, and value as a row in my Google Sheet starting at A2
What You Get
- Column A: attribute name (e.g., "steps", "mood", "sleep")
- Column B: date in YYYY-MM-DD format
- Column C: numeric value for that day
- One row per attribute per day — 90 days × number of tracked attributes, sorted chronologically
- Any days with no data for a given attribute are omitted rather than written as blanks
What If the Data Is Not Quite Ready
The date column isn't in the format your VLOOKUP expects
Fetch all my Exist attribute values for the last 90 days and write them into my Google Sheet starting at A2 — format the date column as MM/DD/YYYY and the value column as a number rounded to 2 decimal places
You only want specific attributes, not all of them
Pull my Exist attribute values for sleep, mood, and productive_time only, for the last 90 days, and write each as a row in columns A through C of my Google Sheet
You want a wide format instead of long format — one column per attribute
Fetch my Exist attribute values for the last 90 days and write them into my Google Sheet in wide format: one row per date, one column per attribute, with the attribute names as headers in row 1
The full extraction plus a summary in one shot
Fetch all my Exist attribute values for the last 90 days, write each as a row starting at A2, then in a separate tab called "Summary" calculate the average and standard deviation for each attribute and write those next to the attribute name
The most useful prompt is the one that does the pull and the calculation together — you don't have to write the formulas yourself.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you're using for personal analytics, then ask it to pull your Exist attribute history. If you track sleep and mood, also check out the spoke on exporting your Exist correlations or the hub overview for the full Exist integration.