With the latest 8.5.8 update, you can now export data directly to Google Sheets rather than doing it via any third-party services or Octoparse OpenAPI.
To enable data export to Google Sheets in Octoparse, users must finish some preparatory work in their Google account first.
Step 1: Create a new project in Google Cloud Console
Go to Google Cloudand create a new project for Google Sheets.
Click Select a project (or an existing project's name if you have other projects) and select NEW PROJECT from the popup window.
Name the project and click CREATE to continue
Step 2: Enable Google Sheets API from API Library
Select ENABLE to finish the step.
Step 3: Create a service account in Google Cloud and download the .json file
Go to Service Accounts in the IAM&Admin settings and click +CREATE SERVICE ACCOUNT
Enter a Service account ID and click DONE to finish the setup. All the Other settings are optional.
You will find an email address appearing under your current project, that's your Client Email. Click on it to go to check the details.
After you open the details page, switch to KEYS and click ADD KEY.
Click Create new key
Click CREATE to generate a JSON file and download it to your device.
You will find a .json file downloaded to your device. Service account keys could pose a security risk if compromised. Please keep them in a safe place on your local device.
Step 4: Grant Google Sheets access to the Service Account
Go to the target Google Sheets and share it with your Service Account mail by adding it as an Editor.
Congratulations! You've finished all of the preparation work on the Google Account side.
When a user tries to export data from Octoparse, they will notice a new option is now available for both local and cloud data exports.
Export Local data
Export cloud data
You will be prompted with a final setup window for this feature.
Enter the target Google Sheets URL and type in the Client Email and Private Key found in the .json file we downloaded earlier. You can test the setup by clicking Test Connection.
Select a spread and click Export to export the data
Please make sure the spreadsheet has enough columns to host the data if you have added many data fields in your Octoparse task.
Only manual data export to Google Sheets is supported for now. To automatically export data to Google Sheets, please refer to the tutorial below:
Octoparse actualmente admite la extracción de datos a CSV, Excel, HTML y base de datos. La extracción de datos a la hoja de Google solo se puede hacer a través de API.
Consulte nuestra documentación de la API: http://dataapi.octoparse.com/help
Se pueden encontrar códigos de muestra para API en Github: