Automate Google Sheets Row Processing with n8n

What This Automation Does

This workflow runs every 5 minutes to get all rows from a Google Sheet.
It checks if each row has a timestamp in the "Processed" column.
If no timestamp, it marks the row as new and does a task on it.
Then it sets the current time in the "Processed" column to stop redoing the same row.
This stops doing the same work twice and keeps track of what was handled already.
You can also run it by hand when you want.
This way, the workflow saves hours and helps respond faster to new entries.

Step-by-Step Guide to Build the Workflow ⚙️

Using the Workflow in Production

1. Download the workflow file by clicking the Download button on this page.
   
2. Open the n8n editor where you create workflows.
   
3. Click the menu and choose "Import from File" to upload the downloaded workflow.
   
4. After importing, add the required Google Sheets credentials using OAuth2.
   
5. Update the Sheet ID to the correct Google Sheet you want to work with.
   
6. If the workflow has any emails, channels, or table names, replace them with your own.
   
7. Test the workflow by clicking the Manual Trigger node and running it once.
   
8. Check if rows without timestamps get processed and marked correctly.
   
9. Once tested, toggle the workflow to "Active" to run automatically every 5 minutes.
   
10. If running on your own server, use this self-host n8n link to help with setup.
    

Prerequisites ⚙️

• n8n account: To create and edit workflows.
  
• Google Sheets account: To access and update the sheet.
  
• Google Sheet: Must have a "Processed" column for marking.
  
• Basic n8n knowledge: Know how to use Manual Trigger, Interval, Google Sheets, If, and Set nodes.
  

Inputs, Processing Steps, Output

Inputs

• Google Sheet rows pulled every 5 minutes.
  
• Each row includes a "Processed" column.
  

Processing Steps

• Check if "Processed" is empty for each row.
  
• If empty, do a task on that row (placeholder for real action).
  
• Add current timestamp to "Processed" column for that row.
  
• Update the Google Sheet row to save timestamp.
  

Output

• Rows marked as processed with a timestamp.
  
• New rows get handled exactly once.
  
• The workflow prevents redoing the same rows again.
  

Customizations ✏️

• Swap the placeholder node with an Email Send node to inform your teammates when new rows appear.
  
• Change the Interval node to run more or less often, like every minute or every 10 minutes.
  
• Use extra conditions in the If node to only process rows that meet other rules.
  

Troubleshooting

• Problem: Google Sheets node can't connect.
  Cause: Wrong OAuth2 login or expired token.
  Fix: Re-login your Google account in n8n credentials.
  


• Problem: The If node always skips to false.
  Cause: Wrong column name or expression error.
  Fix: Double-check the "Processed" spelling and {{$json["Processed"]}} expression.
  

Pre-Production Checklist ✅

• Make sure Google Sheet has a "Processed" column.
  
• Run the workflow manually to confirm it processes rows one time.
  
• Make sure the Interval fires every 5 minutes.
  
• Test with some new and processed rows so results are visible.
  
• Create a backup of Google Sheet before running any updates.
  

Deployment Guide

Turn on the workflow by switching it to "Active".
Watch the logs in n8n to see rows being handled.
If errors show up, check troubleshooting tips.
Choose either n8n cloud or self-host n8n for where to run.

Conclusion

This workflow stops manual checking of Google Sheet rows.
It marks rows so each handles once and saves work time.
You get faster, more accurate response to new data.
Try adding email alerts or CRM updates next.
Explore n8n nodes to build more helpful flows.