Monitor sites and compile store sales reports
Commenters built n8n workflows that text when a managed website goes down and that gather text sales reports from 7 stores into Google Sheets using AI. Task: Suggested implementation: Build an n8n workflow to monitor website uptime and send Twilio SMS alerts when sites go offline or recover, using AI to draft the message. Additionally, create a workflow to parse text-based sales reports from multiple stores into structured spreadsheet entries. Human role: Configure initial triggers, verify alert accuracy, and review parsed data for correctness.; tools: n8n. Human role: The original post does not say how a person stayed involved.; limitations: Prerequisites include self-hosted n8n and active Twilio credentials. Operating costs depend on SMS volume and AI token usage. Integration uncertainty exists regarding specific website structures and sales report formats. Human approval is required before sending live alerts or publishing data..
Tools
Published on Agent Work Atlas:
Overview
Commenters built n8n workflows that text when a managed website goes down and that gather text sales reports from 7 stores into Google Sheets using AI.
Workflow
Suggested implementation: Build an n8n workflow to monitor website uptime and send Twilio SMS alerts when sites go offline or recover, using AI to draft the message. Additionally, create a workflow to parse text-based sales reports from multiple stores into structured spreadsheet entries. Human role: Configure initial triggers, verify alert accuracy, and review parsed data for correctness.
Reported result
Actual outcomes are unknown as the source is inaccessible. Proposed acceptance check: Confirm that alerts are sent within 5 minutes of downtime detection and that 95% of sales data fields are correctly mapped to the spreadsheet without manual correction.
Human role
The original post does not say how a person stayed involved.
Limitations
Prerequisites include self-hosted n8n and active Twilio credentials. Operating costs depend on SMS volume and AI token usage. Integration uncertainty exists regarding specific website structures and sales report formats. Human approval is required before sending live alerts or publishing data.
Try it
Act as an automation engineer. I need to set up two n8n workflows. First, a website monitor: Use the HTTP Request node to check [replaceable: list of website URLs] every 5 minutes. If the status code is not 200, trigger a Twilio SMS node to send an alert to [replaceable: phone number]. Use an AI node to generate a concise alert message stating the site name and status. Second, a sales report compiler: Read text files from [replaceable: folder path] containing sales data from [replaceable: number] stores. Use an AI node to extract store name, date, and total sales, then append these as rows to [replaceable: Google Sheet URL]. Before running live, perform a dry run with [replaceable: sample test files] and [replaceable: test phone number]. Show me the output for confirmation. Do not send real SMS or write to the production sheet until I approve the dry run results. If inputs are missing, ask for the specific URLs, file paths, or credentials needed.
Source reports are not independently verified. Publication date is the catalog publication date, not the original article date.