Using a Google Folder to Import Blog Posts - A Step-by-Step Guide
Hi, I’m Brendan Quigley, the founder of Acres Shopify Agency, https://threeacres.ca and in this tutorial, I'll show you a quick and easy method to import images and blog posts into your Shopify store using a Google Drive folder. This is particularly helpful for merchants and freelancers looking to streamline their content management process.
What You’ll Learn:
How to host images in a Google Drive folder and generate links that Shopify can use.
The exact Google Sheets formulas to convert shareable Google Drive links into the format Shopify accepts.
Formulas Used in the Video:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"https://drive.google.com/file/d/",""),"/view?usp=drive_link",""),"https://drive.google.com/open?id=",""),"&usp=drive_fs","")
="https://drive.google.com/uc?id="&A1
Why This is Useful:
Whether you’re reselling products with images from suppliers or uploading your own images, this process allows you to easily convert Google Drive links into usable URLs in bulk, saving you time and manual effort.
Transcript Highlights:
In this video, I cover the entire process, from setting up a Google Drive folder to ensuring the images are accessible via link, and how to automate the generation of image URLs using Google Sheets. We even had a bit of fun with some quirky product ideas like portable solar-powered garden lights generated by ChatGPT!
Chapters:
00:00 Intro
01:13 Obtaining image links from Google Drive
03:05 Extracting image IDs
04:19 Creating hosted URLs that Shopify can see
05:17 Import Google Sheets into Shopify