Envato Comment Task To Sheet

What This Skill Does

The Envato Comment Task To Sheet skill, authored by lokendragami1, serves as an intelligent bridge between customer feedback on platforms like ThemeForest and CodeCanyon and your internal project management workflows. Designed specifically for developers and agencies managing digital assets, this agent automatically processes raw comment text into structured data. It performs sophisticated natural language processing to classify comments into specific categories such as bug, feature request, or refund risk, assigns priority levels based on the severity of the request, and formats the output into a JSON structure ready for Google Sheets integration.

Installation

To install this skill, use the following command in your terminal within the OpenClaw environment:

clawhub install openclaw/skills/skills/lokendragami1/envato-comment-task-to-sheet

Once installed, ensure your Google Sheets API credentials are properly configured if you plan to link the output directly to a spreadsheet via an automation workflow.

Use Cases

• Support Workflow Automation: Automatically filter noise from support queues by identifying critical bugs vs. general inquiries.
• Product Health Tracking: Maintain a live pulse on user sentiment by aggregating refund threats and positive feedback.
• Update Planning: Automatically populate your development backlog with feature requests and reported issues, making the product roadmap decisions data-driven.
• Risk Mitigation: Proactively flag potential refund risks to your support team before they escalate into chargebacks.

Example Prompts

1. "Check the latest comments on my 'Modern Shop' ThemeForest page. The URL is https://themeforest.net/item/modern-shop/12345. Categorize any bugs and put them into my sheet."
2. "Process this customer comment: 'The checkout button is completely missing after the latest WordPress update, please help!' Product is a wordpress_theme. Determine priority and format for Google Sheets."
3. "Analyze the comments from CodeCanyon product 'SecureScript'. Identify any feature requests and extract the customer name for my tracking list."

Tips & Limitations

• Accuracy: The skill relies on natural language understanding. For the best results, ensure the provided comment_text is complete and includes as much context as possible.
• API Requirements: While the skill outputs the necessary JSON, you will need a middleware (like Zapier, Make, or a custom script) to perform the actual 'write' action into your specific Google Sheet.
• Limitations: The skill cannot interact directly with the Envato API; you must provide the comment text manually or via a separate scraping process. Ensure you classify the product_type correctly to help the logic apply the right priority rules.