Log Skio Cancellation Reasons to Google Sheets With Claude

3 min setup

No coding required

Runs automatically

Skio collects a reason every time a subscriber cancels, but those reasons are hard to read as a whole when they sit in single records. This workflow starts when a Skio subscription is cancelled, has Claude sort the reason into one category from a short list you choose and summarize it in one line, and adds a row to a Google Sheet. After a few weeks you can count cancellations by category and see what is actually driving churn.

Use this template → Related article

When a Skio subscriber cancels their plan

Claude sorts the reason into one category

Add the cancellation to a Google Sheets log

How it works

3 steps to see why subscribers cancel, sorted into categories in one Google Sheet

App connector: Skio • Time to complete: 1 minute

Run each time a subscription is cancelled in Skio. Use the customer's email, the products on the subscription, the delivery interval, the subscription start date, and the cancellation reason the customer gave.

App connector: Claude • Time to complete: 1 minute

Send Claude the cancellation reason and the subscribed products. Give it the fixed category list and ask it to reply with only the single best category and a summary of the reason in 15 words or fewer, separated by a pipe character. If the reason is empty, the category is No reason given.

App connector: Google Sheets • Time to complete: 1 minute

Add a row to the churn log sheet with the cancellation date, customer email, products, delivery interval, subscription start date, the original reason text, and Claude's category and summary in their own columns.

Trusted by 1,000+ merchants

Ready to see why subscribers cancel, sorted into categories in one Google Sheet

Get setup in 3 minutes.

Use this template →

FAQs

Why use Claude if Skio already has cancellation reasons?

Skio's reasons are only as tidy as the options you set up, and free-text answers or an Other reason vary from customer to customer. Claude maps every answer, including free text, onto the same short category list, so the sheet can be counted with a pivot table.

Can I change the categories later?

Yes. Edit the list in the Claude prompt. Rows already logged keep their old category, so add a note in the sheet when you change the list.

Does this contact the customer?

No. It only writes a row to your sheet. To also draft a win-back email, use the Claude win-back email template for Skio alongside this one.

Personalize this template

Customize this workflow even further:

Get a weekly churn summary

Add a second workflow on a Schedule trigger that reads the week's rows with Query Rows and has Claude email you a short summary of the top categories.

Alert on a specific category

Add a Filter step after Claude so cancellations categorized as product not working also post to a Slack channel for your product team.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

see why subscribers cancel, sorted into categories in one Google Sheet

3 min setup • Fully supported if you need help