Back Up Shopify Products and Customers to Google Drive Weekly

7 min setup
No coding required
Runs automatically

Shopify has no built-in backup of your catalog and customer list. Every week this workflow creates a dated spreadsheet in Google Drive with a Products tab and a Customers tab, so you always have a recent copy you own.

schedule icon
Every Sunday night
Create a dated backup spreadsheet in Google Drive
Get every product from Shopify
google sheets logo icon
Add the products to the Products tab
google sheets logo icon
Add a Customers tab
Get every customer from Shopify
google sheets logo icon
Add the customers to the Customers tab

How it works

7 steps to keep a weekly copy of your products and customers you control

schedule icon

Every Sunday night

App connector: Schedule • Time to complete: 1 minute

Runs once a week.

Create a dated backup spreadsheet in Google Drive

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

Create a spreadsheet named Shopify backup and the date in a Backups folder.

Get every product from Shopify

App connector: Shopify • Time to complete: 1 minute

Get all products with title, handle, status, vendor, type, tags and each variant's SKU, price and stock.

google sheets logo icon

Add the products to the Products tab

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

Add one row per variant to the Products sheet.

google sheets logo icon

Add a Customers tab

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

Add a sheet named Customers to the same spreadsheet.

Get every customer from Shopify

App connector: Shopify • Time to complete: 1 minute

Get all customers with name, email, phone, tags, order count, total spent and marketing consent.

google sheets logo icon

Add the customers to the Customers tab

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

Add one row per customer to the Customers sheet.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to keep a weekly copy of your products and customers you control

Get setup in 7 minutes.

Use this template →

FAQs

Can I restore my store from this?

It's a record of your data, not a one-click restore, but the products tab can be re-imported with Google Sheets to Shopify templates.

Will old backups pile up?

Each week adds a new file. Delete old ones in Drive, or keep the last few.

Is customer data safe in Google Drive?

It's as private as the Drive folder you choose, so keep it unshared.

Personalize this template

Customize this workflow even further:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

You're in good company

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

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

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

keep a weekly copy of your products and customers you control

7 min setup • Fully supported if you need help