When visitor submits his data on your website via Contact Form 7 form, on form submission, such data are added into Google Spreadsheet..
Rename the tab on which you want to capture the data..
Create or Edit Contact Form 7 form from which you want to capture the data.
CF7 to Spreadsheet tab, copy-paste Google Spreadsheets sheet name and tab name into respective positions, and hit.
Use Admin Panel > Setting > CF7 To spreadsheet screen to connect to Google Sheets Account by entering Access Code.
Use Admin Panel > Contact form 7 > Select Contact form > On editor window tab - CF7 To spreadsheet Add your Sheet Name And Tab Name...
ONE point of note, that it did not like my customs fields, so just generate them CF7 and leave them alone, making sure that CF7 does not duplicate the field types..
I was going to try to find whole new app that would take the info submitted through form and insert it into spreadsheet rather than randomly email it to me.
I had some trouble at first with it populating the answers to checkbox input, but that resolved, and it seems like it just needed some time to propagate, because I didn't change anything when they started working..
Browse the code, check out SVN repository, or subscribe to the development log by RSS...
Read more