Hello,
I have a simple workflow, which clears specific google sheets range (columns A:I), get data from SQL and append in google sheet document.
The issue is, that data is added from first empty row. I want workflow to add data to specific range (also columns A:I as clear sheet works)
How to do this?
It looks like your topic is missing some important information. Could you provide the following if applicable.
Hi @Mateusz,
Welcome to the community! 
Just to make sure I understood - you are able to successfully clear out the range you intended (from A2 to I40), but when you try to populate that range with new data it gets automatically added to A1. But you would want it added to A2:I40 - the cleared range?
Not really. I want to add new data from cell A1, but its beeing added from cell A34 instead, because first fully empty row is row 34.
Does anyone has an idea how to do this?
You need to clear out the cells in columns J+K too.
Nah, the thing is that I do not want to do this. I want to keep those kolumns and valuse in those columns. I want to paste new data starting from cell A1. There is no way to force n8n workflow to do this? Same as I am indicating which range should be cleared.
Right! Well, in that case you can’t use the append action since that looks for the first empty row to add new data to. You could try using the update action, but this would require some column value to identify the row you want to insert your data on. It looks like you don’t have that yet.
I do not think that update will be the solution here, because the data which I want to inster, will be 50% old IDs and 50 new IDs, so as far as I understand, update won’t be able to add those 50% of new IDs. Or am I wrong?
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
