Update Google Sheet with CSV file

Questions
1

Hello all,

I try to update a google sheet with a csv file but without success and I don’t get an error.
I can clear or read the google sheet. What’s wrong ?

Information on your n8n setup

  • n8n version: 0.171.1
  • Database SQLite
  • Running n8n via Docker
2

Hey @Jaribu,

Welcome to the community :tada:

I had a quick look at your workflow and below are my thoughts:

  1. Does the Google Sheet and the CSV return by the Spreadsheet file have the same column names? If not, you will have to use either the Set node or the Rename Keys node to map the values correctly.
  2. Did you try without using the Append operation instead of the Update operation?
3

Hey @harshil1712,

Thank you for the welcoming :slight_smile:

  1. Yes, same column names
  2. I just tried Append operation and it works.

But now how I can clean my SpreadSheet to keep only column names to make Append operation again ?
In fact, I want to update this spreadsheet every day