I'd really love an API. I can do many of these features in Google Sheets already. While their UI/UX is far behind Saturation, their scripting engine and API make it possible to pipe this data around our company where we need it. Please implement an API so that this can be hooked into from external automation engines like Pipedream or Zapier.
