westerndeal

@paarami
There is no error related to plugin – CF7 Google Sheet Connector
Error will be shown whenever the entry is missed!

@victoriaregina
Thanks for the confirmation,
We are super happy that this issue is resolved.?

If you have any other questions in the future, know that we are here to help you.

If you don’t mind us asking, could you please leave us a 5-of-5 star review (if you haven’t already) on?https://www.ads-software.com/support/plugin/gsheetconnector-forminator/reviews/#new-post

Regards
Abdullah

Hello @deguwd
Thanks for getting in touch, and sorry for the delay in responding,

The full attachment link would be available in the PRO version of the plugin.

Hello @victoriaregina
Issue has been resolved in the Version 1.0.11
Please take a look and let us know,

You can also setup a test site from here for a quick test, refer to this link
https://tastewp.com/new/?pre-installed-plugin-slug=forminator&pre-installed-plugin-slug=gsheetconnector-forminator

Hope this helps!
Feel free to let us know if you have any issues or questions!

Thanks
Abdullah

Hello @pwdesigns
Thanks for getting in touch,

If some entries are missing or skipped, then this may be because of Google Quota Exceed Limit, This can be solved while configuring the manual authentication method,

Refer to this link, explained: https://www.gsheetconnector.com/how-to-fix-missing-entries-caused-by-google-quota-limits

Hope this helps!

Thanks
Abdullah

Hello @paarami
Thanks for getting in touch,

As mentioned in our article, First confirm that missing might be because of Google Quota Limit Reached, you have to enable the debug log and check the errors, when ever entry is missed Google Quota Reached will be shown!

To solve this missing issue refer to this
https://www.gsheetconnector.com/how-to-fix-missing-entries-caused-by-google-quota-limits

Hope this helps!

Hello @hotelwww
Thanks for getting in touch,

Format Cells as Text

• If you want the minus sign or hyphen to appear as text and not affect calculations:
  1. Select the range of cells you want to adjust. ex that entire column
  2. Go to Format > Number > Plain Text.
  3. And the minus signs should display correctly without being calculated.

Check for Automatic Formatting or Corrections

• In Google Sheets, the Auto-correct feature may replace certain characters. To disable auto-corrections:
  • Go to Tools > Preferences and check for any automatic replacements that could be affecting your entries.

Let me know if this helps!

Thanks
Abdullah

Hello @victoriaregina
Thanks for getting in touch and sorry for the trouble,
We’ll take a closer look and help you with the solution in next plugin release asap!

Regards
Abdullah

Hello @seeanimalswild
Thanks for getting in touch,

There is NO feature to remove the entries from the Google Sheet!

Thanks
Abdullah

Hello @alvytit
Thanks for getting in touch,

This should not happen, Can you rebuild or rearrange the sheet columns or create a new sheet tab and connect that tab with the form and checkout and let us know if this helps!

Thanks
Abdullah

Hello @luxworx
Thanks for getting in touch,
This may happens if there is quota limit issue would be there,
You can refer to this
https://www.gsheetconnector.com/how-to-fix-missing-entries-caused-by-google-quota-limits

Hope this helps!

Thanks
Abdullah

Hello @shwetaarya

Can you make sure you added the correct sheetname, sheetid and tabname tabid?

Also make sure sheet is in the same account you have authenticated with

Also add a date column and fill the form and check, alternatively create another sheet tab and connect the new tab with the form to check and also share the screenshot of integration tab and Google Sheet tab where you added sheet details to help you further

Thanks
Abdullah

Hello @shwetaarya
Thanks for getting in touch,

Can you confirm, You had entered the SheetName, SheetID & TabName, TabID of your sheet in settings?
And also this sheet is located in the same account you had authenticated?

Also add all the fieldnames exactly in sheet headers like
first-name, job-title, email
and then also add date – this will show submission date and time as per your site configuration.
Also make sure to name the fields in CF7 with hyphens and avoid using underscores,
Example job_title use with job-title in CF7 Form tabs and then use the same in sheet as well
https://support.gsheetconnector.com/wp-content/uploads/2023/09/Copy-Labels-of-CF7.webp

For more refer to this
https://support.gsheetconnector.com/kb/cf7-gsheetconnector-plugin-settings-free-version

And then let us know if have issues.

Thanks
Abdullah

Hello @chipegoh
Thanks for getting in touch

It looks you might be using the old version of the plugin, can you please update the plugin with the latest version 1.2.19

Additionally you can refer here
https://www.gsheetconnector.com/resolving-the-google-hasnt-verified-this-app-error-during-authentication

Hope this helps! Let us know further

Thanks
Abdullah

Hello @rafacorts
It looks you might be asking about Elementor Forms Google Sheet Connecter,
Please prefer to post here next time,
https://www.ads-software.com/support/plugin/gsheetconnector-for-elementor-forms/

Make sure you entered the field names manually in the sheet, refer to this documentation
https://support.gsheetconnector.com/kb/elementor-forms-gsheetconnector-plugin-settings-free-version

Hope this helps!

Thanks
Abdullah