Error Number Google Sheet --> NOTION

How To
1

Good morning,

I have a Google Sheet file with information such as positive and negative percentages and decimal numbers. I created a Notion page, I would like to place the data on the page but as soon as I try to map a number it doesn’t work.

“Failed to map ‘fields.%3DyOg’: function ‘parseNumber’ exited with an error! “ee” is not a valid number or uses an inappropriate separator. »

Bonjour,

J’ai un fichier Google Sheet avec des informations telles que des pourcentages positifs et négatifs et des nombres décimaux. J’ai créé une page Notion, je voudrais placer les données sur la page mais dès que j’essaie de mapper un nombre, cela ne fonctionne pas.

« Échec du mappage de « fields.%3DyOg » : la fonction « parseNumber » s’est terminée avec une erreur ! « ee » n’est pas un nombre valide ou utilise un séparateur inapproprié. »

2

Hello, Nicolas,

The error you encountered ("ee" is not a valid number or uses an inappropriate separator) suggests that Make.com (or the Notion API) is unable to correctly process numerical values from Google Sheets due to:

  1. Number format in Google Sheets – Potential issues with decimal or thousand separators, such as:

    • In English, the decimal separator is a period (1.23), whereas in some European locales, it is a comma (1,23).
    • If Make expects one format but your data is in another, it may not recognize the number.

  2. Invalid characters in data – Some cells may contain text instead of numeric values, for example:

    • Extra characters like "ee" or other non-numeric symbols may have been mistakenly inserted.
    • The cell format might be set to “Text,” even if it visually appears as a number.

  3. Special characters or percentage signs – If your data includes %, $, or other symbols, Make might not recognize them as numbers.

How to Fix:

1. Check the data format in Google Sheets

  • Select the relevant columns → Format → Number → Number (or Decimal).
  • If working with percentages, use Format → Number → Percentage to ensure correct recognition.

2. Remove unnecessary characters

  • Select all numbers and use Find and Replace (Ctrl + H or Cmd + H on Mac):
    • Remove spaces ( ).
    • Remove non-numeric symbols (e.g., "ee").

3. Convert text to numbers

If numbers are still not recognized, use this formula in a new column:

=VALUE(A1)

This forces Google Sheets to interpret values as numbers.

4. Ensure the correct separator is used

  • If Make expects a decimal point (.) but your data uses a comma, apply:
    =SUBSTITUTE(A1, ",", ".")
  • If commas are used as thousand separators, remove them:
    =SUBSTITUTE(A1, ",", "")

5. Check number processing in Make.com

  • If you’re using parseNumber(), try specifying the locale explicitly, e.g.:
    parseNumber(YourField; "en")
  • Verify the values in the Watch Google Sheets module before sending them to Notion.

After completing these steps, try sending the data to Notion again. If the issue persists, check specific values that fail to process and adjust settings accordingly.