Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Sending exchange rates (from an RSS feed) to email

M

Hi every one! Here i have an issue. I need to make zapier send an emails at certain time of the day, that contains Exchange Rate information for certain values. For example. Financial department wants to get an email with this data every morning.

The thing is, that i cant figure out how to send emails at the right time and how to format RSS Feeds to make it more readable as an email. Also it is hard to find RSS link that fits. 

I found RSS links, and make zapier send emails, but it send it every few minutes and in 2 messages for 2different  values. Is there a way to merge them together

Can someone share some wisdom with me?

 

Best answer by christina.d

Hi all! 

There’s some great information sprinkled throughout this thread and I wanted to summarize it up. 🙂

As Troy mentioned it sounds like Digest by Zapier would be a solid option to consolidate the data with RSS by Zapier to create a readable feed for it. 

Specifically with setting up the RSS feed however, William dropped some great knowledge here: 

william wrote:

I believe RSS feeds work using XML files and an ASP file is a text file with the extension .asp that contains any combination of the following: text, HTML tags, and server-side scripts in an COM-compliant scripting language such as Microsoft VBScript. We don’t have way to convert this kind of file into XML or extract the XML from that file.

For RSS specifically, you would likely need to extract the XML for the feed from the .asp file and then host it on a site that the RSS integration can monitor for new feed items. I don’t believe this is something that we would be able to do natively in Zapier. You would need to convert the data externally and then host the XML file on a public site for the RSS feed to read. I wasn’t able to find a lot of information about converting .asp to .xml online.

Perhaps you just need to extract the XML data from the .asp file and then host it in an XML file?

Here is an example of CNBC’s RSS feed I pulled from Google: https://www.cnbc.com/id/19746125/device/rss/rss.xml

Notice the feed has the .xml extension, you’ll need a file like this to work with RSS.

I hope this helps! 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Milkebay 

Look into Digest by Zapier: https://zapier.com/apps/digest/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
1 person likes this
  • M
    Milkebay
M
  • Milkebay
  • Author
  • New
  • 3 replies
  • June 7, 2021

Hi @Troy Tessalone!

 

Seems like a solution for merging it together, thanks! 

Yet, still have to find a way to collect and send this data properly

Troy Tessalone
Forum|alt.badge.img+14

Hi @Milkebay 

If you have RSS feeds, you can use RSS by Zapier: https://zapier.com/apps/rss/help

For sending emails, Email by Zapier is a free email app: https://zapier.com/apps/email/help

 

For email, there are many options:

  1. personal email apps (e.g. Gmail)
  2. marketing email apps (ActiveCampaign)
  3. transactional email apps (e.g. Mailjet)

 

You can search the available Zap apps here for Email: https://zapier.com/apps/email/integrations

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
  • Milkebay
  • Author
  • New
  • 3 replies
  • June 7, 2021

@Troy Tessalone

 

Thats is exactly what i am using. But it won’t display necessary information in correct way.  

For example. I have a RSS link that provide me with XML file with 8 items for 8 days. (Exchange Rates changing every day, obviously. except weekends) And when im trying to choose the right item - it is not even in the list. Only 3 days/items listed

Thank you for support @Troy Tessalone 

Troy Tessalone
Forum|alt.badge.img+14

@Milkebay 

You’ll likely need to utilize HTML in the email.

https://zapier.com/help/create/email-and-text-messages/send-emails-in-zaps#format-html-emails

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
1 person likes this
  • M
    Milkebay
Troy Tessalone
Forum|alt.badge.img+14

@Milkebay 

When configuring Zaps, the sample records from the trigger step are used to merely configure and test the Zap.

Here’s how to change the trigger step data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

FYI: Zaps only work when turned ON for new data going forward.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
1 person likes this
  • M
    Milkebay
M
  • Milkebay
  • Author
  • New
  • 3 replies
  • June 7, 2021

@Troy Tessalone 

May u help me solve this last question?
I have a URL, that contains XML data. RSS Zapier won’t trigger with this link.
im not sure if i can post it but its publickly available 
http://www.cbr.ru/scripts/XML_daily.asp - i need info from this file. Is there a way to convert it into RSS feed that fits RSS Zapier

william
Forum|alt.badge.img+6
  • williamZapier Staff
  • Zapier Staff
  • 177 replies
  • July 12, 2021

Hey @Milkebay, hope you’re doing well!

I believe RSS feeds work using XML files and an ASP file is a text file with the extension .asp that contains any combination of the following: text, HTML tags, and server-side scripts in an COM-compliant scripting language such as Microsoft VBScript. We don’t have way to convert this kind of file into XML or extract the XML from that file.

For RSS specifically, you would likely need to extract the XML for the feed from the .asp file and then host it on a site that the RSS integration can monitor for new feed items. I don’t believe this is something that we would be able to do natively in Zapier. You would need to convert the data externally and then host the XML file on a public site for the RSS feed to read. I wasn’t able to find a lot of information about converting .asp to .xml online.

Perhaps you just need to extract the XML data from the .asp file and then host it in an XML file?

Here is an example of CNBC’s RSS feed I pulled from Google: https://www.cnbc.com/id/19746125/device/rss/rss.xml

Notice the feed has the .xml extension, you’ll need a file like this to work with RSS.

christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • 2653 replies
  • Answer
  • October 4, 2021

Hi all! 

There’s some great information sprinkled throughout this thread and I wanted to summarize it up. 🙂

As Troy mentioned it sounds like Digest by Zapier would be a solid option to consolidate the data with RSS by Zapier to create a readable feed for it. 

Specifically with setting up the RSS feed however, William dropped some great knowledge here: 

william wrote:

I believe RSS feeds work using XML files and an ASP file is a text file with the extension .asp that contains any combination of the following: text, HTML tags, and server-side scripts in an COM-compliant scripting language such as Microsoft VBScript. We don’t have way to convert this kind of file into XML or extract the XML from that file.

For RSS specifically, you would likely need to extract the XML for the feed from the .asp file and then host it on a site that the RSS integration can monitor for new feed items. I don’t believe this is something that we would be able to do natively in Zapier. You would need to convert the data externally and then host the XML file on a public site for the RSS feed to read. I wasn’t able to find a lot of information about converting .asp to .xml online.

Perhaps you just need to extract the XML data from the .asp file and then host it in an XML file?

Here is an example of CNBC’s RSS feed I pulled from Google: https://www.cnbc.com/id/19746125/device/rss/rss.xml

Notice the feed has the .xml extension, you’ll need a file like this to work with RSS.

I hope this helps! 

Terms & Conditions