AI助手支持GPT4.0
Homepage |
首页 |
Documentation |
文档 |
Support |
支持 |
Demo |
演示 |
Premium Version
高级版 p>
This plugin is a bridge between your WordPress WordPress
/">Contact Form 7 forms and Google Sheets.
/“>联系表单7 表单和 Google表格。 p>
When a visitor submits his/her data on your website via a Contact Form 7 form, upon form submission, such data are also sent to Google Sheets.
当访问者通过Contact Form 7表单在您的网站上提交他/她的数据时,在提交表单后,这些数据也将发送到Google表格。 p>
Get rid of making mistakes while adding the sheet settings or adding the headers ( Mail Tags ) to the sheet column.
在添加工作表设置或将标题(邮件标签)添加到工作表列时避免犯错。
We have Launched the Googlesheet Connector PRO version with more automated
我们已经发布了 Googlesheet Connector PRO版本,它具有更高的自动化程度
features.
功能。 p>
Get it Now
立即获取 h4>
Demo URL: https://cf7demo.gsheetconnector.com/
演示URL: https://cf7demo.gsheetconnector.com/ p>
Google Sheet URL to Check submitted Datahttps://docs.google.用于检查已提交数据的Google表格URL https://docs.google。 com/spreadsheets/d/1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs/com / spreadsheets / d / 1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs / p>
用于检查已提交数据的Google表格URL https://docs.google。 com/spreadsheets/d/1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs/
com/spreadsheets/d/1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs/
com / spreadsheets / d / 1ooBdX0cgtk155ww9MmdMTw8kDavIy5J1m76VwSrcTSs /
In Google Sheets
在Google表格中 em> * Log into your Google Account and visit Google Sheets.*登录到您的Google帐户并访问Google表格。* Create a new Sheet and name it.*创建一个新工作表并命名。* Rename the tab on which you want to capture the data.*重命名要在其上捕获数据的选项卡。 p>In WordPress Admin 在WordPress管理员中 em> * Create or Edit the Contact Form 7 form from which you want to capture the data.*创建或编辑要从中捕获数据的Contact Form 7表单。Set up the form as usual in the Form and Mail etc tabs.照常在“表单”和“邮件等”选项卡中设置表单。Thereafter, go to the new “Google Sheets” tab.之后,转到新的“ Google表格”标签。* On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.*在“ Google表格”标签上,将Google表格的工作表名称和标签名称复制粘贴到相应的位置,然后点击“保存”。 p>In Google Sheets 在Google表格中 em> * In the Google sheets tab, provide column names in row 1. The first column should be “date”.*在Google表格标签中,在第1行中提供列名称。第一列应为“日期”。For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).对于每个其他列,请从Contact Form 7表单中复制粘贴邮件标签(例如“您的姓名”,“您的电子邮件”,“您的主题”,“您的消息”等)。* Test your form submit and verify that the data shows up in your Google Sheet.*测试您的表单提交并验证数据是否显示在Google表格中。 p>Videos to help you get started with CF7 Google Sheets Connector可帮助您开始使用CF7 Google表格连接器的视频 h4>How to Install, Authenticate and Integrate Contact Form with your Google Sheet.如何在Google表格中安装,验证和集成联系表。 p> src='https://www.youtube.com/embed/E_dVAQHyBlw?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&wmode=transparent' allowfullscreen='true' style='border:0;'><src ='https://www.youtube.com/embed/E_dVAQHyBlw?version = 3&rel = 1&fs = 1&autohide = 2&showsearch = 0&showinfo = 1&iv_load_policy = 1&wmode = transparent'allowfullscreen ='true'style ='border:0;'> < /iframe>/ iframe> span>Important Notes重要注意事项 h4>You must pay very careful attention to your naming.您必须非常注意自己的命名。This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.如果您的Google表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。 li> ul>
* Log into your Google Account and visit Google Sheets.
*登录到您的Google帐户并访问Google表格。
* Create a new Sheet and name it.
*创建一个新工作表并命名。
* Rename the tab on which you want to capture the data.
*重命名要在其上捕获数据的选项卡。 p>
In WordPress Admin
在WordPress管理员中 em> * Create or Edit the Contact Form 7 form from which you want to capture the data.*创建或编辑要从中捕获数据的Contact Form 7表单。Set up the form as usual in the Form and Mail etc tabs.照常在“表单”和“邮件等”选项卡中设置表单。Thereafter, go to the new “Google Sheets” tab.之后,转到新的“ Google表格”标签。* On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.*在“ Google表格”标签上,将Google表格的工作表名称和标签名称复制粘贴到相应的位置,然后点击“保存”。 p>In Google Sheets 在Google表格中 em> * In the Google sheets tab, provide column names in row 1. The first column should be “date”.*在Google表格标签中,在第1行中提供列名称。第一列应为“日期”。For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).对于每个其他列,请从Contact Form 7表单中复制粘贴邮件标签(例如“您的姓名”,“您的电子邮件”,“您的主题”,“您的消息”等)。* Test your form submit and verify that the data shows up in your Google Sheet.*测试您的表单提交并验证数据是否显示在Google表格中。 p>Videos to help you get started with CF7 Google Sheets Connector可帮助您开始使用CF7 Google表格连接器的视频 h4>How to Install, Authenticate and Integrate Contact Form with your Google Sheet.如何在Google表格中安装,验证和集成联系表。 p> src='https://www.youtube.com/embed/E_dVAQHyBlw?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&wmode=transparent' allowfullscreen='true' style='border:0;'><src ='https://www.youtube.com/embed/E_dVAQHyBlw?version = 3&rel = 1&fs = 1&autohide = 2&showsearch = 0&showinfo = 1&iv_load_policy = 1&wmode = transparent'allowfullscreen ='true'style ='border:0;'> < /iframe>/ iframe> span>Important Notes重要注意事项 h4>You must pay very careful attention to your naming.您必须非常注意自己的命名。This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.如果您的Google表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。 li> ul>
* Create or Edit the Contact Form 7 form from which you want to capture the data.
*创建或编辑要从中捕获数据的Contact Form 7表单。
Set up the form as usual in the Form and Mail etc tabs.
照常在“表单”和“邮件等”选项卡中设置表单。
Thereafter, go to the new “Google Sheets” tab.
之后,转到新的“ Google表格”标签。
* On the “Google Sheets” tab, copy-paste the Google Sheets sheet name and tab name into respective positions, and hit “Save”.
*在“ Google表格”标签上,将Google表格的工作表名称和标签名称复制粘贴到相应的位置,然后点击“保存”。 p>
在Google表格中 em> * In the Google sheets tab, provide column names in row 1. The first column should be “date”.*在Google表格标签中,在第1行中提供列名称。第一列应为“日期”。For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).对于每个其他列,请从Contact Form 7表单中复制粘贴邮件标签(例如“您的姓名”,“您的电子邮件”,“您的主题”,“您的消息”等)。* Test your form submit and verify that the data shows up in your Google Sheet.*测试您的表单提交并验证数据是否显示在Google表格中。 p>Videos to help you get started with CF7 Google Sheets Connector可帮助您开始使用CF7 Google表格连接器的视频 h4>How to Install, Authenticate and Integrate Contact Form with your Google Sheet.如何在Google表格中安装,验证和集成联系表。 p> src='https://www.youtube.com/embed/E_dVAQHyBlw?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&wmode=transparent' allowfullscreen='true' style='border:0;'><src ='https://www.youtube.com/embed/E_dVAQHyBlw?version = 3&rel = 1&fs = 1&autohide = 2&showsearch = 0&showinfo = 1&iv_load_policy = 1&wmode = transparent'allowfullscreen ='true'style ='border:0;'> < /iframe>/ iframe> span>Important Notes重要注意事项 h4>You must pay very careful attention to your naming.您必须非常注意自己的命名。This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.如果您的Google表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。 li> ul>
* In the Google sheets tab, provide column names in row 1. The first column should be “date”.
*在Google表格标签中,在第1行中提供列名称。第一列应为“日期”。
For each further column, copy paste mail tags from the Contact Form 7 form (e.g. “your-name”, “your-email”, “your-subject”, “your-message”, etc).
对于每个其他列,请从Contact Form 7表单中复制粘贴邮件标签(例如“您的姓名”,“您的电子邮件”,“您的主题”,“您的消息”等)。
* Test your form submit and verify that the data shows up in your Google Sheet.
*测试您的表单提交并验证数据是否显示在Google表格中。 p>
How to Install, Authenticate and Integrate Contact Form with your Google Sheet.
如何在Google表格中安装,验证和集成联系表。 p>
src='https://www.youtube.com/embed/E_dVAQHyBlw?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&wmode=transparent' allowfullscreen='true' style='border:0;'><src ='https://www.youtube.com/embed/E_dVAQHyBlw?version = 3&rel = 1&fs = 1&autohide = 2&showsearch = 0&showinfo = 1&iv_load_policy = 1&wmode = transparent'allowfullscreen ='true'style ='border:0;'> < /iframe>/ iframe> span>Important Notes重要注意事项 h4>You must pay very careful attention to your naming.您必须非常注意自己的命名。This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.如果您的Google表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。 li> ul>
src='https://www.youtube.com/embed/E_dVAQHyBlw?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&wmode=transparent' allowfullscreen='true' style='border:0;'><src ='https://www.youtube.com/embed/E_dVAQHyBlw?version = 3&rel = 1&fs = 1&autohide = 2&showsearch = 0&showinfo = 1&iv_load_policy = 1&wmode = transparent'allowfullscreen ='true'style ='border:0;'> < /iframe>
src='https://www.youtube.com/embed/E_dVAQHyBlw?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&wmode=transparent' allowfullscreen='true' style='border:0;'><
src ='https://www.youtube.com/embed/E_dVAQHyBlw?version = 3&rel = 1&fs = 1&autohide = 2&showsearch = 0&showinfo = 1&iv_load_policy = 1&wmode = transparent'allowfullscreen ='true'style ='border:0;'> <
/iframe>
/ iframe> span>
This plugin will have unpredictable results if names and spellings do not match between your Google Sheets and form settings.
如果您的Google表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。 li>
ul>
cf7-google-sheets-connector
/wp-content/plugins/
Site Admin > Plugins > New > Search > CF7将 cf7-google-sheets-connector code>上载到 / wp-content / plugins / code>目录,或 Site Admin>插件>新建>搜索> CF7 Google Sheets Connector > Install.Google表格连接器>安装 code>。 li>Activate the plugin through the ‘Plugins’ screen in WordPress.通过WordPress中的“插件”屏幕激活插件。 li>Use the Admin Panel > Contact form 7 > Google Sheets screen to connect to Google Sheets by entering the Access Code.使用管理面板>联系人表格7> Google表格 code>屏幕,通过输入访问代码来连接到 Google表格 code>。You can get the Access Code by clicking the “Get Code” button.您可以通过单击“获取代码”按钮获取访问代码。Enjoy!享受吧! li>
cf7-google-sheets-connector code>上载到 / wp-content / plugins / code>目录,或 Site Admin>插件>新建>搜索> CF7 Google Sheets Connector > Install.Google表格连接器>安装 code>。
/ wp-content / plugins / code>目录,或 Site Admin>插件>新建>搜索> CF7 Google Sheets Connector > Install.Google表格连接器>安装 code>。
Site Admin>插件>新建>搜索> CF7 Google Sheets Connector > Install
Google Sheets Connector > Install
Google表格连接器>安装 code>。
li>
Admin Panel > Contact form 7 > Google Sheets
Google Sheets
管理面板>联系人表格7> Google表格 code>屏幕,通过输入访问代码来连接到 Google表格 code>。You can get the Access Code by clicking the “Get Code” button.您可以通过单击“获取代码”按钮获取访问代码。Enjoy!
Google表格 code>。You can get the Access Code by clicking the “Get Code” button.您可以通过单击“获取代码”按钮获取访问代码。Enjoy!
You can get the Access Code by clicking the “Get Code” button.
您可以通过单击“获取代码”按钮获取访问代码。
Enjoy!
享受吧! li>
ol>
原文出处:http://www.sanshu.cn/a/6866.html
群主管理都是支付大佬