CF7 Spreadsheets

WordPress plugin that merge Contact form 7 functional with google spreadsheets (also works with private spreadsheet).

How to use:

Video instruction: https://www.youtube.com/watch?v=ZgZRBByY4fc Video instruction (OLD versions): https://www.youtube.com/watch?v=5ICWr5MMo7E

1. 01Prepare API Go to the Console Developers API
2. 02Create new project (or choose existing one)
3. 03Click “enable API and services”, or click on “library” tab
4. 04Find in list “Google sheets API” and click “Enable”
5. 05Go to Credentials tab and click create credentials . In dropdown list choose Service account key . In next window select you service account, and Key type to JSON .
6. 06Save the JSON document
7. 07Upload JSON document on plugin page (second tab).
8. 08Create a table Go to the Google Spreadsheets and create new table (or open exists table)
9. 09Copy table URL and ID. For example: //docs.google.com/spreadsheets/d/1yhzO1Q6ikYysfg8LCHqegPM/edit#gid=0 in this table URL is: 1yhzO1Q6ikYysfg8LCHqegPM , and ID is: 0 (parameter gid ).
10. 10If you have private spreadsheet – you should grant edit rights to your service account (that we create earlier) directly in spreadsheet. You could find service account email in your website admin panel after uploading JSON file.
11. 11Paste the spreadsheet URL and ID in plugin options page, upload JSON file, and choose other options.
12. 12Create usual form in Contact form 7 and use it.