[Google Sheets] Triggering fields refresh

[Joachim_Brindeau]

I actually found a quick patch here:

Google Sheets error - Column names were updated after the node's setup

It makes impossible to use the workflow for multiple sheets. In my case, the sheetId is dynamic and passed as an argument into the workflow, so the same workflow is used to write rows in different sheets with different schemas. I expected that “Map Automatically” means that it reads the columns of the sheet during runtime, but as I see now, it caches them during build time and tries to reuse whatever cached schema independently of the actual sheet referenced by sheetId. Hope it will be fixed s…

I managed to downgrade the node to version 3 and it worked, despite losing some functionnality.

It will have to do for now!
Thank you for your help