WPSyncSheets For Contact Form 7

This means the redirect URI you entered in your Google Cloud project does not match what the plugin expects.

Fix:

1. Go to your plugin’s API Settings page and copy the exact Authorized Redirect URI shown there.
2. Open Google Cloud Console → Your project → Credentials → Edit your OAuth 2.0 Client ID.
3. Under Authorized Redirect URIs, add the exact URI you copied from the plugin (do not modify it).
4. Save and wait 1–2 minutes for Google to apply the change.
5. Try the authorization process again.

This means your Google Cloud project’s OAuth app is still in Testing status and the Google account you are using has not been added as a test user.

Fix:

1. Go to Google Cloud Console → OAuth consent screen.
2. Change the publishing status from Testing to In Production (also called “Publish App”).
3. Alternatively, if staying in Testing mode, add your Google email address under Test users.

Follow step 18 of the Google API Setup documentation for detailed screenshots.

You cannot write to an existing spreadsheet tab (sheet) that already has data with a different structure. If you try to connect the plugin to a pre-existing sheet, you will see the error:

“Selected spreadsheet will be mismatch match your entry data with respect to the sheet headers so please create new spreadsheet.”

What you CAN do:

• Create a new spreadsheet — Select “Create New Spreadsheet” from the plugin dropdown. The plugin will automatically generate a new spreadsheet with the correct headers.
• Use an existing spreadsheet file but create a new tab — From the plugin settings, select your existing Google Spreadsheet file but choose “Create New Sheet” for the tab. This keeps all your data in one spreadsheet file, with each form’s data in a separate tab.

Yes, this can happen because the plugin syncs data to Google Sheets synchronously (in real time at the moment of submission). The confirmation message waits until the sync completes before displaying.

If sync response time is slow:

• Check your server’s internet connection speed.
• Check that your Google API credentials are healthy and not producing errors.
• Ensure your server’s max_execution_time PHP setting is at least 60 seconds to prevent timeouts.

Yes. The plugin supports file upload fields. When a file is uploaded through a CF7 form, the plugin stores the file and logs its URL in your Google Sheet (rather than the file itself, since Google Sheets cannot contain files).

Important:

• The file URL stored in the sheet links to the uploaded file on your server.
• Make sure your server’s upload directory has correct write permissions.
• Uploaded files are stored in a folder created by the WPSyncSheets plugin within your WordPress installation.

Before you start, make sure you have the following:

1. Contact Form 7 plugin installed and active on your WordPress site.
2. WPSyncSheets For Contact Form 7 plugin installed and activated (free or Pro version).
3. A valid license key (found in your purchase confirmation email or your account on wpsyncsheets.com).
4. A Google account with access to Google Sheets and Google Drive.
5. A Google Cloud project with the Google Sheets API and Google Drive API enabled (required to generate your Client ID and Client Secret Key).

Yes. You can send data from multiple forms to the same Google Spreadsheet, with each form’s data going into a different sheet tab.

How to set this up:

1. For Form 1: Select your spreadsheet → Create a new sheet tab (e.g., “Contact Form”) → Save.
2. For Form 2: Select the same spreadsheet → Create another new sheet tab (e.g., “Quote Form”) → Save.
3. Repeat for each form.

Note: Do not map two different forms to the exact same sheet tab unless the fields are identical. Mixing form structures in one tab will cause data misalignment.

Run through this diagnostic checklist:

1. Settings saved? — Open the form in WP admin → WPSyncSheets tab → confirm a spreadsheet and sheet tab are selected and settings have been saved.
2. Plugin active? — Confirm the plugin is still activated (Plugins → Installed Plugins).
3. API connected? — Check the plugin’s API Settings page. Confirm your token is active and no errors are shown.
4. Test submission — Fill out and submit the CF7 form. If email notifications work but the sheet doesn’t update, the issue is specific to the Google API connection.
5. Revoke and re-authorize — Go to API Settings → Revoke Token → Get Token (re-authorize).