How to Log Auto-Responses to Emails in Google Sheets & Automatically Delete Old Entries

[Suna]

Hi everyone,

I’m fairly new to n8n, and I’m building a workflow that automatically sends responses to incoming emails. I also want to log each auto-response in a Google Sheet to keep track of what’s been done, in case I need to review it later.

To avoid the log file becoming too large and filling up my Google Drive, I’d like part of the workflow to:

Save successful auto-responses as new rows in a Google Sheet.
Delete the oldest rows if the sheet exceeds a certain size (e.g., keep only the last 100 entries).

I’m comfortable using the Google Sheets node to append and delete rows, but I’m not sure how to:

Track successful email auto-responses within the workflow.

Count the current number of rows in the sheet.

Identify and remove the oldest rows efficiently.

Any help or examples would be really appreciated!

[bartv]

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.