Automate Weekly Blog Publishing to my Wix website using Google Docs and RSS.

Can you add screenshots of your current zap, and/or describe the order of operations you’re trying to achieve? i.e.

• RSS item triggers zap, edit it in google doc, then publish on my website. 

Otherwise, there is a lot left to the imagination as to how you’re actually using any of these connections  

This is what Im trying to do:
I want to automate weekly blog publishing to my Wix website using Google Docs and RSS.

Here’s what I need the automation to do:

1. When a new Google Doc is added to my folder called “Y City Blog Posts,” extract the text from the file.
2. The blog post will always include this metadata at the top:
   - COVER_IMAGE_URL: [link to image]
   - TITLE: [title of the blog post]
   - META_DESCRIPTION: [SEO summary]
   - TAGS: [comma-separated list of tags]
3. I want the Zap to extract this metadata and the rest of the blog content separately.
4. Then, it should format this info as a new blog post item in an RSS feed, where:
   - Title = parsed TITLE
   - Content = everything after the metadata
   - Enclosure URL = COVER_IMAGE_URL (for the blog’s cover image)
   - Summary = META_DESCRIPTION
   - Tags = optional
5. The RSS feed should update every time a new Google Doc is added.
6. I will plug that RSS feed into my Wix blog or RSS plugin to auto-publish the post and cover image.

Here’s what I have so far, but I keep getting stuck on Step 2. Not sure what Im doing. I’ve asked ChatGPT for step by step instructions and it’s not helping. 😅

I’m not an expert on wix sites or the zap interface and options, but if this were Wordpress, the RSS portion of your idea isn’t needed. You just create the post using your parsed data in the headline, body, image, etc. fields. 
 

i would also combine all the parsing into a code step. Grab all the text from your Google doc, then write code to output it separately. You can use formatter steps, but you’ll likely need to use regex patterns to extract the targeted parts. 
 

you could also try have AI by Zapier do that for you too. Feed in the text, prompt it to parse, store the outputs. 
 

lastly, before sending it to your site, use a “delay until” step and set the day of the week you want it published. 

Hello ​@ycityproductions! 👋

Did DavidLGS’s suggestions help to point you in the right direction here?

Let us know if you’re stuck or have any further questions, want to make sure you’ve got everything you need! 🙂

Nice workflow idea! Automating blog publishing from Google Docs to Wix is a huge time-saver I’ve done something similar using Google Docs + Formatter + RSS by Zapier to clean up formatting and push it live smoothly.

I set this up recently for my website, and it's been a game changer in keeping weekly content consistent without manual copy-pasting. If you add a quick filter or delay step, you can even time posts more precisely.