27 ms·

Spreadsheet with compute-like functions: GET(), POST(), PARSE(), ASK_OpenAI()

95 points by luisb 4y ago

akickinthestone 4y ago
Has anyone tried asking open.ai for spreadsheet formulas?
- patife 4y ago
  Yes ASK_OPENAI(“write a spreadsheet formula that averages values in column A if column C equals Facebook”) That worked for me!
- iinnPP 4y ago
  I did but it didn't like spitting out just the formula, it had to explain it even when explicitly asked.
- krimpenrik 4y ago
  Works beautifully for what i needed. Also domain specific Salesforce formulas. Makes my life 100 times easier. I'll become paying user for this alone.
ent101 4y ago
aside from the tech, I also really like the examples (e.g. cleaning addresses), they are practical uses of GPT. Gave me some ideas too!
choraria 4y ago
When are webhooks going to be released? Webhooks inside a spreadsheet would be :fire: (looks like emojis don't work on HN, SMH).
- ent101 4y ago
  also subscription via websockets! it’s an interesting new trend.
- deleted 4y ago
  [deleted]
- deleted 4y ago
  [deleted]
- xnx 4y ago
  There's an add-on for Google Sheets that does this: https://workspace.google.com/marketplace/app/webhooks_for_sheets/860288437469 https://workspace.google.com/marketplace/app/webhooks_for_sh...
  - danielvaughn 4y ago
    lol this is _dangerous_ I know what I’m going to be playing around with this weekend :p
gr 4y ago
I use this, Rows.com is very cool stuff. Not (yet) a full replacement for G Sheets but 10x better for widgets and interactive tables and reports. And the built in forms are excellent!
- gr 4y ago
  ... :chef: :kiss: No emojis ;-[
  - deleted 4y ago
    [deleted]
- culi 4y ago
  Seems like they have sort of a Notion-like approach to spreadsheets I agree it's pretty cool. What I'd really love to see though is something like Jupyter Notebooks + Spreadsheets. If blocks of code and blocks of spreadsheets could talk to each other, it'd definitely be a killer feature for me
  - mediaman 4y ago
    I'm not sure if this is what you're looking for, but Grist has relationship-driven spreadsheets where the formulas are all Python code. And you can have multiple tables show on the same page, where selection of one filters the others. The tables are more database-style than pure unstructured Excel sheet style, but I've found that having a full Python environment in each cell to be pretty powerful, and I've started turning to it for analytical work because I can avoid the mess that larger Excel formulas can turn into. No relationship except as a customer -- they're at getgrist.com
    - patife 4y ago
      Looks cool too! Python!!
    - dsagal 4y ago
      Ooh, excited to see mention of Grist (I am a cofounder). Python code and structured data are a great combination, and are particularly good for AI. We did an experiment where AI was quite impressive in writing Python formulas in Grist based on simple prompts: https://news.ycombinator.com/item?id=33809111 https://news.ycombinator.com/item?id=33809111 I suppose it's similar to rows.com's ASK_OPENAI("write a spreadsheet formula that..."). Most impressive is that it knows relationships between tables, and can construct correct lookup formulas, and do useful things with their results.
dang 4y ago
Related: Rows.com – Spreadsheet that supports external API integration and collaboration - https://news.ycombinator.com/item?id=29171490 https://news.ycombinator.com/item?id=29171490 - Nov 2021 (75 comments)
oi_ocha_please 4y ago
really cool! fyi, i'm having trouble clicking on certain cells in the demo.
- deleted 4y ago
  [deleted]
- patife 4y ago
  which cells? example?

95 points by luisb 4y ago

akickinthestone 4y ago

Has anyone tried asking open.ai for spreadsheet formulas?

patife 4y ago
Yes ASK_OPENAI(“write a spreadsheet formula that averages values in column A if column C equals Facebook”) That worked for me!
iinnPP 4y ago
I did but it didn't like spitting out just the formula, it had to explain it even when explicitly asked.
krimpenrik 4y ago
Works beautifully for what i needed. Also domain specific Salesforce formulas. Makes my life 100 times easier. I'll become paying user for this alone.

ent101 4y ago

aside from the tech, I also really like the examples (e.g. cleaning addresses), they are practical uses of GPT. Gave me some ideas too!

choraria 4y ago

When are webhooks going to be released? Webhooks inside a spreadsheet would be :fire: (looks like emojis don't work on HN, SMH).

ent101 4y ago
also subscription via websockets! it’s an interesting new trend.
deleted 4y ago
[deleted]
deleted 4y ago
[deleted]
xnx 4y ago
There's an add-on for Google Sheets that does this: https://workspace.google.com/marketplace/app/webhooks_for_sheets/860288437469 https://workspace.google.com/marketplace/app/webhooks_for_sh...
- danielvaughn 4y ago
  lol this is _dangerous_ I know what I’m going to be playing around with this weekend :p

gr 4y ago

I use this, Rows.com is very cool stuff. Not (yet) a full replacement for G Sheets but 10x better for widgets and interactive tables and reports. And the built in forms are excellent!

gr 4y ago
... :chef: :kiss: No emojis ;-[
- deleted 4y ago
  [deleted]
culi 4y ago
Seems like they have sort of a Notion-like approach to spreadsheets I agree it's pretty cool. What I'd really love to see though is something like Jupyter Notebooks + Spreadsheets. If blocks of code and blocks of spreadsheets could talk to each other, it'd definitely be a killer feature for me
- mediaman 4y ago
  I'm not sure if this is what you're looking for, but Grist has relationship-driven spreadsheets where the formulas are all Python code. And you can have multiple tables show on the same page, where selection of one filters the others. The tables are more database-style than pure unstructured Excel sheet style, but I've found that having a full Python environment in each cell to be pretty powerful, and I've started turning to it for analytical work because I can avoid the mess that larger Excel formulas can turn into. No relationship except as a customer -- they're at getgrist.com
  - patife 4y ago
    Looks cool too! Python!!
  - dsagal 4y ago
    Ooh, excited to see mention of Grist (I am a cofounder). Python code and structured data are a great combination, and are particularly good for AI. We did an experiment where AI was quite impressive in writing Python formulas in Grist based on simple prompts: https://news.ycombinator.com/item?id=33809111 https://news.ycombinator.com/item?id=33809111 I suppose it's similar to rows.com's ASK_OPENAI("write a spreadsheet formula that..."). Most impressive is that it knows relationships between tables, and can construct correct lookup formulas, and do useful things with their results.

dang 4y ago

Related: Rows.com – Spreadsheet that supports external API integration and collaboration - https://news.ycombinator.com/item?id=29171490 https://news.ycombinator.com/item?id=29171490 - Nov 2021 (75 comments)

oi_ocha_please 4y ago

really cool! fyi, i'm having trouble clicking on certain cells in the demo.

deleted 4y ago
[deleted]
patife 4y ago
which cells? example?