WPSyncSheets For WPForms – FAQ

Fix:

1. Go to your plugin’s API Settings page and copy the exact Authorized Redirect URI displayed there.
2. Open Google Cloud Console → Credentials → Edit your OAuth 2.0 Client ID.
3. Under Authorized Redirect URIs, add the exact URI you copied (do not modify it).
4. Save and wait 1–2 minutes, then try the authorization again.

Your Google Cloud project’s OAuth application is in Testing mode, and your Google account has not been added as a permitted test user.

Fix:

1. Go to Google Cloud Console → OAuth consent screen.
2. Either:
   • Change publishing status from Testing to In Production (click “Publish App”), or
   • Stay in Testing mode and add your Google email under Test users.

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:

1. In the WPSyncSheets tab of your form, locate the field in the header list.
2. Click the pencil/edit icon next to the header name.
3. Type the new name and click the checkmark to confirm.
4. Click Save Settings.

Important: Do not type a column name that already exists in your sheet — this can cause conflicts.

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:

1. In the WPSyncSheets form settings, select Create New Spreadsheet (or create a new sheet tab within the same spreadsheet).
2. On the new sheet setup screen, drag and drop your fields into the desired column order before saving.
3. Save settings and the new sheet will be created with your preferred column order.
4. Use Click to Sync to populate existing entries into the new sheet.

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:

1. In the WPSyncSheets form tab, note which fields are mapped incorrectly.
2. Disable all header mappings and then re-enable them — this forces the plugin to reference the new field IDs.
3. Alternatively, select Create New Sheet in the plugin settings. This regenerates all mappings fresh using the current field IDs.
4. 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.

The “Click to Sync” button pushes all existing WPForms entries into your connected Google Sheet. If it’s not working:

1. Confirm that WPSyncSheets settings have been saved for that form (a spreadsheet and sheet must be selected).
2. Click Clear Spreadsheet first to remove any conflicting existing data in the sheet, then click Click to Sync.
3. 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.

This error means the spreadsheet you selected already has a column structure that doesn’t match the current form’s field configuration.

Fix:

1. In the WPSyncSheets form settings, select the “Create New Spreadsheet” option from the spreadsheet dropdown.
2. The plugin will automatically generate a new spreadsheet with the correct headers for your current form.
3. 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.