[Google Sheets] Triggering fields refresh

Questions
1

Hello,

I am trying to sync budibase with google sheets but I am running into an issue.
Since the tables are changing each time, I always trigger the error to refresh fields.

Here is my workflow:

I don’t think I ran into this issue before.

Thank you for your help!

2

Hello @Joachim_Brindeau
I think the G Sheet node requires a defined schema when mapping columns (even in “Auto Map” mode).
So when your Budibase table changes n8n still tries to match it against the previous static schema cached in the workflow and that’s why you need to manually refresh fields.

So, i think you can normalize field names before writing

Use a Set or Edit Fields node before the Google Sheets node to:

  • Rename incoming fields to match the sheet headers (e.g., always map name_budibase → name)
  • Ensure consistent formatting

OR

Use Google Sheets API via HTTP Request
If the structure is fully dynamic and unknown in advance, the built-in Google Sheets node won’t handle it well.

In that case:

  • Use an HTTP Request node to call the Google Sheets API directly
  • Construct the payload manually based on the fields in each record
  • This allows you to dynamically insert data even if the schema changes on every run
1 Like
3

I actually found a quick patch here:

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

2 Likes
4

Should I create a Github issue for this? As it appears to be a regression.

5

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