Filter Google Sheet Contacts, Schedule Outreach, and Update Status

Google Sheets

Complex Trigger

This n8n workflow operates on a schedule to automate contact management and outreach. It begins by reading a list of contacts from a specified Google Sheet. Utilizing a 'Code' node, the workflow applies custom filtering logic to identify contacts that meet specific criteria for action, such as those not recently contacted or requiring a follow-up. After filtering, the workflow proceeds to initiate an action for the selected contacts (implied to be an outreach, like sending an email, given the 'To email?' reference). Crucially, once an action is taken, the workflow updates the original Google Sheet. This update records the 'last contacted' or 'first emailed' timestamp, along with the row number, ensuring accurate tracking and preventing duplicate actions for the same contact within a short period. This automation is ideal for maintaining consistent communication and managing lead pipelines efficiently.