Octoparse currently supports the following methods to automatically export data to Google Sheets:
Via Zapier: How To Export Data to Google Sheets via Zapier
Via Octoparse OpenAPI: check the documentation and sample codes on Github
Via Mixed Analytics API Connector (Google Sheets extension tool): Exporting Data to Google Sheets with Mixed Analytics API Connector