Linux 软件免费装
Banner图

Integration with Google Sheets for Contact Form 7

开发者 alexagr
更新时间 2024年1月16日 18:11
捐献地址: 去捐款
PHP版本: 3.6 及以上
WordPress版本: 6.4.2
版权: GPLv3 or later
版权网址: 版权信息

标签

Google Contact Form 7 Google Sheets Sheets

下载

详情介绍:

This plugin provides integration between Contact Form 7 and Google Sheets. It adds new processor to Contact Form 7 that enables sending of submitted forms to Google Sheets. Connecting the Plugin to Google Sheets After installing the plugin you must go to it's Settings screen and create application credentials needed to establish connection with Google Sheets. All instructions are provided in the Settings screen. After successfully creating application credentials and uploading them (i.e. completing steps 1 and 2), you will see Client ID and Client Email that represent your instance of "Google Sheets for Contact Form 7" plugin. You will need to share your sheets with Client Email (as Editor role) to grant "Google Sheets for Contact Form 7" plugin permissions to edit them. Using the Plugin After successfully connecting the plugin to Google Sheets, do the following to configure your Contact Form 7 to send data to Google Sheets on form submission. In Google Sheets For example, for URL https://docs.google.com/spreadsheets/d/142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64/edit#gid=0 Sheet ID is "142XLjqRCpr7iWldfARhSS_GiFoy4l5RqZfSD6RHXM64" and Tab ID is "0" * Enter "datetime" in the the first column if you want to capture time and date of submission * There is no need to enter names for other columns - they will be automatically added upon form submission * Share the sheet with Client Email that represents your instance of "Google Sheets for Contact Form 7" plugin - as Editor role In Contact Form 7 Automatic Header Generation The plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed. Note that it never deletes fields from the header - as this would also delete some submission data - though you can do it manually. You may also manually reorder columns as you wish. Capturing Submission Metadata In addition to the datetime and regular form fields, you may also capture Contact Form 7 [special mail-tags][https://contactform7.com/special-mail-tags]. In order to do so, add manually corresponding headers to your spreadsheet. Remove square brackets and first underscore from the tag name, and replace remaining underscores with dashes. For example, add remote-ip header to capture [_remote_ip] mail-tag. Integration with "Contact Form 7 Database Addon - CFDB7" If you use Contact Form 7 Database Addon - CFDB7 to save your submissions, you will also be able to resend already submitted forms to Google Sheets. This may be useful if something went wrong during initial form submission and/or someone deleted data in Google Sheets by mistake. In order to do so, in CFDB7 plugin, choose your form, open specific submission and click Send to Google Sheets button. Acknowledgements Initial version of this plugin was inspired by CF7 Google Sheets Connector plugin. However it's implementation is quite different:

安装:

  1. Upload "cf7-google-sheets" to the "/wp-content/plugins/" directory
  2. Activate the plugin through the Plugins screen in WordPress

屏幕截图:

  • Configuring Google Sheets processor in Contact Form 7
  • Integration with "Contact Form 7 Database Addon - CFDB7" plugin

常见问题:

Why isn't the data sent to spreadsheet? Contact Form 7 Submit is just Spinning.

Sometimes it can take a while of spinning before it goes through. But if the entries never show up in your Google Sheet use the following checklist:

  • Check that plugin can access your sheet by entering it's Sheet ID in Settings screen and clicking Test
  • In Google Sheets processor configuration screen for your form:
  • Check that you entered correct Sheet ID and Tab ID (obtained from the sheet's URL - and NOT the Sheet/Tab Name)
  • Check View Log in plugin Settings screen for detailed error trace

更新日志:

1.3 1.2 1.1 1.0