Google sheet output

Questions
1

Describe the problem/error/question

i don’t know why but when my google sheet node finish work she say output :white_check_mark:
and i can see all data i try to write
but when i open my google sheet the data i try to write are not here

What is the error message (if any)?

no error every thing seem to be work

Please share your workflow

Share the output returned by the last node

[
  {
    "Mois": "Janvier",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Janvier",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Janvier",
    "Loyers": "640,71",
    "Charges locataire": "216,71",
    "Honoraires": "18,23",
    "TVA": "11,43",
    "Ass loyers": "18,50"
  },
  {
    "Mois": "Janvier",
    "Loyers": "412,17",
    "Charges locataire": "100,00",
    "Honoraires": "13,77",
    "TVA": "6,97",
    "Ass loyers": "11,27"
  },
  {
    "Mois": "Janvier",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "14,38",
    "TVA": "8,38",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Février",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Février",
    "Loyers": "412,17",
    "Charges locataire": "100,00",
    "Honoraires": "13,77",
    "TVA": "6,97",
    "Ass loyers": "11,27"
  },
  {
    "Mois": "Février",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Février",
    "Loyers": "640,71",
    "Charges locataire": "216,71",
    "Honoraires": "18,23",
    "TVA": "11,43",
    "Ass loyers": "18,50"
  },
  {
    "Mois": "Février",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "14,38",
    "TVA": "8,38",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Mars",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Mars",
    "Loyers": "412,17",
    "Charges locataire": "100,00",
    "Honoraires": "13,77",
    "TVA": "6,97",
    "Ass loyers": "11,27"
  },
  {
    "Mois": "Mars",
    "Loyers": "651,88",
    "Charges locataire": "216,71",
    "Honoraires": "18,24",
    "TVA": "11,44",
    "Ass loyers": "18,74"
  },
  {
    "Mois": "Mars",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Mars",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "14,38",
    "TVA": "8,38",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Avril",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Avril",
    "Loyers": "412,17",
    "Charges locataire": "100,00",
    "Honoraires": "9,25",
    "TVA": "2,45",
    "Ass loyers": "11,27"
  },
  {
    "Mois": "Avril",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Avril",
    "Loyers": "651,88",
    "Charges locataire": "227,88",
    "Honoraires": "18,24",
    "TVA": "11,44",
    "Ass loyers": "18,74"
  },
  {
    "Mois": "Avril",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "14,38",
    "TVA": "8,38",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Mai",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Mai",
    "Loyers": "418,21",
    "Charges locataire": "100,00",
    "Honoraires": "13,85",
    "TVA": "7,05",
    "Ass loyers": "11,40"
  },
  {
    "Mois": "Mai",
    "Loyers": "651,88",
    "Charges locataire": "239,05",
    "Honoraires": "18,24",
    "TVA": "11,44",
    "Ass loyers": "18,74"
  },
  {
    "Mois": "Mai",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Mai",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "14,38",
    "TVA": "8,38",
    "Ass loyers": "25,69"
  },
  {
    "Mois": "Juin",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Juin",
    "Loyers": "426,57",
    "Charges locataire": "100,00",
    "Honoraires": "21,47",
    "TVA": "14,67",
    "Ass loyers": "11,58"
  },
  {
    "Mois": "Juin",
    "Loyers": "651,88",
    "Charges locataire": "250,22",
    "Honoraires": "18,24",
    "TVA": "11,44",
    "Ass loyers": "18,74"
  },
  {
    "Mois": "Juin",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Juin",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "6,00",
    "TVA": "0,00",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Juin",
    "Loyers": "698,00",
    "Charges locataire": "143,00",
    "Honoraires": "6,00",
    "TVA": "0,00",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Juillet",
    "Loyers": "1396,00",
    "Charges locataire": "286,00",
    "Honoraires": "22,76",
    "TVA": "16,76",
    "Ass loyers": "22,96"
  },
  {
    "Mois": "Juillet",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Juillet",
    "Loyers": "426,57",
    "Charges locataire": "100,00",
    "Honoraires": "14,81",
    "TVA": "8,01",
    "Ass loyers": "11,58"
  },
  {
    "Mois": "Juillet",
    "Loyers": "651,88",
    "Charges locataire": "261,39",
    "Honoraires": "19,22",
    "TVA": "12,42",
    "Ass loyers": "18,74"
  },
  {
    "Mois": "Juillet",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Juillet",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Juillet",
    "Loyers": "103,51",
    "Charges locataire": "9,50",
    "Honoraires": "8,34",
    "TVA": "1,54",
    "Ass loyers": "0,00"
  },
  {
    "Mois": "Juillet",
    "Loyers": "426,57",
    "Charges locataire": "100,00",
    "Honoraires": "14,81",
    "TVA": "8,01",
    "Ass loyers": "11,58"
  },
  {
    "Mois": "Juillet",
    "Loyers": "651,88",
    "Charges locataire": "261,39",
    "Honoraires": "19,22",
    "TVA": "12,42",
    "Ass loyers": "18,74"
  },
  {
    "Mois": "Juillet",
    "Loyers": "0,00",
    "Charges locataire": "0,00",
    "Honoraires": "0,00",
    "TVA": "0,00",
    "Ass loyers": "0,00"
  }
]

this is exactly what’s i expect but it’s do not write in my sheet
i wish you understand my bad English thanks you for your answer

Information on your n8n setup

  • n8n version:1.52.2
  • Database (default: SQLite):SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):npm
  • Operating system:debian
2

Hi @charly_angot

I tried to reproduce your problem, but seems working fine for me…

Could you share your whole workflow for better context? And ideally also a screenshot of the google sheet data that you are trying to match against, that would help with the debugging :slight_smile:

3

hi thanks you for your help :grin:

i thinks you can see my workflow in the first post
i will post some screen

https://i.imgur.com/Bja0BDK.png

https://i.imgur.com/DQwgCxc.png

https://i.imgur.com/Hc3e5Eu.png

when i try my workflow with only flew file for test him work and him write on the sheet, but when i try to do it with all file as you can see on the first screen the workflow work but it do not write anything on the sheet.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.