Shopify App : Sheets ‑ Sync with G Sheets
Fast edit your store data directly into Google Sheet
About Sheets ‑ Sync with G Sheets
Fast editing in Google Sheets : Use Google Sheets directory to modify your inventory, prices, images, fulfilments, download your orders, customers listings
Automatic sync in the cloud : Your listings are synced in Google cloud, you can save your Sheets into Google Drive, it supports histories, therefore you have backups
Update your store instantly : Once your modifications are done, you just have to click on the "Update" button, then your store is immediately updated !
Sheets for Shopify allows you to edit your products in bulk mode directly from Google Sheets.
It has never been easier to edit your catalog with no import or export operation and without handling any file!
Editing
You can edit different information for products, variants, and metafields in bulk mode.
For products:
- Product title
- Description
- Tags
- Product type
- Vendor
- Metafields
- Meta Title
- Meta Description
- Images
For variants
- Quantity (for multiple locations as well)
- Price
- Compare at price
- Barcode
- SKU
- Images
- Also: requires shipping, taxable, weight, units, policies, cost, country, province, HSC ...
For orders
- Orders and ordered items listing
- Order status and shipping number update
Listing
At any time, you can access your customer or order listings. That is useful for instance to import the data into your favorite ERP.
Usage
Using Sheets is easy, instantly connect your store to Google, click on "Create" and your sheet is automatically opened in Google Sheet. For example, you can at once do multiple edits of quantities and prices for a selection of products or your entire catalog.
You fully benefit from the power of Google Sheets, you can therefore use formulas, sort, select some products only, using filters, etc.
SEO
You can edit your meta title & description in bulk, this is useful for improving your SEO.
Backups
You can revert anytime the modifications made on your catalog by using the Google Sheets backup function, you can rollback with no time limit.
Seamless workflow: use directly in Shopify admin
Speed tested: no impact to your online store
About the Author
Matej Kontros is an E-Commerce expert and app developer with over a decade of professional experience in IT.
Matej has worked for organisations of all types and sizes, including global players, startups, and agencies. He designed, developed, and maintained complex projects.
Matej's expertise includes e-commerce, software engineering, web development, systems administration, internet security, managing projects, and building teams.
Visit his website at [ Web Linkedin ] or contact him at [email protected].