Notify when Blotato social accounts run low on scheduled posts with Gmail

Quick overview

This workflow runs every morning to read scheduled posts from the Blotato API for your selected social accounts, checks whether any account has fewer than three days of posts queued, and sends a Gmail alert only when an account is running low.

How it works

1. Runs every morning on a schedule trigger.
2. Loads your Blotato account IDs, optional page IDs, timezone, look-ahead window, and minimum-days threshold.
3. Calls the Blotato API to fetch scheduled posts between the configured date range, paging through results.
4. Calculates, per account, how many scheduled posts exist and how many days remain until the last scheduled post (or flags the account as empty).
5. Stops with an error if the Blotato schedule cannot be retrieved to avoid sending a false all-clear.
6. Sends a plain-text Gmail email summarizing only the accounts that are below the minimum-days threshold.

Setup

1. Install the verified Blotato community node (@blotato/n8n-nodes-blotato) and create a Blotato API credential in n8n.
2. Add a Gmail credential with permission to send email.
3. Update the accounts list (account_id and, for Facebook/LinkedIn pages, page_id), TIME_ZONE, and thresholds in the accounts configuration step.
4. Set the recipient email address in the Gmail send step.