Daily Squarespace low-stock alerts in Slack and Asana

By General Input

Every weekday at 7am, scan your Squarespace store for low and out-of-stock items, file reorder tasks in Asana, and post a single rollup in Slack.

Integrations

  • Squarespace Forms
  • Asana
  • Slack

Type

Agentic Task

Categories

  • Operations

Build me an agent workflow that runs every weekday at 7am (cron trigger) and watches my Squarespace store for low-stock and out-of-stock variants, then files reorder tasks in Asana and posts a rollup to Slack.

Each run the agent should:

1. Call the Squarespace Forms operation "Retrieve All Inventory" to pull the current quantity and SKU for every product variant. Paginate until done.

2. Call the Squarespace Forms operation "Retrieve All Products" so it can map each variant ID back to a human-readable product name (and confirm SKU). Cache the mapping for the run.

3. For every variant whose quantity is at or below a configurable threshold (default 5 units), decide a priority: "critical" if quantity is 0, "high" if quantity is 1 or the variant is at most 25% of the threshold, otherwise "normal". Write a one-paragraph reorder rationale that mentions the product name, variant, SKU, current quantity, and how close it is to zero.

4. Skip any variant for which the agent has already created an Asana reorder task in the last 7 days. Persist this de-duplication state across runs (keyed by SKU or variant ID) so the same item doesn't get re-filed every morning. Make the window configurable.

5. For each remaining low-stock variant, call the Asana operation "Create a Task" in a configurable Asana project. The task name should read like "Reorder: <product name> (<variant>) — <SKU>". The task description should include the SKU, current quantity, threshold, priority, and the one-paragraph rationale. Set the due date to 3 business days from today. Allow an optional default assignee.

6. After all tasks are created, call the Slack operation "Send a Message" to post a single rollup message in a configurable channel. The message should list every item queued this run (product, variant, SKU, current quantity, priority) grouped by priority, with a short headline like "Reorder load for <date>: N items". If nothing crossed the threshold, post a brief "All variants above threshold" note instead.

Configurable inputs the workflow should expose: low-stock threshold (default 5), de-duplication window in days (default 7), Asana project ID, optional Asana assignee, business-day offset for due date (default 3), Slack channel, and the cron schedule (default 7:00 local time, Mon–Fri).

Operational rules: handle Squarespace pagination and 429 rate limits with backoff, treat missing or null inventory entries as 0, never throw on a single bad variant (log and continue), and make the rollup message succeed even if some Asana task creations failed (report which ones failed in the rollup).

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentWin back LiveChat visitors whose chats went unansweredChat quality review board for LiveChat support leadsWin back no-show and cancelled appointments every morningLive Loop returns analytics with product-level drill-downNewsletter pre-flight and approval board for Mailjet sendsTurn a prospect spreadsheet into personalized sequence enrollmentsMailjet email delivery lookup console for support teamsCatch feature flags that never got switched on in productionKajabi customer support console for member access fixes