Quick overview
Quick overview This workflow runs every weekday morning to scan an enquiries tracker in Google Sheets, email each owner a single nudge for enquiries that have gone quiet, and optionally send a summary digest email via Gmail showing open enquiries by stage and which ones need chasing. How it works Runs on a weekday schedule at 08:30 (or manually) and loads configuration values like tracker sheet/tab, open stages, chase thresholds, and email settings. Reads all rows from the configured Google Sheets tracker tab and analyzes which enquiries are still in an open stage, how long they have been quiet, and how many chases have already been sent. Groups stalled enquiries by owner email so each owner receives one consolidated nudge listing their quiet enquiries and the next actions. Sends the nudge emails through Gmail (or only produces a preview when sending is disabled), then updates Google Sheets to increment “Chases sent” and append a timestamped note for each nudged enquiry matched by Ref. Builds a morning digest email that counts open enquiries by stage and lists the quiet ones (oldest first), including a warning list for enquiries with no owner email. Sends the digest through Gmail only when enabled by configuration and sending mode, otherwise outputs a preview instead. Setup Add Google Sheets credentials and set the tracker spreadsheet ID and tab name in the config so the workflow can read and update your tracker. Add Gmail credentials for sending owner nudges and the optional digest, and set FROM_NAME and REPLY_TO in the config if needed. Ensure your Google Sheet has the required headers (at minimum Ref, Stage, Last touch/Received, Chases sent, Notes, Owner email) and that Ref is unique per enquiry. Fill in owner email addresses (in the sheet and/or the config’s area owner list) and set DIGEST_TO if you want the morning digest (leave it blank to disable the digest). Test safely by running with TEST_RUN = true (optionally set TEST_EMAIL to route all emails to yourself), then set TEST_RUN = false and activate the schedule. An n8n automation workflow template by Atharva Ashtekar.
Atharva Ashtekar
web
free
Others in the same category, ranked by how often they are opened.
