About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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?

 
icon

Best answer by christina.d 4 October 2021, 20:52

View original
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
Userlevel 7
Badge +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

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
Userlevel 7
Badge +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

@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
Userlevel 7
Badge +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
Troy Tessalone
Userlevel 7
Badge +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

@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
Userlevel 3
Badge +6

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
Userlevel 7
Badge +9

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: 

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