Workflows / Email, From Sign-Up To Nurture

Enquiry Capture And Follow-Up

Enquiries from a portfolio site wait days for an answer, or get lost.

On enquiry, daily reminderGemini API keyGmailGoogle Sheets

How It Runs

TRIGGEREnquiry FormLOGICConfigGEMINITag With GeminiLOGICPrepare Row AndReplySHEETStore EnquiryGMAILAuto-ReplyGMAILAlert OwnerTRIGGERDaily ReminderCheckLOGICConfig(Reminders)SHEETRead EnquiriesLOGICFind OverdueGMAILRemind OwnerSHEETMark Reminded

Steps

  1. Enquiry FormTrigger
  2. ConfigLogic
  3. Tag With GeminiGemini
  4. Prepare Row And ReplyLogic
  5. Store EnquirySheet
  6. Auto-ReplyGmail
  7. Alert OwnerGmail
  8. Daily Reminder CheckTrigger
  9. Config (Reminders)Logic
  10. Read EnquiriesSheet
  11. Find OverdueLogic
  12. Remind OwnerGmail
  13. Mark RemindedSheet

Control Sheet Tabs

Enquiries

Accounts To Connect

Gemini API keyGmailGoogle Sheets

Run It Yourself

n8n

  1. In n8n, open Workflows, then Import from URL
  2. Paste https://raw.githubusercontent.com/archanacontent/content-marketing-automation-workflows/main/n8n/15-enquiry-capture-follow-up.json
  3. Fill in the Config node and connect the accounts listed above
  4. Activate the workflow

Google Apps Script

  1. Set up the control sheet with the steps on the main page
  2. Runs on its own: On enquiry, reminders every 10 minutes
  3. To run it now, open the Run tab and tick Run now next to No. 15