WeCom SmartSheet Plugin

Description

The WeCom SmartSheet plugin enables seamless data integration between Dify workflows and WeCom (WeChat Work) SmartSheets through webhook-based data pushing. This tool allows you to automatically add records to your WeCom SmartSheets directly from your Dify applications.

Features

• Webhook Integration: Push data to WeCom SmartSheets via webhook URLs
• Batch Operations: Add single or multiple records in one request
• Easy to Use: No complex authentication required, simple operations to add records to target SmartSheets
• Secure: No credentials storage required, webhook-based authentication

Installation

1. Download the wecomsmartsheet.difypkg plugin package
2. In your Dify workspace, navigate to Tools > Install Plugin
3. Upload the plugin package
4. The plugin will be available in your tool library

Configuration

Prerequisites

• A WeCom SmartSheet with receive external data (webhook) functionality enabled
• Webhook URL generated from your target sheet

Setup Steps

1. In your WeCom SmartSheet, enable the receive external data (webhook) feature for the target sheet and obtain the webhook URL
2. In Dify, add the "WeCom SmartSheet" tool to your workflow
3. No global credentials are required - webhook URLs are specified per request

Usage

Tool: Add Record to SmartSheet

Add new records to your WeCom SmartSheet via webhook.

Parameters:

Parameter	Type	Required	Description
webhook_url	string	Yes	The webhook URL generated by WeCom SmartSheet for receiving external data
record_data	string (JSON)	Yes	Record data in JSON format, please refer to the receiving external data example of the target sheet

Example: Add a single record

webhook_url:

https://qyapi.weixin.qq.com/cgi-bin/wedoc/smartsheet/webhook?key=YOUR_WEBHOOK_KEY

record_data:

{
  "schema": {
    "f04Gwj": "Text",
    "ftQMc5": "Single Select",
    "ffFwIh": "Number",
    "fn8TJd": "Date"
  },
  "add_records": [
    {
      "values": {
        "f04Gwj": "Sample text",
        "ftQMc5": [{ "text": "Option A" }],
        "ffFwIh": 100,
        "fn8TJd": "1735660800000"
      }
    }
  ]
}

Note: The schema and field IDs (e.g. f04Gwj) are specific to your SmartSheet. Please refer to the receiving external data example provided by your target sheet's webhook configuration.

Response:

Success:

{
  "success": true,
  "message": "Record added successfully",
  "response": { /* webhook response */ }
}

Error:

{
  "success": false,
  "message": "Error description",
  "error": "Error details"
}

Use Cases

• CRM Data Sync: Automatically push customer information to WeCom SmartSheets
• Form Submissions: Collect customer leads submitted by frontline sales teams into WeCom SmartSheets
• Task Management: Create tasks in WeCom SmartSheets from project management software
• Data Collection: Aggregate data from multiple sources into WeCom SmartSheets

Best Practices

1. Field Mapping: Use the field IDs and schema from your SmartSheet's webhook configuration example
2. Data Validation: Validate data before sending to avoid webhook errors
3. Error Handling: Implement retry logic for failed requests
4. Webhook Security: Keep your webhook URLs confidential
5. Batch Processing: Use array format to add multiple records efficiently

Troubleshooting

Common Issues:

Issue	Solution
"Invalid webhook URL format"	Ensure URL starts with http:// or https://
"Invalid record data JSON format"	Validate JSON syntax before sending
"Request timeout"	Check network connectivity and webhook URL validity
"Cannot connect to webhook URL"	Verify the webhook URL is accessible

Technical Details

• Plugin Version: 0.0.1
• Author: ivanjiang
• Type: Tool Provider
• Python Version: 3.12+
• Dependencies:
  • dify_plugin>=0.4.0,<0.7.0
  • requests>=2.31.0

Changelog

Version 0.0.1 (2026-01-12)

• Initial release
• Add record functionality via webhook
• Multi-language support
• Comprehensive error handling

Support

• Author: ivanjiang
• Contact: longyijdos@gmail.com

For issues, questions, or feature requests, please contact the author or refer to the Dify Plugin Documentation.

---

License

MIT License

Privacy

This plugin does not collect, store, or transmit any user data except for the data explicitly sent to WeCom SmartSheet webhooks as configured by the user. Please refer to PRIVACY.md for detailed privacy policy.