Welcome to the community Martin.
We have a REST API in the near term roadmap that will let you manipulate data in your workbooks. Checkout this
More information on your scenario and a typical use case that you would want to automate will help us design the API better. Let us know.