The processing (or calculations) I need to perform are currently done in a Google Sheet. The calculations in the sheet are straightforward but have about 20 steps, and the final result is a string (an array) in a cell in the Google Sheet. I want that result in a cell back in AirTable.
I am sure there’s a way to write a custom script with Javascript in an Automation and write result to the cell. I’ve started, but I’m not strong with JS. I would like to explore other more low/nocode ways do these calculations. I imagine there exists some other low/nocode SaaS tool that you can build a little black-box app with build business logic and calculations and spit out a result.
In summary, here’s what I’m currently doing that I need to automate without Google Sheets:
- Row in AirTable has 5 values.
- I manually copy those 5 values into a Google Sheet, which does a bunch of calculations, involving creating a 12-period time series with about 20 rows of partial calculations, ultimately collecting the final row of 12 values into a cell as a text string, formatted like an array
- Paste that string back into AirTable
Any apps or integrations that I can perform what I’m doing currently in Google Sheets in an automated fashion that doesn’t involve writing a bunch of code? After all, I could create the output desired in a Sheet… seems there ought to be some other tool to swap in for Google Sheets.
Thanks for any thoughts/ideas!
