There are many plugins that are specifically for creating forms in WordPress and saving or emailing the results. In this article I will show you how to save form results to Google Sheets from WordPress. This method does not require a form plugin but does use a bit of embedded html code to display a Google Form on your page. You will also need a Google account. If you do not have one you can get one for free on Googles Gmail page.
Step 1 – Create your WordPress Page
The first step is to create your WordPress page (or post) where you would like to display your form. From inside your WordPress dashboard click Pages on the left hand side then click the Add New button
For this example I am going to name the page Google Form but you can choose any relevant name. I am using the Elementor page builder. I added some Heading text that will appear over the form. Then save this page. We will be coming back to it shortly.
Step 2 – Create a Google Form
The second step is to create a Google Form. This is done from your Google Drive account. Login to your Google Drive then click the New button and from the menu that pops up choose More then Google Forms then Blank Form as shown below.
Create a simple form that collects Name and Email address as shown below. You can customize the fields as you wish. Google Forms also allows you to customize the color and add a header image if you wish.
Set the permissions on the form so that anyone can fill it out. To do this click on the gear icon to the left of the Send button.
Then in the settings windows under the “Required Sign in:” section, remove the check in the box next to “Restrict to users…”. This will make the form publicly accessible.
Step 3 – Embed the Google Form on the Page
From within Google Forms you need to get the code needed to embed the form into a WordPress Page. To get this code click on the Send button in the top right of the form designer screen.
This will display a popup windows with several send options as shown below. The option we need to click is the Embed HTML option that looks like ” < > “. Clicking on this option will display some HTML code. Adjust the width and height of your form if necessary and then click on the Copy button.
We now have the required code to paste into a WordPress page.
Next go back to the page we created earlier in WordPress. As I am using the Elementor page builder to create my page the process is very easy. On the left side of Elementor search for your HTML block and drag it over to your page area under the heading text we added in the first step. I am using the Elementor block but the built in WordPress “Custom HTML” block should work as well.
Now that the HTML block is added to your page we can paste the code for your form into the HTML code block.
With the code pasted you will now see the Google Form displayed on your page. If you need to make adjustments to colors or size you can edit the options in google and then get a new line of code to paste, however you can also adjust the code directly if you know what you are doing.
Save and Publish the page at this point, then open a browser and view your page. If you do not see your form please check the settings on the form to make sure a login is not required to view the form. Below is the WordPress page viewed in a Firefox browser with the embedded Google Form.
Testing your Google Form
If the form was added correctly you can now test submitting it. If it is not visible please review the steps above and correct any settings you may have skipped. Enter a name and email address in the form fields (any any others if you added more) and click on the Submit button. You should receive a message as shown below.
So far so good. The page and form are working. To view the results submitted you will need to check your Google Drive account and open the form by double clicking on it. When the Form is open click on “Responses” at the top of the form. You will see the responses that users have submitted.
You can also view the results in a Google Sheet by clicking on the small green icon about the “Accepting responses” text. This will create a new Google Sheet with the results. There will be one columns with the date and timestamp of when the form was submitted as well as a column for each form field you created on your form.
One of the reasons I prefer using WordPress is the flexibility to create sites and pages how I need them to look and behave. There are many methods for using forms in WordPress. This article will give you one more option. Please leave comments or questions below.
For some of my other WordPress Articles. Please consider subscribing below for email updates on new posts.