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.

Agentic Task
Squarespace FormsAsanaSlackOperationsNotifications & AlertsDaily DigestsData Sync
PromptCreate

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?
You need a plan that includes the Commerce API: Core, Plus, Advanced, Business, Commerce Basic, or Commerce Advanced. If you can see Developer API Keys in Settings, you're good.
Does it cover every product variant, including different sizes and colors?
Yes. It pulls inventory at the variant level, then maps each low variant back to its parent product name and SKU so the Asana task is easy to act on.
How does it decide what's urgent?
It looks at how close the current quantity is to zero relative to your threshold. Items at or near zero are flagged as higher priority in the reorder rationale than items just under the threshold.
Won't I get a duplicate task for the same SKU every morning?
No. The workflow remembers what it already filed and skips any SKU it has already created a reorder task for in the last 7 days. You can adjust that window.
Can I change the Slack channel or run time later?
Yes. The channel, run time, threshold, Asana project, and duplicate window are all easy knobs to tweak after the workflow is running.

Related templates

Auto-fix your calendar when a flight slips, and flag what's at risk

When your flight moves, your calendar times get corrected automatically and you get a Slack note naming the meetings you're about to miss.

Google Calendar
AviationStack
Slack
Agentic Task
Trace phishing emails to the sending IP and report abuse

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.

AbuseIPDB
Gmail
Slack
Agentic Task
Turn procurement portal tenders into CRM deals each morning

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.

Anchor Browser
Google Sheets
HubSpot
+1
Agentic Task
Turn each week's football fixtures into a venue staffing plan

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.

API-Sports
Google Calendar
Slack
Agentic Task
Turn 5 star Yotpo reviews into a weekly marketing content queue

Every Tuesday we pull your best new reviews, draft social captions, email testimonials and product page quotes, then stage them in Notion for approval.

Yotpo
Notion
Slack
Agentic Task
Catch bad shipping addresses before you buy the label

Every weekday morning, unfulfilled orders get an address check: harmless typos fixed automatically, risky addresses held with a note to the customer.

Shippo
Shopify
Gmail
+1
Agentic Task

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.