Track Applied Shopify App Credits in Google Sheets

4 min setup

No coding required

Runs automatically

Automatically log each app credit issued with date, Shopify store domain, amount, and notes in a central Google Sheets record. This enables the monitoring of trends, detection of unusual activities, and ensures accurate record-keeping for support and reporting.

How it works

2 steps to start receiving automatic tracking of every app credit you issue to Shopify stores

App Credit Applied

App connector: [Shopify Partner](/content/apps/shopify-partner/integrate "View Shopify Partner integration page"/index.html) • Time to complete: 2 minutes

Why this matters: This trigger monitors your Shopify Partner account for any app credits you issue to stores, starting the workflow whenever a credit gets applied to help with billing disputes or customer support requests.

You'll need to enter your App ID to connect this trigger to your specific app. Find your App ID in your Shopify Partner Dashboard under Apps - it's the numerical identifier that appears in your app's URL. The trigger checks hourly for new credits applied, capturing details like the store domain, credit amount, and notes you included when issuing the credit. Once a credit is detected, this information flows to the Google Sheets step for logging.

Add Row

App connector: [Google Sheets](/content/apps/googlesheets/integrate "View Google Sheets integration page"/index.html) • Time to complete: 2 minutes

Why this matters: This action creates a permanent record in Google Sheets every time you issue an app credit, giving you a searchable history for billing inquiries and customer support documentation.

You'll configure which columns to include in your tracking spreadsheet - the template offers Date Credit Issued, Time Credit Issued, Shopify Domain, Notes, and Amount fields. You can also name your spreadsheet during setup (something like "App Credits Tracking 2025" works well). The action automatically populates each row with the credit details from the trigger, formatting dates as "January 1, 2025" and times as "4:05pm" for easy reading.

Frequently asked questions

Will this track credits from all my apps or just one specific app?

This workflow tracks credits for the single app ID you configure in the trigger. If you have multiple apps, you'll need to set up separate workflows for each one, or modify the trigger to monitor multiple app IDs.

Can I backfill historical credit data into the spreadsheet?

Yes, run a Time Travel to backfill this data as far back as needed. This workflow only captures new credits going forward from when you activate it.

What happens if I change the spreadsheet structure after the workflow is running?

The workflow will continue adding rows with the original column structure you configured. If you want to change columns, you'll need to update the "Add Row" step configuration to match your new spreadsheet layout.

Make this template your own!

Customize this workflow even further:

• Add Slack notifications for large credits
• Create monthly summary reports
• Store credit data in custom tables
• Deploy AI agents to categorize credits

You're in good company

Avg. App Store rating
4.9/5
Merchant reviews
157
Avg. time saved per week
3.5 hrs

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!"

Ready to start receiving automatic tracking of every app credit you issue to Shopify stores?

7-day free trial • 4 min setup • Cancel anytime

[Start with this template — It's free](/content/pricing?template=shopify_partner%2Fapp%2Ftrack_app_credits_issued_in_google_sheets&templateName=track-shopify-app-credits-google-sheets "Install and use this template in MESA - Free to use"/index.html)

Need help? Our automation experts will help you personalize this workflow for free. Contact support