AI助手支持GPT4.0
This plugin connects your Contact Form 7 and Google Spreadsheet.
此插件可将您的联系表格7和Google Spreadsheet连接起来。 p>
When a visitor submits his/her data on your website via a Contact Form 7 form, on form submission, such data are added into Google Spreadsheet.
当访问者通过Contact Form 7表单在您的网站上提交他/她的数据时,在提交表单时,这些数据将添加到Google Spreadsheet中。 p>
This is a simple way to maintain your contact form 7 data backup.
这是维护联系表7数据备份的简单方法。 p>
In Google Spreadsheet
在Google电子表格中 em> p>Log into your Google Account and visit Google Spreadsheet.登录您的Google帐户并访问Google Spreadsheet。 li>Create a new Sheet and name it.创建一个新工作表并命名。 li>Rename the tab on which you want to capture the data.重命名要在其上捕获数据的选项卡。 li>In the Google sheets tab, provide column names in row 1. The first column should be “date” if you want to add 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表单中复制粘贴邮件标签(例如“您的姓名”,“您的电子邮件”,“您的主题”,“您的消息”等)。Also, you can add required mail tags (e.g “your-name”, “your-email”).另外,您可以添加必需的邮件标签(例如“您的姓名”,“您的电子邮件”)。 p> li>Process to generate API key生成API密钥的过程 p> li>Follow the steps from this url to create a project: https://docs.brainstormforce.com/create-google-sheet-api-key/按照以下网址中的步骤创建项目:https://docs.brainstormforce.com/create-google-sheet-api-key/ p> li>After the project is created, go to Quotas tab, click on “Google sheet Api” and then on Credentials创建项目后,转到“配额”选项卡,单击“ Google sheet Api”,然后单击“凭据” li>Press Create Credentials按创建凭据 li>Select OAuth client ID选择OAuth客户端ID li>Select Other, give it a name and Save选择“其他”,为其命名并保存 li>You’ll get a popup with client Id and client secret您将看到一个带有客户ID和客户机密的弹出窗口 li>Copy/paste those on lines 13 and 14 (see above)复制/粘贴第13和14行上的内容(请参见上文) li>You need to Reconnect the plugin – go to Wp Admin/Settings/CF7 to Spreadsheet/Press “Reconnect with google Spreadsheet您需要重新连接插件–转到Wp Admin / Settings / CF7到电子表格/按“与Google Spreadsheet重新连接 li> ul>In WordPress Admin 在WordPress管理员中 em> p>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 “CF7 to Spreadsheet” tab.之后,转到新的“ CF7到电子表格”选项卡。 li>On the “CF7 to Spreadsheet” tab, copy-paste the Google Spreadsheets sheet name and tab name into respective positions, and hit “Save”.在“ CF7到电子表格”标签上,将Google Spreadsheets表格名称和标签名称复制粘贴到各自的位置,然后点击“保存”。 li> ul>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 Spreadsheets and form settings.如果您的Google电子表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。Also, naming is not case sensitive.另外,命名也不区分大小写。 li> ul>
li>
In the Google sheets tab, provide column names in row 1. The first column should be “date” if you want to add 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表单中复制粘贴邮件标签(例如“您的姓名”,“您的电子邮件”,“您的主题”,“您的消息”等)。
Also, you can add required mail tags (e.g “your-name”, “your-email”).
另外,您可以添加必需的邮件标签(例如“您的姓名”,“您的电子邮件”)。 p>
Process to generate API key
生成API密钥的过程 p>
Follow the steps from this url to create a project: https://docs.brainstormforce.com/create-google-sheet-api-key/
按照以下网址中的步骤创建项目:https://docs.brainstormforce.com/create-google-sheet-api-key/ p>
ul>
In WordPress Admin
在WordPress管理员中 em> p>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 “CF7 to Spreadsheet” tab.之后,转到新的“ CF7到电子表格”选项卡。 li>On the “CF7 to Spreadsheet” tab, copy-paste the Google Spreadsheets sheet name and tab name into respective positions, and hit “Save”.在“ CF7到电子表格”标签上,将Google Spreadsheets表格名称和标签名称复制粘贴到各自的位置,然后点击“保存”。 li> ul>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 Spreadsheets and form settings.如果您的Google电子表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。Also, naming is not case sensitive.另外,命名也不区分大小写。 li> ul>
Set up the form as usual in the Form and Mail etc tabs.
照常在“表单”和“邮件等”选项卡中设置表单。
Thereafter, go to the new “CF7 to Spreadsheet” tab.
之后,转到新的“ CF7到电子表格”选项卡。
This plugin will have unpredictable results if names and spellings do not match between your Google Spreadsheets and form settings.
如果您的Google电子表格和表单设置之间的名称和拼写不匹配,则此插件将产生无法预测的结果。
Also, naming is not case sensitive.
另外,命名也不区分大小写。 li>
contact-form-to-excel-addon
/wp-content/plugins/
contact-form-to-excel-addon code>上载到 / wp-content / plugins / code>目录并安装。
/ wp-content / plugins / code>目录并安装。
Admin Panel > Setting > CF7 To spreadsheet
Google Sheets Account
管理面板>设置> CF7到电子表格 code>屏幕,通过输入访问代码来连接到 Google表格帐户 code>。You can get the Access Code by clicking the “Get Code” button.您可以通过单击“获取代码”按钮获取访问代码。
Google表格帐户 code>。You can get the Access Code by clicking the “Get Code” button.您可以通过单击“获取代码”按钮获取访问代码。
You can get the Access Code by clicking the “Get Code” button.
您可以通过单击“获取代码”按钮获取访问代码。
Admin Panel > Contact form 7 > Select Contact form > On editor window tab - CF7 To spreadsheet
管理面板>联系人表单7>选择联系人表单>在编辑器窗口选项卡上-CF7到电子表格 code>添加工作表名称和选项卡名称。 li>
ol>
原文出处:http://www.sanshu.cn/a/6938.html
群主管理都是支付大佬