Welcome @Tania!
@Symbioquine’s overview is great - start by thinking through that! 
If you go the inventory route, I wanted to mention that Inventory Quick Form, which is configurable so you can make some standardized instances of that for different purposes. More info here:
https://farmos.org/blog/2024/inventory-quick-form/
Here are some thoughts…
A CSV importer (either using the default asset/log importers or making a single custom one) might be an easy/fast way to get plant assets (and their location) into the system on an ongoing basis.
These could be input logs, perhaps. And if they are moving to a new location the input logs can also be “movements” (Movements and location | farmOS).
Sale logs are provided by the farmOS Ledger module (add-on): https://www.drupal.org/project/farm_ledger
Observation logs (which may also be inventory adjustments) would probably be my suggestion.
Never heard of Looker Studio, but here is an example of connecting Google Sheets to the farmOS API by @ktohalloran: Google Apps Script proof-of-concept for connecting farmOS API to Google Sheets
farmOS v4 has just been released. v2 is no longer supported so I would recommend getting updated to v3 and then to v4 as soon as you can! Especially if you want that Inventory Quick Form I described above… 