I was dabbling with the GPT for Sheets extension in GS and thought I’d try it out on a problem I’d posted about a few weeks ago (Transform JSON with JQ). I needed to parse out just the amount and description from a block of json code.
In the screenshot below, the json code—which is dynamic content pulled in through an API— is in the column on the right. The middle column is the GPT prompt I provided and the left column is the resulting markdown text. The next screenshot is the table as it appears in the app. Not perfect but the potential is pretty mind-blowing.
