Update Contact Scrape Status from Invalid back to Pending

Workflow Overview: Contact Status Refresher Purpose & Automation Value This workflow serves as an automated maintenance task for a lead or contact list stored in Google Sheets. Its primary function is to periodically re-evaluate contacts that were previously marked as having an "invalid\_email". The core value of this automation is in maximizing the potential of a lead list. Email validation is not always permanent; a temporary server issue could cause a valid email to fail, or a contact might get a new email address at the same company. By automatically resetting the status from "invalid\_email" back to "pending" every month, this workflow ensures these contacts are re-processed by other scraping or enrichment workflows. This prevents the permanent loss of potentially valuable leads and automates the tedious manual process of list cleanup and re-verification. Technologies Used - n8n: The automation platform coordinating the process. - Google Sheets: Used as the database to store and manage contact information and their processing status. Node-by-Node Breakdown H3: Schedule Trigger: Monthly Reset - Node Type: Schedule Trigger - Function: This node initiates the entire workflow. It is configured to run automatically on a fixed schedule. - Configuration: The workflow is set to trigger every 4 weeks, specifically on a Tuesday at 8:00 AM. This periodic execution ensures the contact list is consistently maintained without any manual intervention. H3: get invalid email rows: Find Invalid Contacts - Node Type: Google Sheets - Function: This node connects to a specific Google Sheet named "apollo ai leads" and retrieves rows that meet a specific condition. - Configuration: It is set to read "Sheet1" and apply a filter to fetch only the rows where the contacts_scrape_status column contains the value invalid_email. The output of this node is a list of all contacts that need their status reset. H3: update_to_pending: Re-queue Contacts for Processing - Node Type: Google Sheets - Function: This is the final action node. For every contact received from the previous step, it updates their record in the same Google Sheet. - Configuration: - Operation: update.