I got new data which is “profits”, need to append into new row in google sheets, but I tried many times.
I’m not sure the row must start with the first row in the google sheet or I can choose the specific location.
Normally appending data isn’t an issue but in this case you appear to have a non standard format. Typically we look for the first empty row which in this case it has correctly found but your data doesn’t start for a few more.
Have you tried setting the first data row and header row fields to match your template?
Hi @Edwin_Wong, I just gave this a go on my end and it appears you’d have to use “Map Automatically” as the “Mapping Column Mode” setting in your Google Sheets node. Otherwise, n8n would only offer columns defined in the very first row of your sheet, regardless of what’s configured under Data Location on Sheet → Header Row. Not quite sure if that’s an expected limitation or a bug though, but perhaps Jon can confirm once he’s back.
For now you’d have to set up your Google Sheets node like so (this is assuming you’re using the latest version of both n8n and the Google Sheets node):
Hi @Edwin_Wong, thanks for sharing your additional screenshot! It seems there is additional data to the left of the previously visible table.
Unfortunately this isn’t a scenario the Google Sheets node currently handles, so I’d suggest you create a separate sheet for your Transaction History table here, without any additional data outside the table.
I found this. It seems like last time can be works.
By the way, based on the link at above. Is it possible to use app script to do this task?
And also, is it possible that I read the data from google sheet for specific range and then I retrieve this range to create a new spreadsheet?