Baserow -> N8N -> Google Sheets: only values (without ID, color, etc.)

Technical Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

1.31.1

If you are self-hosting, which installation method do you use to run Baserow?

BaseRow Cloudron App 1.27.0

What are the exact steps to reproduce this issue?

Hello!

I have managed to connect a BaseRow table with Google Sheets via n8n.
Single Line Text fields look nice in Google Sheets, but for all other field types the Google Sheet cells don’t just show the value(s), but also IDs, colors, etc.
How can I get only values in Google Sheets?

Many thanks!

2

@joffcom could you please jump in here?

3

Hey @Mary-Lou

It could be that the fields from Baserow contain more data depending on the field type. If you look at the data from the node in n8n you can use a Set node between the 2 to select the values instead of the other items.

4

Sounds very good. Could you perhaps translate “use a Set node” into actionable steps for a dummy?

5

Hey @Mary-Lou

In n8n after your Baserow Node add an Edit Fields node from the nodes panel, run the Baserow node and check the output items to see if it matches what you are expecting if they have different content you can use the edit fields node to change it.

6

Thank you, @joffcom.
Adding “.value” to the fields in question in the Edit Fields node is the solution.

1 Like
7

Nice solve @Mary-Lou :raised_hands: