How to Save WordPress Form Submissions to Google Sheets

Google Sheets can be a simple way to review, organize, and share form submissions. Instead of asking someone to log in to WordPress, you can send form data to a spreadsheet and manage it there.

This can be useful for team collaboration, reporting, backups, or lead tracking.

With Form Vibes Pro, you can connect your forms to Google Sheets and send submission data to a selected spreadsheet and worksheet. Once the connection is set up, new submissions can be organized in a sheet where they are easier to review and share.

In this guide, you will learn how to connect Form Vibes with Google Sheets in a simple step-by-step way.

What This Google Sheets Integration Does

This integration allows Form Vibes to send form submission data from your website to Google Sheets.

After setup, you can:

• choose which form to connect
• select the spreadsheet and worksheet
• map form fields to sheet columns
• send submissions in a more organized way

This is helpful when you want to work with form data outside WordPress or share it with team members who do not need access to the WordPress dashboard.

Before You Start

Before starting, make sure you have:

• Form Vibes Pro
• a Google account
• access to Google Cloud Console
• a Google spreadsheet where you want to send the data

You will also need to create Google API credentials. These include a Client ID and Client Secret, which are required to connect your Google account with Form Vibes.

How to Connect Form Vibes with Google Sheets

The setup has three main steps:

Step 1: Create Google API Credentials

Before you connect Form Vibes to Google Sheets, you need to create Google API credentials. These credentials allow your website to communicate securely with your Google account.

This part of the setup is done in Google Cloud Console, where you will:

• create or choose a Google Cloud project
• enable the required Google APIs
• configure the OAuth consent screen
• generate the Client ID and Client Secret
• add the correct redirect URI

Since this process involves several Google Cloud settings, it is better to follow the detailed guide we have already prepared on Google API credentials setup.

Once your Client ID and Client Secret are ready, return to Form Vibes and continue with the next step.

Step 2: Connect Form Vibes to Google Sheets

Once you have the Client ID and Client Secret, go to the Google Sheet settings in Form Vibes inside your WordPress dashboard.

• Go to Form Vibes → Settings → Google Sheet.

Paste your:

• Google Client ID
• Google Client Secret

Then click Authenticate and sign in with your Google account. After approval, the connection status should show as connected.

About the “App is not verified” message

If you see a warning during the step, click Show Advanced and then Go to App.

After that, approve all requested permissions.

Step 3: Create a Google Sheets Export Profile

Now that your Google account is connected, the next step is to create an Export Profile.

Go to Form Vibes → Export Profile and create a new profile.

Then:

• Choose Google Sheet as the export type
• Select the form you want to connect
• Choose the existing spreadsheet or create a new one by clicking on the plus (+) icon
• Choose the existing worksheet or create new one

• Create column headers manually or choose click here option to add them
• Apply filters if needed

Column mapping

Column mapping helps match each form field to the correct column in Google Sheets. This is important because it keeps your sheet organized and makes the exported data easier to read.

If you created headers automatically, review them once before publishing the profile to make sure each field is going to the correct place.

Test the Google Sheets Connection

Before relying on the setup, submit a test form entry from the frontend of your website.

Then open the connected spreadsheet and check that:

• the new row appears in the correct spreadsheet
• the data appears in the correct worksheet
• each value matches the right column
• the export profile is working as expected

This is an important step because it confirms the connection, the field mapping, and the sheet selection all at once.

Common Issues and Troubleshooting Tips

Spreadsheet is not showing in the dropdown

Check that the Google account connected in Form Vibes has access to the spreadsheet. Also make sure the authentication step was completed successfully.

Redirect URI mismatch

If you see a redirect URI error, review the redirect URI added in your Google app setup. It must match the one used during the connection process.

App verification warning during authentication

If Google shows a warning during authentication, check your OAuth consent setup and make sure all required settings were added correctly.

Data is not appearing in the sheet

Check that:

• the export profile is published,
• the correct form is selected,
• the correct spreadsheet and worksheet are selected,
• and you submitted a new test entry after publishing the profile.
  These are all part of the Form Vibes export-profile workflow.

Column mapping does not match the sheet

If the data appears in the wrong columns, open the export profile again and review the field mapping. Update the mapping if your sheet headers or form fields have changed.

Conclusion

Connecting Form Vibes with Google Sheets is a practical way to send form submission data to a spreadsheet for easier review and sharing.

The process includes:

• creating Google API credentials,
• authenticating your Google account in Form Vibes,
• creating an export profile,
• and testing the setup with a sample submission.

Once everything is connected, you can review form submissions in Google Sheets without depending only on the WordPress dashboard.

FAQs on Saving Form Submissions in Google Sheet