Feature Request: Force Text Format (‘ apostrophe) for Google Sheets Integration

Hi Forminator Team,

I am experiencing a critical data loss issue with the Google Sheets integration when processing long numeric strings. Specifically, I am dealing with national Cadastral numbers which are 17 digits long.

The Technical Issue: When Forminator sends these numeric strings to Google Sheets, they are interpreted as integers (even though they are added as text fields and not numeric fields in forminator form). Because Google Sheets follows the IEEE 754 standard (64-bit floating point), it loses precision after the 15th digit, replacing subsequent numbers with zeros (e.g., 12329082498234188 becomes 12329082498234100).

Reference to a Previous Ticket: I am aware of a similar ticket regarding this issue: https://ww.wp.xz.cn/support/topic/forminator-entries-in-google-sheet-are-not-getting-populated-in-the-correct-form/

In that case, the support team suggested: “add any – even just one, at start or end – non-digit character to the voucher code.”

Why this workaround is NOT applicable here: Unlike voucher codes, these are official, state-assigned legal identifiers used in company registration documents. I cannot freely interpret or modify these numbers by adding non-digit characters, as it would invalidate the legal integrity of the documents and the registration process. The data must remain purely numeric and exactly as entered by the user.

Proposed Solution: Could you please add an option in the Google Sheets integration settings to “Force Text Format” for specific fields?

Technically, this can be achieved by allowing a toggle that prepends a single quote (') to the value during the API call. This is the standard way to force Google Sheets to treat a cell as “Plain Text,” preserving every digit exactly as sent.

This would be a massive improvement for any user dealing with:

• National ID numbers / Cadastral codes
• IBANs that are purely numeric in some regions
• Long serial numbers for inventory

I hope you can consider this for your development roadmap, as it would solve a persistent limitation of the current integration.

Until such a feature is implemented, is there any filter or hook I could use to programmatically prepend the apostrophe to these specific fields before they are dispatched to the Google Sheets integration?

Best regards,
Elvijs