Hi Topknotch
This is the only way we actually have to add/edit inventories in bulk. If you need something even more automatic, you would need custom coding.
You just have to create inventories for one of your products manually and, thereafter, you can just copy/paste the lines on Google Sheets, for your other products.
Best Regards,
Salva.