u/-Strawhat--

Hey guys,

I'm a beginner with n8n and this past week I have been trying to create an automation for an ecommerce order/sales management document. (In google sheets)

Currently the workflow fetches all the orders in the specified time and pastes them according to the columns I've set in one sheet.

What I'm having trouble with is, I want it to filter the orders by month and have N8N paste them into the month sheet.

Eg. May 26, June 26.

If the month's sheet does not exist it should create and name the sheet then paste the month's order in it.

I hope I've made it clear.

What's the best way to do this? Is there any guide I should look at?

And how do you guys plan the structure of the workflow?

Thanks in advance.