Bot to transfer data from Woocommerce to 2 google tables

Write a script to transfer data from Woocommerce to Google tables in accordance with product data.
There is an algorithm for attributing the goods ordered by the buyer (depends on the quantity, name, supplier) in the Google table.
There are 2 suppliers = 2 google tables, attribute products to these tables, and the 3rd case when the product does not fall under the criteria for attribution to these tables, attribute this order to a selected column in google table. It is necessary to prescribe this in code.TK to the executor

Date: 05.12.202