I’m new to Bubble so still learning a great deal. This may be a simple one to answer.
I’d like to utilise user inputs to run some complex calculations in an Excel spreadsheet (utilising multiple tables, vlookups, other calcs etc) and then return an output from that spreadsheet to Bubble.
I understand there are various Google Sheets APIs, Handsontable and the Airtable API but not sure if this will do what I need. I’m quite advanced at using Excel so would prefer to upload my own spreadsheet to Bubble and then reference that directly in the app.
Ideally I want to avoid using third party software to mimic my spreadsheet.
So something like this setup;
- User inputs XXX in Bubble and clicks a button
- Workflow triggered to input XXX into my spreadsheet
- The spreadsheet does all the complex calcs and updates cell A1 with the output value
- Cell A1 is referenced from the spreadsheet into Bubble to display the output value from the calcs done