> ## Documentation Index
> Fetch the complete documentation index at: https://jinshuju-20a27453.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# 数据自动推送到 Excel

> 表单持续收集数据的情况下，金数据可以和 Excel 实现自动化导出数据，省去了每天重复导出数据的步骤，减少人工操作。

### 一、创建符合自己需求的表单

根据个人实际需求搭建表单，设置需要填写的字段。

<img src="https://mintcdn.com/jinshuju-20a27453/YUXwIKtqKLjC_PZb/v4/attachments/qnDgFSmkDt8gF2c4aqwjJnLA.png?fit=max&auto=format&n=YUXwIKtqKLjC_PZb&q=85&s=857ec92371f5671b71dfb162e1f0cfbb" alt="" width="1967" height="1000" data-path="v4/attachments/qnDgFSmkDt8gF2c4aqwjJnLA.png" />

### 二、通过 [集简云](https://apps.jijyun.cn/) 推送到 Excel

1\. [Login | Microsoft 365](https://www.microsoft365.com/) 创建接收数据的在线 Excel 表单，将需要推送过来的字段表单添加完整。

<img src="https://mintcdn.com/jinshuju-20a27453/SPiIrK1JjUgg13q0/v4/attachments/Sytr2Nab1cPhQjJatiqRq8ky.png?fit=max&auto=format&n=SPiIrK1JjUgg13q0&q=85&s=2353ca5044efab9cca5535284a83e29d" alt="" width="1280" height="529" data-path="v4/attachments/Sytr2Nab1cPhQjJatiqRq8ky.png" />

2、登陆账户后新建流程，触发动作选择 Webhook。

<img src="https://mintcdn.com/jinshuju-20a27453/qtDc4FILJgM3Fpd4/v4/attachments/3FKL8V5CgYKZRmxmPTnsfbiT.png?fit=max&auto=format&n=qtDc4FILJgM3Fpd4&q=85&s=e4960daedde5b87b390ccaa99d36c25c" alt="" width="1280" height="690" data-path="v4/attachments/3FKL8V5CgYKZRmxmPTnsfbiT.png" />

<img src="https://mintcdn.com/jinshuju-20a27453/lpVaY_eqU8NMCSd_/v4/attachments/H1sqmHwqms5ySSPEzESKBoAp.png?fit=max&auto=format&n=lpVaY_eqU8NMCSd_&q=85&s=b5b09a421a1e23567043dad20704b61f" alt="" width="1280" height="659" data-path="v4/attachments/H1sqmHwqms5ySSPEzESKBoAp.png" />

<img src="https://mintcdn.com/jinshuju-20a27453/X18vV3Z9k0qaYLxP/v4/attachments/xkKmAgBqvet7HZdnfn698RhF.png?fit=max&auto=format&n=X18vV3Z9k0qaYLxP&q=85&s=430fe9017489705e531f251678d88157" alt="" width="1280" height="648" data-path="v4/attachments/xkKmAgBqvet7HZdnfn698RhF.png" />

2\. 选择触发动作后，保存下一步，获取 Webhook URL 配置到金数据的表单中。

<img src="https://mintcdn.com/jinshuju-20a27453/sSdHTDHjdSu1q3-g/v4/attachments/BEr82uwVoLFbSLaACpCRZwSA.png?fit=max&auto=format&n=sSdHTDHjdSu1q3-g&q=85&s=c8c9be5665f1d6a84690506d1ce6ae52" alt="" width="1280" height="848" data-path="v4/attachments/BEr82uwVoLFbSLaACpCRZwSA.png" />

3\. 请在金数据对应表单的「设置」页面，选择「数据推送」，将上一步复制的 URL 链接粘贴到 HTTP POST 地址里。

**⚠️** 注意：上方的「推送新增数据」与「推送变更数据」，根据情况请一定要勾选。

<img src="https://mintcdn.com/jinshuju-20a27453/UALSXHp7IDYL3WYs/v4/attachments/gGcXQG4SaZv9cJkKzdh3vbrN.png?fit=max&auto=format&n=UALSXHp7IDYL3WYs&q=85&s=41cb32b89fd8fd886db7d0f09d245d07" alt="" width="1280" height="643" data-path="v4/attachments/gGcXQG4SaZv9cJkKzdh3vbrN.png" />

1）如果需要推送符合条件的数据，请点击页面右上方「自动化」创建任务。

<img src="https://mintcdn.com/jinshuju-20a27453/SPiIrK1JjUgg13q0/v4/attachments/SCARxvbeSCSJffX1CK2utoXe.png?fit=max&auto=format&n=SPiIrK1JjUgg13q0&q=85&s=4261b169fbc563100273fc0612447e1e" alt="" width="1280" height="682" data-path="v4/attachments/SCARxvbeSCSJffX1CK2utoXe.png" />

2）选择需要触发的条件--推送到 Webhook。

<img src="https://mintcdn.com/jinshuju-20a27453/wtvR64o1sCpIhrNS/v4/attachments/W2skjRFRfgTz3285si1xzF7A.png?fit=max&auto=format&n=wtvR64o1sCpIhrNS&q=85&s=7e0800b2f30be34e2ba5b4c13e97b290" alt="" width="1280" height="906" data-path="v4/attachments/W2skjRFRfgTz3285si1xzF7A.png" />

3）POST 地址粘贴 URL 链接。

<img src="https://mintcdn.com/jinshuju-20a27453/HTQ0GlyiuT1J8jK-/v4/attachments/D6mHqZC5sUonzpUzWkUvo3De.png?fit=max&auto=format&n=HTQ0GlyiuT1J8jK-&q=85&s=99f53d7933cbf96cc2b6032c82a3018b" alt="" width="1280" height="999" data-path="v4/attachments/D6mHqZC5sUonzpUzWkUvo3De.png" />

4、请给该表单填写一条数据用来测试。

<img src="https://mintcdn.com/jinshuju-20a27453/qtDc4FILJgM3Fpd4/v4/attachments/33EiYnb5hTb9AerLPrAJPdH8.png?fit=max&auto=format&n=qtDc4FILJgM3Fpd4&q=85&s=bd4f7fdca9785e6a5477a6cdc095f690" alt="" width="1280" height="764" data-path="v4/attachments/33EiYnb5hTb9AerLPrAJPdH8.png" />

<img src="https://mintcdn.com/jinshuju-20a27453/UALSXHp7IDYL3WYs/v4/attachments/icVuqFG6w1BX9wKTs1zvMLox.png?fit=max&auto=format&n=UALSXHp7IDYL3WYs&q=85&s=7e37eb3ea8912a6f88e8441488f92f40" alt="" width="1280" height="752" data-path="v4/attachments/icVuqFG6w1BX9wKTs1zvMLox.png" />

5、点击下一步执行动作，输入 Excel 选择 Excel 365。

<img src="https://mintcdn.com/jinshuju-20a27453/rDRnGr4_jYen-FLI/v4/attachments/MPZCXAAdQ8SV3rsxSw6PNufE.png?fit=max&auto=format&n=rDRnGr4_jYen-FLI&q=85&s=6ed96e4413aef01953cdf261660f08f9" alt="" width="1280" height="758" data-path="v4/attachments/MPZCXAAdQ8SV3rsxSw6PNufE.png" />

1）执行动作选择「创建行」，保存下一步。

<img src="https://mintcdn.com/jinshuju-20a27453/YUXwIKtqKLjC_PZb/v4/attachments/qXcvvfcrTt9MTES3fqbAHUqr.png?fit=max&auto=format&n=YUXwIKtqKLjC_PZb&q=85&s=05983c9532a8ce424f77ea9f9d12e38d" alt="" width="1280" height="633" data-path="v4/attachments/qXcvvfcrTt9MTES3fqbAHUqr.png" />

2、选择你的「Microsoft 365」账户，保存进行下一步。

<img src="https://mintcdn.com/jinshuju-20a27453/HTQ0GlyiuT1J8jK-/v4/attachments/DK6eAdVf6RiKPq3CwyFoxC5u.png?fit=max&auto=format&n=HTQ0GlyiuT1J8jK-&q=85&s=808478b62f8373d6afff7efe4522ec21" alt="" width="1280" height="852" data-path="v4/attachments/DK6eAdVf6RiKPq3CwyFoxC5u.png" />

3）选择文件的来源，和 Excel 文件。

<img src="https://mintcdn.com/jinshuju-20a27453/sSdHTDHjdSu1q3-g/v4/attachments/Ap7M1uNPLFUwNmxu3gtfuUub.png?fit=max&auto=format&n=sSdHTDHjdSu1q3-g&q=85&s=9ff1ad8966554a52659e8770da885f96" alt="" width="1280" height="806" data-path="v4/attachments/Ap7M1uNPLFUwNmxu3gtfuUub.png" />

<img src="https://mintcdn.com/jinshuju-20a27453/qCEgiy_WXHXKMNNA/v4/attachments/uP7HcHSQh2r8zas4psq3mtxr.png?fit=max&auto=format&n=qCEgiy_WXHXKMNNA&q=85&s=da4d2fb9da34044cdb82389bbb8a5223" alt="" width="1280" height="778" data-path="v4/attachments/uP7HcHSQh2r8zas4psq3mtxr.png" />

6、工作表选择 Sheet1，将金数据和 Excel 的字段进行匹配。

<img src="https://mintcdn.com/jinshuju-20a27453/UALSXHp7IDYL3WYs/v4/attachments/i5aFL8BqUQhTr5DANodT2nmo.png?fit=max&auto=format&n=UALSXHp7IDYL3WYs&q=85&s=14610dd35a2b6796f873b94b1ac4c7b1" alt="" width="1280" height="893" data-path="v4/attachments/i5aFL8BqUQhTr5DANodT2nmo.png" />

<img src="https://mintcdn.com/jinshuju-20a27453/wtvR64o1sCpIhrNS/v4/attachments/VUeUbGunk8VHrb74tgKaj8bh.png?fit=max&auto=format&n=wtvR64o1sCpIhrNS&q=85&s=87d2bc710baa7db27cdeb99276859ef3" alt="" width="1280" height="902" data-path="v4/attachments/VUeUbGunk8VHrb74tgKaj8bh.png" />

<img src="https://mintcdn.com/jinshuju-20a27453/6_cw5VCgAXk0lmwc/v4/attachments/mM1MtH7Z4aWr1vUR2DHqvffV.png?fit=max&auto=format&n=6_cw5VCgAXk0lmwc&q=85&s=1334fc862e41a3c8945a82565e29a7a2" alt="" width="1280" height="965" data-path="v4/attachments/mM1MtH7Z4aWr1vUR2DHqvffV.png" />

1）添加完成点击保存下一步，「发送数据」测试。

<img src="https://mintcdn.com/jinshuju-20a27453/qCEgiy_WXHXKMNNA/v4/attachments/uGiSTptnfUgEm6JhWR2MYEKu.png?fit=max&auto=format&n=qCEgiy_WXHXKMNNA&q=85&s=177625aed602521868e8fc9c2777b041" alt="" width="1280" height="731" data-path="v4/attachments/uGiSTptnfUgEm6JhWR2MYEKu.png" />

7、根据返回结果去 Excel 表单查看，是否有数据。

<img src="https://mintcdn.com/jinshuju-20a27453/YUXwIKtqKLjC_PZb/v4/attachments/neYU48bBBcKPeRbqH3yBUaD6.png?fit=max&auto=format&n=YUXwIKtqKLjC_PZb&q=85&s=51a77e03a1526941b30dd81c33818f78" alt="" width="1280" height="382" data-path="v4/attachments/neYU48bBBcKPeRbqH3yBUaD6.png" />

1）数据接收正常点击「完成保存流程」。

<img src="https://mintcdn.com/jinshuju-20a27453/UALSXHp7IDYL3WYs/v4/attachments/h4cLNCdPV36y6dzSPeueKbjv.png?fit=max&auto=format&n=UALSXHp7IDYL3WYs&q=85&s=4c7256c7f88d9c553b640edad44eab6e" alt="" width="1280" height="931" data-path="v4/attachments/h4cLNCdPV36y6dzSPeueKbjv.png" />

8、确保流程状态是开启后，可以使用在金数据的表单填写一条数据，测试任务是否可以正常执行。

<img src="https://mintcdn.com/jinshuju-20a27453/X18vV3Z9k0qaYLxP/v4/attachments/y5sdWrvuZbzHhAAjjYEiUVxP.png?fit=max&auto=format&n=X18vV3Z9k0qaYLxP&q=85&s=b85dac32a6249f0d60101eeeef8e9be5" alt="" width="1280" height="320" data-path="v4/attachments/y5sdWrvuZbzHhAAjjYEiUVxP.png" />

## 三、资费介绍

数据自动推送到 Excel的资费介绍如下：

| | 免费版 | 专业版 | 专业增强版 | 企业基础版 | 企业协作版 | 企业高级版 |
| - | - | - | - | - | - | - |
| 价格 | 免费 | 599 元/年 | 2,399 元/年，299 元/月 | 4,399 元/年 | 7,399 元/年 | 23,999 元/年 |
| 发送到 Webhook | - | - | - | ✔️ | ✔️ | ✔️ |
| 数据推送（变更数据） | - | - | - | ✔️ | ✔️ | ✔️ |
| 数据推送（新增数据） | - | - | - | ✔️ | ✔️ | ✔️ |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.