Daily Squarespace low-stock alerts in Slack and Asana
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.
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).
What does this prompt do?
- Checks your Squarespace store inventory every weekday morning and flags any product variant that has dropped below your reorder threshold.
- Files a reorder task in Asana for each low item, with the product name, SKU, current quantity, a short reorder rationale, and a due date three business days out.
- Posts one tidy rollup in Slack so the ops team sees the whole day's reorder load in a single message, not a dozen pings.
- Skips items it already filed in the last 7 days so the same SKU doesn't get a new task every morning.
What do I need to use this?
- A Squarespace site on a plan that includes the Commerce API (Core, Plus, Advanced, Business, Commerce Basic, or Commerce Advanced).
- An Asana workspace and a project where reorder tasks should land.
- A Slack workspace and the channel you want the daily rollup posted to.
- A reorder threshold in mind (the default is 5 units per variant).
How can I customize it?
- Change the threshold per variant or per product line so fast movers trigger earlier than slow movers.
- Pick the Asana project, assignee, and due-date offset that match how your ops team actually picks up reorder work.
- Swap the Slack channel, retime the 7am run, or skip weekends and holidays to match your team's hours.
- Tighten or loosen the 7-day duplicate window if you reorder more or less often than once a week.
FAQs
Will this work with my Squarespace plan?
Does it cover every product variant, including different sizes and colors?
How does it decide what's urgent?
Won't I get a duplicate task for the same SKU every morning?
Can I change the Slack channel or run time later?
Related templates
When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.
Every 15 minutes, forwarded phishing reports get traced back to the server that really sent them, with a verdict in Slack and the worst senders reported.
Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.
Every Monday, rank the week's matches by expected demand, put the big ones on your venue calendar, and post a rota-ready summary to Slack.
Every Tuesday we pull your best new reviews, draft social captions, email testimonials and product page quotes, then stage them in Notion for approval.
Every weekday morning, unfulfilled orders get an address check: harmless typos fixed automatically, risky addresses held with a note to the customer.
Stop checking Squarespace inventory by hand every morning.
Connect Squarespace, Asana, and Slack once, and Geni handles the daily low-stock sweep, the reorder tasks, and the team rollup for you.