ChatGPT Emails a Daily Summary of Your Supplier Google Sheet

4 min setup

No coding required

Runs automatically

Many suppliers share stock levels, ship dates and backorders in a Google Sheet they update every day, and nobody on your team reads it until a product sells out. This workflow reads the supplier's sheet every morning, has ChatGPT pull out what changed and what needs action (low or zero stock, pushed ship dates, discontinued items), and emails you a short plain-English summary.

Use this template → Related article

Every morning, after the supplier updates the sheet

Read the supplier's stock sheet in Google Sheets

ChatGPT flags low stock and late ship dates

Email the summary to your buyer or team

How it works

4 steps to get a plain-English ChatGPT summary of your supplier's Google Sheet every morning

App connector: Schedule • Time to complete: 1 minute

Run once a day, for example at 8am, after the supplier usually updates the shared sheet.

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

Read the rows from the supplier's shared sheet, such as SKU, product name, quantity available, next ship date and status. The sheet must be shared with the Google account connected to MESA.

App connector: ChatGPT • Time to complete: 1 minute

Send ChatGPT the rows and ask for no more than 8 bullet points: SKUs at or below a stock level you choose, items out of stock or discontinued, ship dates that are later than a date you give, and anything else unusual. Tell it to name SKUs exactly as they appear in the sheet and to say plainly when nothing needs attention.

App connector: Email • Time to complete: 1 minute

Email ChatGPT's summary to the store owner, buyer or operations team, with the supplier's name and the date in the subject line.

Trusted by 1,000+ merchants

Ready to get a plain-English ChatGPT summary of your supplier's Google Sheet every morning

Get setup in 4 minutes.

Use this template →

FAQs

Does the supplier need a MESA account?

No. The supplier keeps updating their sheet as usual. It only has to be shared with the Google account you connect to MESA.

What if the sheet has thousands of rows?

Add a Filter step before ChatGPT to keep only the rows that matter, such as stock at or below your reorder level, so the request stays small and the summary stays focused.

Can I get the summary in Slack instead?

Yes. Swap the Email step for a Slack Send Message step to post the summary in your purchasing channel.

Personalize this template

Customize this workflow even further:

Only email when something needs action

Ask ChatGPT to start its reply with ALERT or OK, then add a Filter step so the email only goes out when the summary starts with ALERT.

Use Claude instead of ChatGPT

Replace the ChatGPT step with a Claude Create Message step and keep the same prompt.

"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

get a plain-English ChatGPT summary of your supplier's Google Sheet every morning

4 min setup • Fully supported if you need help