I followed all the setup steps but get an “authorization error” when generating the token. What should I check?
The most common causes are:
Google Drive API not enabled — You must enable both the Google Sheets API and the Google Drive API in your Google Cloud project. Go to Google Cloud Console → APIs & Services → Library and enable both.
Redirect URI mismatch — The Authorized Redirect URI in your Google Cloud OAuth credentials must exactly match the URI shown in the plugin’s API Settings page. Copy it precisely — even a trailing slash difference will cause the error.
App not published — If your Google OAuth app is in “Testing” status and your Google account isn’t listed as a test user, you’ll be blocked. Go to Google Cloud Console → OAuth consent screen → change status to In Production (or add your email as a test user).
I get “Error 400: redirect_uri_mismatch” during authorization. How do I fix it?
Fix:
Go to your plugin’s API Settings page and copy the exact Authorized Redirect URI displayed there.
Change publishing status from Testing to In Production (click “Publish App”), or
Stay in Testing mode and add your Google email under Test users.
I renamed some fields in my WPForms form, but the old field names still appear in the WPSyncSheets mapping panel and Google Sheet. Why?
This is expected behavior and one of the most important things to understand about the plugin.
When you save field mappings in WPSyncSheets, the plugin stores the internal WPForms field IDs, not the display labels. When you rename a field label in WPForms, the field ID stays the same — so the plugin’s mapping continues to work, but the column header in Google Sheets will still show the original name.
To update a column header in Google Sheets:
In the WPSyncSheets tab of your form, locate the field in the header list.
Click the pencil/edit icon next to the header name.
Type the new name and click the checkmark to confirm.
Click Save Settings.
Important: Do not type a column name that already exists in your sheet — this can cause conflicts.
How do I reorder the column headers in my Google Sheet?
Column order is determined when you first save your spreadsheet settings. Once the spreadsheet is created, you cannot reorder columns by simply dragging them in the plugin settings — doing so would create a data mismatch with existing entries.
Correct way to reorder columns:
In the WPSyncSheets form settings, select Create New Spreadsheet (or create a new sheet tab within the same spreadsheet).
On the new sheet setup screen, drag and drop your fields into the desired column order before saving.
Save settings and the new sheet will be created with your preferred column order.
Use Click to Sync to populate existing entries into the new sheet.
I imported/cloned a WPForms form to a new site, and now data is not syncing correctly. What happened?
When you export a WPForms form and import it to a new site, WordPress assigns new internal field IDs to each field. The WPSyncSheets mapping stored in your settings still references the old field IDs from the original site, which no longer exist on the new site.
Fix:
In the WPSyncSheets form tab, note which fields are mapped incorrectly.
Disable all header mappings and then re-enable them — this forces the plugin to reference the new field IDs.
Alternatively, select Create New Sheet in the plugin settings. This regenerates all mappings fresh using the current field IDs.
After saving, click Click to Sync to push any existing entries.
Preventative tip: After importing a form, always verify your WPSyncSheets field mappings before going live, even if the form looks identical.
Pre-existing form entries are not appearing when I click the “Click to Sync” button. How do I fix this?
The “Click to Sync” button pushes all existing WPForms entries into your connected Google Sheet. If it’s not working:
Confirm that WPSyncSheets settings have been saved for that form (a spreadsheet and sheet must be selected).
Click Clear Spreadsheet first to remove any conflicting existing data in the sheet, then click Click to Sync.
Note: WPForms only stores entries if the WPForms entry storage setting is enabled. If entries are not being stored in the WPForms database, the sync button has nothing to push.
I see the error: “Selected spreadsheet will be mismatch match your entry data with respect to the sheet headers so please create new spreadsheet.” What does this mean?
This error means the spreadsheet you selected already has a column structure that doesn’t match the current form’s field configuration.
Fix:
In the WPSyncSheets form settings, select the “Create New Spreadsheet” option from the spreadsheet dropdown.
The plugin will automatically generate a new spreadsheet with the correct headers for your current form.
If you want to keep everything in one spreadsheet file, select your existing spreadsheet file but choose “Create New Sheet” for the tab name.
Note: Do not try to manually match the headers in Google Sheets — always let the plugin create the structure.
Documentation
