With the latest version of Octoparse (version 8.5.8 or above), 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 Cloud and 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 Manually

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.

Note: The Private key should include the "-----BEGIN PRIVATE KEY-----" and

"\n-----END PRIVATE KEY-----\n"

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.

Export Cloud Data Automatically

With Octoparse version 8.6 or above, we can export the Cloud data to Google Sheets automatically.

Click on Task Settings -> Automation -> Export to database -> Edit

Input a name in the Automation Schedule as the name for this auto-export project
Input your Google Sheets information. You can input a name into the Configuration Name to save your Google Sheets information for later usage.
Check Basic Setup to get your Google Sheets information.

Set up export intervals as needed
Click on Test Connection to see if the connection works
Click on Confirm to save the settings

After the setup, the Auto-export tool will pop up with the Auto-export task enabled.

Note:

Starting from version 8.6.8, Auto-export to Google Sheets does not require the scheduler tool to be opened. You can close your device and enjoy seamless exports. (Exporting to MySQL or SQL databases still require the scheduler to be opened.)