I have a workflow which is doing what I want it to (update a spreadsheet and send a Slack message).
However, the spreadsheet I have has multiple tabs (i.e. “sheets”) within it, and at times I will need data taken/added to different tabs in that sheet.
The Google sheet reader node and update node can only select one sheet within a Google spreadsheet document at a time.
How can I have my workflow parse through each sheet for the needed info?
NOTE: I am new to n8n and not extremely technical. Please try and avoid jargon/use simple explanations, thanks.
if you know the name of the sheets couldnt you make it parse each one separately with separate workflows into a merge node and do what you want with each or merge together into one.
Which part? you can also ask a LLM; explain you are using n8n and which nodes, often this is enough or search existing templates on the n8n website and copy /paste into your workflow.
Specifically the parsing through different tabs in the sheet. I’ll try LLM but they haven’t proven great yet for these kinds of questions in my experience
Yes, something like that seems like the perfect solution.
When you say loop, what do you mean? I am pretty much a beginner to this stuff. I know what looping is in general but not what that would look like in n8n.
I have to parse three sheets. This starts by sending in info about the first sheet to the Google Sheets node. If it doesn’t match, the loop sets the second sheet as the input for the Google Sheets node. If it doesn’t match… well, it just goes back into the loop, and keeps trying to set the input as the second sheet.
I need to be able to try a third sheet if both the first sheet input and the second sheet input fail. What am I missing?
This is going beyond basic support now: we’ve created a new category for help with designing workflows, and I’ve moved your question there: Help me Build my Workflow. Find out how this category works by reading this topic.
