Google Sheet Auto Sync for Octoparse Tasks

Overview

This app is designed for Octoparse users who manage their target data—such as URLs or keywords—in a shared Google Sheet. Instead of manually copying and pasting the updated values into your Octoparse task each time, this app automatically monitors the Google Sheet for new entries. When it detects updated data, it syncs the changes directly to the input parameters of your Octoparse task and runs the task automatically.

⚠️ Note: This app requires Octoparse’s API access, which is only available for Professional and Enterprise plans.

Octoparse Task Tools

Octoparse – Bulk Export Cloud Data: Export data in bulk from a specific task group in Octoparse.

Octoparse – Bulk Start Tasks: Start multiple Octoparse cloud tasks at once to save time.

Octoparse – Bulk Stop Tasks: Stop multiple running tasks with a single click for better task management.

How to Use

1. Download the app from Octoparse AI app store.

2. Launch the app in your list.

       1. Parameter Description

1. OAuth ID: Your Google OAuth Client ID used to access the Google Sheet. You can generate this in the Google Cloud Console. View setup guide
2. OAuth secret: Your Google OAuth Client Secret that matches the OAuth ID above. View setup guide
3. Google Sheet link: The link to your Google Sheet that contains the URLs or keywords to be synced.
4. Sheet name: The name of the worksheet tab to read data from. This field is case-sensitive.
5. Octoparse account: Your Octoparse login email.
6. Octoparse password: Your Octoparse login password.
7. Task ID: The ID of the Octoparse task you want to update and run.
8. Action ID: The ID of the action node within the task that accepts external parameters.
9. Parameter header: The column name in the Google Sheet that contains the data to be passed into the Octoparse task (e.g., "keyword" or "url").

       2. Click "Run application"

3. Output

The app detects updated parameters in your Google Sheet, inputs them into your Octoparse task, runs the task, and marks the entries as processed. You can export the data directly from Octoparse after the run.

Notes

• Authorize your Google Sheet before running the app. See the OAuth setup guide for instructions.
• Make sure your Octoparse account has API access. This feature is only available for Professional and Enterprise plans.
• Currently, only one action parameter is supported, and it must be of type URL or Text. If you need to update multiple actions in one task, please contact the developer.
• To find your Task ID and Action ID, go to your Octoparse task and refer to the provided screenshot or instructions.

Troubleshooting

Encounter obstacles but don't know how to resolve them when executing the app?

Please contact our support team at [email protected] to find the way out!

To help us better understand your issue, follow the steps below to export your running logs: