Octoparse currently supports extracting data to CSV, Excel, HTML, and database. Extracting data to Google sheet can be done only via API only.
Check our API documentation: http://dataapi.octoparse.com/help
Sample codes for API can be found on Github:
C#: https://github.com/octopus-dev/ApiSamples/tree/master/Code/CSharp
Python: https://github.com/octopus-dev/ApiSamples/tree/master/Code/Python
Author: Erika
Editor: Isabella