I'm prototyping an app on a platform with Gsheet as its engine. Currently, in-app purchases are possible but only for personal Stripe accounts -- no Stripe Connect integration. Making API calls from the app is not possible.
The model is one-to-many: A buyer can purchase from multiple Sellers. Every time a customer makes an in-app purchase, I need to be able to fetch that merchant’s account ID (already in the sheet) and set it as a parameter for the payment call to Stripe. In addition to the cost of the product, customer info, etc.
I'm getting up to speed on APIs but my understanding is still limited. I know that Gsheet-to-Stripe is fairly simple but I have not found a solution for the other way around.
Tips or trickery appreciated.