How to Create google sheet and add data?

Questions
1

Hi all,
i’m able to append data to an existing sheet but
I don’t understand how to create a google sheet and add some row.
I use google create for the spreadsheet, it’s OK
retrieve data from postgres, it’s ok
but how to create column header key to append data in this new spreadsheet ??

I miss something somewhere ?

Thanks

2

Welcome to the community @Chris_Doudet!

Yes, there is currently sadly no easy way to do that yet. You would have to go through RAW data to do it.

In the following example, you can define the columns in the Set node, comma-separated. Be however aware that this overwrites the data of the whole sheet. Probably not a problem in your case, as it is empty, but still wanted to have it mentioned.

2 Likes
3

Perfect,
thanks

4

You are welcome. Have fun!

5

if I understand correctly, this scenario can be used to update data. how do i add a row?

6

Hey @Max_T,

You can add a row using the Append operation.

7

@jan is there an updated version of this flow?

I tried following your steps and adapting it to the current versions of the actions, but I’m not having much success.

8

Unfortunately, the current version of the Google sheets node doesn’t support the raw operation anymore. But you can copy&paste the previous version from this example into your workflow