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

Partner tier review board for quarterly promotion calls

Work every partner tier decision from one board, with the revenue and commission numbers, clear promotion thresholds, and AI review briefs.

Introw
HubSpot
Slack
App
Reconcile partner commissions between HubSpot and Introw

Open one board at month end to find every closed deal missing a commission, every commission with no deal behind it, and every amount that does not add up.

Introw
HubSpot
Slack
App
One control room for every Instantly sending mailbox

See warmup status, daily send volume, and bounce risk for every sending account in one grid, with the riskiest mailboxes floating to the top.

Instantly
Slack
App
Partner payout approval queue with Xero bill handoff

Review Introw partner payouts line by line, approve them from one board, raise the matching bill in Xero, and post every approval to Slack.

Introw
Xero
Slack
App
One inbox for every Jira Service Management approval waiting on you

See every access, purchase and leave request waiting on your decision in one screen, approve or decline in place, and send the reason back to the requester.

Jira Service Management
Confluence
Slack
App
Browse and shortlist creators without burning audit credits

Search creators for free, shortlist the best with your team, and spend an audit credit only when you decide someone is worth a closer look.

HypeAuditor
Airtable
Slack
App

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.