Settings to send data from Contact Form 7 to Google Sheets.
1. Installation: you go to Plugins => select Add new and then type the keyword “cf7”:
2. Usage:
Go to Contact Form => Google Sheets:
here you do the getcode, request access to google sheets with your gmail
Create a new spreadsheet on Google Sheets
To save the information submitted by the user you need to create a spreadsheet on Google Sheets.
When creating a spreadsheet, you remember to pay attention to 2 parameters: Worksheet Name and Sheet Name as follows:
+ Gsheet Connector Demo-sheets: is the spreadsheet name (Google Sheet Name).
+ CF7-Demo: is the sheet name (Google Sheet Tab Name).
Now go to the Contact Form section, select the form to submit:
Fill in the fields of Google Sheet Name, Google Sheet Tab Name as I mentioned above
and Google Sheets Id and Google Tab Id, based on the URL on your browser, copy it into the example as follows:
In the Google Sheets sheet, enter the contents of the columns as follows:
- date: time entry.
- your-email is the field in cf7 that you use to receive data from clients.
This is an example of a full relationship
Epilogue
Setting up to send data from Contact Form 7 to Google Sheets is very easy with the free CF7 Google Sheets Connector plugin . If you have any questions during the installation process, please leave a comment in the box below and I will help you.
If you find it interesting, you can follow the wordpress tips section to know more new knowledge.
Follow fanpage to receive the latest posts: Group
Wish you have interesting and interesting knowledge about wordpress!
