Google Sheets as a Dynamic Task Queue UI - n8n Workflow

Automation developers needing external input controls for their logic.
Teams who want a simple spreadsheet-based task dashboard.
Users looking for advanced n8n templates integrating Google Sheets for status tracking.
Anyone aiming to build a controlled, asynchronous execution model within n8n.

This n8n workflow demonstrates a powerful architectural pattern: using Google Sheets as a dynamic task queue or UI layer for your automation engine. Instead of relying solely on an immediate n8n trigger, this setup treats the spreadsheet as a controlled input source. The n8n workflow is triggered (typically on a schedule or manually), identifies rows in the Google Sheet marked 'READY' using a specific Google Sheets n8n node filter, processes the data row-by-row, and then updates the row status to 'DONE'. This technique is excellent for managing large batches, providing a clear visual UI for progress tracking, and ensuring robust, idempotent operation within your n8n automations.

Step 1: Initiation: The process starts via the manual n8n trigger, ‘When clicking ‘Execute workflow’’ (which can easily be swapped for a Schedule n8n trigger).
Step 2: Read Task Queue: The Read Google Sheets n8n node connects to the target sheet. Crucially, it filters the data to only retrieve tasks where the Status column is marked READY, effectively fetching the pending tasks for the n8n workflow.
Step 3: Itemization: The Loop Over Items n8n node (Split In Batches) separates the incoming spreadsheet rows. This ensures that the subsequent processing logic executes individually for each item fetched, maintaining a clear flow of control.
Step 4: Execute Logic: The Edit Fields n8n node simulates the core logic execution. It securely captures the necessary unique identifier (rownumber) and sets the resulting Status field to DONE, along with any computed result (e.g., calculating the length of the 'Color' field).

• Step 5: Status Update: The final Update Google Sheets n8n node takes the processed data. It utilizes the stored rownumber as the matching key to update the exact original row in the sheet, marking the task as complete in the Google Sheets UI and preventing reprocessing in the next run of the n8n workflow.

Importing the n8n template: Copy the provided n8n workflow JSON and paste it into your n8n canvas using the 'New' -> 'Import from JSON' option.
Google Sheets Credentials: This n8n workflow requires Google Service Account credentials for secured read/write access. You must configure a new Google Service Account credential and ensure the associated email has editor access to your target spreadsheet.
Spreadsheet Setup: Create a Google Sheet that includes the necessary columns like Color and Status. Update the Document ID and Sheet Name parameters in both Google Sheets n8n node instances (Read Google Sheets and Update Google Sheets) to correctly link to your spreadsheet.
Execution: After setting up credentials and sheet parameters, save the n8n workflow and click the 'Execute workflow' button on the manual n8n trigger to initiate testing.

When clicking ‘Execute workflow’ (Manual Trigger): The starting n8n trigger point for this n8n workflow. It allows manual testing and execution of the entire flow.
Read Google Sheets:
Function: Reads the input task data.
Key Configuration: Uses a filter to only retrieve rows where the Status column value is set to READY. This is the core filtering mechanism of this specific n8n node.
Loop Over Items (Split In Batches):
Function: Essential for flow control, ensuring that each data row is handled independently by the subsequent processing nodes in the n8n workflow.
Edit Fields (Set):
Function: Simulates the actual backend processing or calculation. It captures the rownumber needed for the update step and writes the final processing status (DONE).
Update Google Sheets:
Function: Writes the processed status and results back to the spreadsheet UI.
* Key Configuration: The operation is set to Update, using the rownumber field retrieved earlier as the unique identifier to accurately target and modify the correct row in the sheet.