How to delete row_number column from Google Sheets reading

Questions
1

Hello! I’m trying to read my Google Sheets table to insert/update my MySQL.
The problem is that I can’t use automap columns because Google Sheets node export “row_number” column, and I don’t have it in MySQL table, so there’s a error there.

How can I not import that column from Google Sheets or delete before updating MySQL?

3

Hi @Igor_do_palido_ponto, welcome to the community :tada:

There’s two options here:

  1. To define a specific data structure in n8n you could use the Set node. Here’s a quick example workflow getting rid of a row_number field from Google Sheets by simply re-defining the fields to keep:
  1. To just delete a field you’d have to use the Code node, allowing you to use the JS delete operator. Here’s an example:

Hope this helps :slight_smile:

1 Like
4

Thank you!! it worked

5

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