One shared ‘last contacted’ sheet that every reminder, follow-up and review request checks before sending, so a customer never gets a pile-up of messages. Anything held back is queued for a later day.
Tools that do this: Google Sheets or Airtable, Zapier, Make or n8n, Twilio or your email tool
You are helping a small business set a contact-frequency policy for its automated customer messages. Based on the details below, write a one-page rule set an office manager can follow and a non-developer can build in Zapier, Make or n8n. Business type: [business type] Automations that message customers: [e.g. appointment reminders, quote follow-ups, review requests, win-back emails] Channels used: [text, email] Preferred minimum gap between marketing-type messages: [number of days] Output: (1) a priority ranking of the message types, (2) which types are exempt from the limit and why, (3) the exact columns for a 'last contacted' table, (4) the check to run before each send in plain if-then wording, and (5) what happens to held messages. Keep it under 300 words and do not recommend contacting anyone who has opted out.