{"product_id":"uscis-case-tracker-automation-in-n8n-google-sheets-email-alerts","title":"USCIS Case Tracker Automation in n8n: Google Sheets + Email Alerts","description":"\u003ch3\u003eAutomatically track USCIS case status changes from Google Sheets—and notify your team by email\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors immigration cases in your \u003cstrong\u003eGoogle Sheets “Case Tracker”\u003c\/strong\u003e, polls USCIS case-status pages for active receipt numbers, and sends \u003cstrong\u003eemail alerts via SMTP\u003c\/strong\u003e when statuses change or when \u003cstrong\u003eRFE deadlines\u003c\/strong\u003e are approaching. Each run updates your sheet with the latest results, so your tracker stays current.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 6am\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from the Google Sheets “Case Tracker” sheet and branches into two paths: status polling and \u003cstrong\u003eRFE-deadline monitoring\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to active cases\u003c\/strong\u003e (not closed), then submits each receipt number to the USCIS case-status endpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the returned HTML\u003c\/strong\u003e to extract the current USCIS status text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares newly polled status\u003c\/strong\u003e vs. the last saved status to detect changes, including RFE issuance\/resolution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates RFE deadline dates\u003c\/strong\u003e and records a \u003cstrong\u003elast-checked timestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOn status changes, prepares a client email and runs it through an \u003cstrong\u003eExecute Workflow compliance\/opt-out guardrail\u003c\/strong\u003e; the email is sent via \u003cstrong\u003eSMTP\u003c\/strong\u003e only if approved.\u003c\/li\u003e\n  \u003cli\u003eIdentifies unresolved RFEs with deadlines within the configured lead time and emails an \u003cstrong\u003einternal alert\u003c\/strong\u003e to the firm attorney address via SMTP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates\u003c\/strong\u003e the matching Google Sheets row by receipt number with the latest status, RFE fields, and check timestamps (even if no email was sent).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLaw firms or immigration teams who need reliable \u003cstrong\u003eUSCIS case tracking\u003c\/strong\u003e without manual checking.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an \u003cstrong\u003en8n workflow marketplace\u003c\/strong\u003e solution for Google Sheets-based operational dashboards.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing client communications that require opt-out\/compliance guardrails before sending email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads from the “Case Tracker” sheet and updates rows by receipt number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUSCIS case-status polling\u003c\/strong\u003e: posts receipt numbers to the USCIS case status endpoint and parses HTML for status text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, code, no op, filter, email send, sticky note, plus an \u003cstrong\u003eExecute Workflow compliance\/opt-out guardrail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSMTP email delivery\u003c\/strong\u003e: used for both client notifications (conditionally) and internal attorney alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTo set up, add Google Sheets credentials and configure \u003cstrong\u003eIMMIGRATION_CASE_TRACKER_SHEET_ID\u003c\/strong\u003e to the spreadsheet containing the “Case Tracker” sheet.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275663167667,"sku":"N8N-21469","price":76.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JKbn6ZiN6fzormoQN8DNB_e6roBoA6.png?v=1792833107","url":"https:\/\/buyflowscripts.com\/products\/uscis-case-tracker-automation-in-n8n-google-sheets-email-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}