How to use NS Google Sheets Connector

  1. Install the Contact Form 7 plugin (if you haven’t already).
  2. Create the Contact Form 7 form that you want to use to capture data. You will need the ID and field names from the form.
  3. Log in to your Google Account and create a new Sheet and give it a simple name (we recommend staying away from special characters).
  4. Rename “Sheet 1” (The first tab of your new Google Sheet) a name of your choice (again, keep it simple).
  5. Add a column name in Row 1 and name it “date”. Then, add a new column for each field you will have in your form (the default Contact Form 7 form field names are “your-name”, “your-email”, “your-subject”, “your-message”).
  6. Install the NS Google Sheets Connector plugin (if you haven’t already).
  7. Under the WordPress Dashboard Settings, click on the NS Sheets Pro link to configure the plugin and click the “here” link to generate a Google Code to paste in the Google Access Code box.
  8. Copy / paste the name of your spreadsheet and worksheet into the Google Sheet Name setting.
  9. Add the spreadsheet tab name and ID of the form you want to use in the settings.
  10. Save your settings.
  11. Test your form submit and verify that the data shows up in your Google Sheet.

(Take a look at the screenshot below to see how it all ties together and what settings need to go where! Make sure that all the highlighted field text matches EXACTLY one-to-one, including case sensitivity.)

How to Use NS Google Sheets Connector Pro

View the How To video below as well: