Best answer

Extracting a Shopify blog post url to a google sheet

I have set up a zap to extract important data from every blog post I publish in shopify to make it easier to support sending a daily newsletter.

But, the url of the published blog post isn’t a field I can choose to extract.  Can someone help me with this?  Is there away to add that as an option to extract?


Best answer by ken.a 8 May 2023, 16:06

View original

3 replies

Userlevel 7
Badge +6

Hi there @StephAXC,

Welcome to the Community! 🎉

I did some digging, and it looks like Shopify doesn't include the URL of the blog post in the "New Blog Entry trigger." 

No worries, there's a workaround for this in our notes.

To make up for this missing information, you can create a fake URL using the blog URL, which is usually formatted as, and the handle field. Here's how you can do it:

(view larger)

Hopefully, this helps! 😊

worked perfectly for me.. thanks!

Userlevel 7
Badge +6

Awesome! I’m glad that worked perfectly @SteveVK!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗