The scenario serves products to the site, runs payments through a payment service and keeps the books: orders, payments and refunds land in Google Sheets by themselves.
Payments on your site without your own software
Orders and payments into Google Sheets by themselves