The Easiest Way to Sync WordPress with Google Sheets

Step 2

Enable APIs in Google Cloud Console.

Visit: https://console.cloud.google.com/.

Click “New Project” → Enter a project name (e.g., WP Form Integration) → Click Create

Select your project from the top navigation bar.

From the left sidebar, go to APIs & Services → Library

Search for Google Sheets API → Click Enable

Then search for Google Drive API → Click Enable.

Step 3

Create API Credentials.

Go to APIs & Services → Credentials → Click on + Create Credentials

Choose OAuth Client ID.

Click the button labeled “Configure Consent Screen”

Complete the form and click the ‘Create’ button.

Then click on “ Create OAuth client ID”.

Then select the “web application” option.

Click on the save button and then download the file from Download icon.

Step 4

Open the WordPress Dashboard. Then go to “Plugins” → “Add New”. Search for and install the following plugins: Contact Form 7, WooCommerce, Gravity Forms, and WPForms.

WP form Plugin

Contact form 7 Plugin

Woocommerce plugin

Click on G-sheet Integrations. Upload or paste the downloaded API credentials file in this section

Contact Form 7

You have to create the forms according to your own requirements — include whichever fields you want in your form.

And make sure your Google Sheet has the exact same fields as your form; otherwise, the data might get misaligned.

Click on support plugin & Make sure all four plugins are activated.

Go to ‘Google Sheet Feeds’ and click on the ‘+ Add Feed’ button.

Add Feed Configuration

1. Go to Add Feed.
2. Fill out the required fields.
3. In the Source Entity dropdown, select Contact Form 1.
4. Under Spreadsheet & Worksheet, enter the name of the Google Sheet you created.
5. Then select the specific Sheet Tab where you want the data to be saved. Choose this based on your own structure.
6. Click on Generate Mapping and wait for around 5 seconds.
7. After that, you’ll see a list of form fields. For each one, select the appropriate Source Data Field that matches the field from your form.
8. Click on save.

Go to “Pages” and then click on “All Pages”. Find the page where the Contact Form 7 is added, click on “View”, and then fill out the form and submit it.

And you can see your Google Sheet — the data you filled in the form will appear there.

Now testing Woocommerce

Step 1

Create Your Google Sheet

1. Go to Google Sheets
2. Create a new spreadsheet and name it (e.g., Woo Orders)
3. Create headers like: status, Name, Email, etc.

Connect Google Sheet

1. Go to Google Sheet Integration > Add Feeds
2. Authenticate your Google Account
3. Select the spreadsheet you created
4. Map the WooCommerce fields with Google Sheet columns
5. Save the feed

Test the Integration

Go to Pages > All Pages

Find your Shop page, click “View”

1. Select a product → Click Add to Cart
2. Go to View Cart, then Proceed to Checkout
3. 
4. Fill in all details and Place Order
5. 
6. Now, open your connected Google Sheet
7. You should see a new row with all order details

Now gravity forms

Navigate to “Forms” → “New Form” from the WordPress dashboard. Create your Gravity Form by adding fields based on your specific requirements.

Once the Gravity Form is created, navigate to “Add Feeds” and set up a new feed in the same way you did for the Contact Form 7 integration.

Go to: Pages → Add Page

• In the WordPress Dashboard, go to Pages → Add New.
• Click on the “+” (Add Block) button in the editor.
• From the block options, select “Gravity Forms”.
• A dropdown will appear — choose the form you previously created.
• Click the “Publish” button to save and publish the page.

Once the form is filled and submitted, verify that the data is successfully recorded in the linked Google Sheet. A new row should be created with the submitted information.

Now WP form

• Go to: Dashboard → WPForms → Add New
• Choose a template (e.g., Simple Contact Form)
• Add fields according to your needs
• Click Save

Add Form to a Page

Go to: Pages → Add New

Give the page a name (e.g., “WPForms Test”)

Click the “+” (Add Block) in the editor

Choose WPForms block

From the dropdown, select the form you just created the simple form.

After publishing, click on ‘View Page’.

“Edit the form according to your needs, then save it and fill it out. The submitted data will be sent to your connected Google Sheet.