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.
Basic setup
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.
Export Data
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
Note!
-
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:
Versión anterior:
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:
C#: https://github.com/octopus-dev/ApiSamples/tree/master/Code/CSharp
Python: https://github.com/octopus-dev/ApiSamples/tree/master/Code/Python
De: http://www.octoparse.es/tutorial-7/como-extraer-datos-a-google-sheet
Comentarios
0 comentarios
Inicie sesión para dejar un comentario.