This tutorial video will show you how to create a custom WooCommerce sales report and send it to Google Sheets using WP All Export and Zapier. You can read more about WP All Export here:
http://wpallimport.com/export/Creating a customized WooCommerce order report is fast and easy. First, you'll use WP All Export to export the exact order data you want to include in your report. Next, we need to send the data to Google Sheets. To do that you'll go to Zapier and create a Zap. A Zap is a blueprint for a task you want to do over and over. In our case that would be "every time I run an export add the data to a spreadsheet in Google Sheets." Once set up it'll do just that - run your export and the data will be sent to Google Sheets.
Many people find this useful when combined with scheduled exports. Once your export is configured and linked to Google Sheets via Zapier, you can set the export to run automatically every day, week, or month. For example, you can set up a weekly sales report that will show how many products were ordered over the last week. Every week the spreadsheet will update with new sales data, along with all of the graphs and charts you have in Google Sheets to visualize the data.