Skip to main content
Answer

Extracting a Shopify blog post url to a google sheet

  • May 7, 2023
  • 3 replies
  • 126 views

StephAXC

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

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 https://yourshopdomain.com/blogs/article/, and the handle field. Here's how you can do it:

36c534f06faa55db2b0be77e4100e3f7.png
(view larger)

Hopefully, this helps! 😊

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Answer
  • May 8, 2023

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 https://yourshopdomain.com/blogs/article/, and the handle field. Here's how you can do it:

36c534f06faa55db2b0be77e4100e3f7.png
(view larger)

Hopefully, this helps! 😊


SteveVK
  • Beginner
  • August 17, 2023

worked perfectly for me.. thanks!


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • August 21, 2023

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! 🤗