Rss Feed to Airtable/Google Sheet

[mywebmaster]

Hi, Its my first time using pipedream and I need some basic help:

I want to fetch new RSS feed items to to an Airtable.

The feed contains several fields: Title, URL, Source, etc. I added the same field names to the Airtable table.

I have tried to it by myself, looking at the help documents and the community forum but I just seem to be getting the error message.

I also tried this: {“title”:{{steps.trigger.event.title}}}

Please Help by providing step my step instruction. (also, let me know if the same step works for Google Sheets) thanks in advance.

[pierce]

Hi @mywebmaster,

First off welcome to the Pipedream community, happy to have you.

I think I may see the issue. If you read the help text under the Records property in that Airtable Create Multiple Records action, it says

Provide an array of objects. Each object should represent a new record with that column name as the key and the data to insert the corresponding value.

This means that while {{ steps.trigger.event.title }} may be a valid string, the action is expecting an array of objects.

For example, if you want to insert a title entry, it could look like the below:

[ { "title": {{ steps.trigger.event.title }} } ]

[mywebmaster]

Thanks @pierce for your suggestion and help.

Yes, I definitely understood the help text, I just could not format the correct code.

I just tried the code you give me and its giving an error, same as before…

I am missing something? Please have a look at the screenshot.

Perhaps if you can create a workflow and share with me, I can then copy it and use it. The data source is any rss feed. example <![CDATA[CNN.com - RSS Channel - App International Edition]]>

Thanks

[pierce]

@mywebmaster I’m sorry, the steps in double brackets {{ }} are literally printed out.

The results need to be JSON encodable. This means we need to wrap them in a string: "{{ }}".

Try this instead:

[{ "title": "{{steps.trigger.event.title}}"}]

[mywebmaster]

@pierce

[{ "title": "{{steps.trigger.event.title}}"}]

Thanks So much! that worked!!