Skip to content
Ab Singh
AI Automations, Agents & Systems
All work
Book a call
(opens in a new tab)
Shopify automations I’ve built
Reporting, pricing, support and tracking for Shopify brands. I run my own store too.
~30 min/day → 10 min/week
Live sales dashboard, every store
Opening the dashboard pulls today’s Shopify sales and Meta + Google ad spend, across every store.
Make
Shopify
Meta Ads
Google Ads
Google Sheets
Schedule
Every day, 4:30
Shopify
Get payouts
HTTP
Get transactions
Router
Google Sheets
Add refund
Google Sheets
Add chargeback
Within 0.9% of cash collected
Accounting sheet that matches the bank
Refunds, chargebacks, Shopify fees and COGS land in the accounts sheet on their own, every day.
Make
Shopify
HTTP
Google Sheets
Schedule
Every 15 min
Google Sheets
Search rows
OpenAI
Price from photo
Google Sheets
Update a row
2,000+ products priced
AI pricing from a product photo
For a collectibles store: GPT reads the photo and details, prices it for the market, writes it back.
Make
OpenAI
Google Sheets
Shopify
Shopify
Watch orders
Google Sheets
Search rows
Router
Google Sheets
Update a row
Shopify API
Get details
Google Sheets
Add a row
Runs in ~3 seconds
Order & inventory tracker
Every Shopify order is synced into the tracking sheet — new rows added, existing ones updated.
Make
Shopify
Google Sheets
80% solved with no human
AI support agent on every channel
Messenger, Instagram, WhatsApp and email land in one inbox; AI answers from the customer’s real order.
Make
Chatwoot
OpenAI
Meta
Meta
WhatsApp
9.3/10
Meta event match quality
100%
events with email + phone
9.3/10 Meta match quality
Purchase tracking ads can trust
Server-side purchase events to Meta and Google, including a third-party checkout.
Shopify
Meta CAPI
GA4
GTM
✕
Live sales dashboard, every store
Starts when
The owner opens the dashboard (plus a scheduled pull every morning).
Does
Pulls orders and ad spend, applies the real per-country Shopify fees, merges it into one view.
Result
Today’s numbers, not yesterday’s — all stores in one place, no copy-pasting.
Webhook
Dashboard opened
Shopify
Get orders
Meta Ads
Get ad spend
Google Ads
Get ad spend
Tools
Apply fees
Google Sheets
Update rows
Webhook
Reply
Make
Shopify
Meta Ads
Google Ads
Google Sheets
Open the dashboard →
✕
Schedule
Every day, 4:30
Shopify
Get payouts
HTTP
Get transactions
Router
Google Sheets
Add refund
Google Sheets
Add chargeback
Accounting sheet that matches the bank
Starts when
A daily schedule (refunds, chargebacks) and a weekly one (COGS).
Does
Reads Shopify payouts over HTTP, routes refunds and chargebacks to their own tabs, backfills cost of goods.
Result
Monthly revenue in the sheet lands within €560–€812 of the cash actually collected.
Make
Shopify
HTTP
Google Sheets
✕
Schedule
Every 15 min
Google Sheets
Search rows
OpenAI
Price from photo
Google Sheets
Update a row
AI pricing from a product photo
Starts when
Runs every 15 minutes over new rows in the product sheet.
Does
Sends the photo plus title, year, card type and class to GPT-4o with an appraiser prompt.
Result
A price and updated tags on each row, ready for the Shopify import.
Make
OpenAI
Google Sheets
Shopify
✕
Shopify
Watch orders
Google Sheets
Search rows
Router
Google Sheets
Update a row
Shopify API
Get details
Google Sheets
Add a row
Order & inventory tracker
Starts when
Twice a day, Make watches for new and changed Shopify orders.
Does
Looks each order up in the sheet, routes it to update or add, and pulls extra details from the Shopify API.
Result
One sheet the team trusts for stock and shipping, without anyone typing orders in.
Make
Shopify
Google Sheets
✕
AI support agent on every channel
Starts when
A new message arrives in Chatwoot from any channel.
Does
Pulls the thread and the customer’s order and shipping records, then writes a reply in their language.
Result
The reply goes out on the same channel. Refund demands and angry messages go to a person, already summarised.
Chatwoot
New message
Chatwoot
Get thread
Shopify
Get order
OpenAI
Write reply
Router
Chatwoot
Send reply
Chatwoot
Hand to human
Make
Chatwoot
OpenAI
Meta
Meta
WhatsApp
Ask it something →
✕
9.3/10
Meta event match quality
100%
events with email + phone
Purchase tracking ads can trust
Starts when
A customer buys — on Shopify or the Shiprocket checkout.
Does
Sends purchase and add-to-cart events from the browser and the server, deduplicated.
Result
Ads optimise on real sales instead of guesses.
Shopify
Meta CAPI
GA4
GTM
