NS Google Sheets Connector

Screenshots

NOW Supports Connecting to Google via OATH! This plugin currently supports connecting the Contact Form 7 plugin to Google Sheets, but let us know what other kinds of data you’d like this to capture! The PRO Version is now available, and provides connections between unlimited CF7 forms and Google Spreadsheets! We also just added basic integration and support for automatically sending basic WooCommerce data to Google Sheets! How to Use this Plugin (Take a look at the screenshot to see how it all ties together and what settings need to go where!) Install the Contact Form 7 (CF7) plugin if you haven’t already. Create the CF7 Form that you want to use to capture data. You will need the ID and field names from the form. Log in to your Google Account and create a new Sheet and give it a simple name. Rename Sheet 1 (tab 1 of the spreadhseet) to something simple that makes sense (maybe the name of your form). Add a column name in Row 1 for “date” and each form field you will have in your form (default CF7 form field names are “your-name”, “your-email”, “your-subject”, “your-message”). Install this plugin. Go to Settings > NS Sheets to configure the plugin and click the link to generate a Google Code to paste in the Google Access Code box. Copy / paste the name of your spreadsheet and worksheet into the Google Sheet Name setting. Add the spreadsheet tab name and ID of the form you want to use in the settings. Save your settings. Test your form submit and verify that the data shows up in your Google Sheet. Have a beer and celebrate! Important Notes 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 plugin / form settings. Feedback is really important to us. Let us know if there are other creative ways you want to use this. Enjoy!