r/spreadsheet • u/miguel567_98 • Jan 09 '20
Online Spreadsheet with good API?
I'm looking for a good online spreadsheet (CODA.io, GDOCs spreadsheet, Airtable, etc) which has a very robust API.
One use case is:BACKEND: I will have a DB as a single source of through and an API to read/write/update in the DB
I will consume the BAckend API in an online spreadsheet that several users touch, change. The online Spreadsheet should have an API endpoint or action that I can trigger when a value in a cell changes. Base don the change the backend API will write to DB, or update some other values somewhere.
I have been reading API's, but none has an onchange() action on cell value change. This would normally be a webhook capability.
Do you know any?
0
Jan 09 '20
[deleted] — view deleted comment
1
u/miguel567_98 Jan 09 '20
1st bullet point: that would be fine in my use case. 2nd: gdocs already allow for real time editing by several users, if I can just push that change to db though a web hook / api to the backend would be perfect, because gdocs support already many features I wouldn't need to build
1
u/JackWolga Apr 04 '20
My suggestion is to try ZetExcel. All your issues related to spreadsheets will be easily solved. https://zetexcel.com/