---
title: "Daily Sendcloud returns log with Slack alerts on return reasons | FlowRunner flow"
description: "Every morning this flow adds new Sendcloud returns to a Google Sheets log, counts reasons over 7 days, and posts to Slack when one reason crosses your threshold."
url: https://flowrunner.ai/flows/sendcloud-daily-returns-log
date_published: 2026-11-14
date_modified: 2026-11-16T14:50:08-08:00
---

# Daily Sendcloud returns log with Slack alerts on return reasons

Every morning this flow adds new Sendcloud returns to a Google Sheets log, counts reasons over 7 days, and posts to Slack when one reason crosses your threshold.

## The prompt

Every morning, pull our returns from Sendcloud and add any new ones to the returns log in Google Sheets, with the return ID, date, status, reason, both parcel numbers and the refund details. Then count the return reasons over the last 7 days. When one reason reaches 5 returns, post it to our Slack channel so product and packaging can look at it.

FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.

## The flow

[Import this flow](https://flowrunner.ai/downloads/prompt-to-flow/sendcloud-daily-returns-log.json)

-   [Sendcloud](https://flowrunner.ai/integrations/sendcloud)
-   [Google Sheets](https://flowrunner.ai/integrations/google-sheets)
-   [Slack](https://flowrunner.ai/integrations/slack)

Download the file, then in FlowRunner click + beside Flows, pick it under Import a Flow Version and click Create. [How importing works](https://docs.flowrunner.ai/manage/flows#importing-a-flow)

## What each step does

1.  Pull returns from Sendcloud Gets the latest 100 returns from your Sendcloud account.
2.  Read the returns log Reads the rows already in your returns log in Google Sheets.
3.  Pick out new returns Keeps only the returns whose ID is not in the log yet and lays each one out as a row: ID, date, status, reason, outbound and return parcel, and refund details.
4.  Any new returns? When nothing new came in, the flow skips straight to counting.
5.  Add them to the returns log Appends the new returns to the log in Google Sheets.
6.  Count return reasons this week Counts returns by reason over the last 7 days and picks out any reason that just reached the alert threshold.
7.  Reason over the threshold? Goes on to Slack only when a reason crossed the line today, so the same pattern doesn't post every morning.
8.  Alert the team in Slack Posts each reason that crossed the threshold with its 7-day count, and points the team to the log for the parcels behind it.

## Need a custom returns reporting automation? Our team can build it for you.

Tell us the process. Our implementation team at Midnight Flow builds it around how you work, tests it on your real data, and keeps it running, in your own FlowRunner workspace.

[Have us build it](https://midnightflow.ai/packages/custom?utm_source=flowrunner.ai&utm_medium=referral&utm_campaign=general&utm_content=flows.aside&utm_term=sendcloud-daily-returns-log)

## Before you turn it on

-   Enter your Sendcloud public key and secret key, and connect your Google Sheets and Slack accounts.
-   Make a returns log spreadsheet whose first sheet has these column headers: Return ID, Created, Status, Reason, Outbound parcel, Return parcel, Refund. Paste its URL into the flow setting Returns log spreadsheet.
-   Change the flow setting Alert threshold if 5 returns with one reason in 7 days is not the right line for you.
-   Pick your Slack channel in Alert the team in Slack, and schedule the flow to run once a day in the morning.

[Everything FlowRunner does with Sendcloud](https://flowrunner.ai/integrations/sendcloud)

---
Markdown version of https://flowrunner.ai/flows/sendcloud-daily-returns-log. Site index: https://flowrunner.ai/llms.txt
