How to Add RSS Feed Items to MS Excel Spreadsheet Using Pabbly Connect

Learn how to automate adding RSS Feed items to your MS Excel spreadsheet using Pabbly Connect. Step-by-step guide to streamline your workflow. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for RSS Feed Integration

To begin adding RSS feed items to your MS Excel spreadsheet, first, you need to set up Pabbly Connect. Start by visiting the Pabbly Connect landing page and signing up for a free account. This will allow you to access automation tasks every month to test your integrations.

After signing up, log in to your Pabbly Connect account and navigate to the dashboard. Here, you’ll find the option to create a new workflow. Click on the ‘Create Workflow’ button and name your workflow appropriately, such as ‘Save RSS Feeds into Microsoft Excel’.

2. Configuring the RSS Feed Trigger in Pabbly Connect

Once your workflow is named, the next step is to set up the trigger. In this case, the trigger application will be Pabbly Connect using the RSS feature. Select ‘RSS by Pabbly’ as your trigger application, and choose the ‘New Item in Feed’ trigger event.

This trigger will check the specified RSS feed every 20 minutes for new posts. To connect, click on the ‘Connect’ button and enter the RSS feed URL from your desired website. For example, you can use an RSS feed from a news site like NDTV, specifically from their sports section.

• Click ‘Save and Send Test Request’ to fetch the latest feed item.
• Verify that the fetched data includes the post title and link.

After fetching the data, you should see the most recent RSS feed item displayed, confirming that your trigger is working correctly.

3. Formatting the Publishing Date Using Pabbly Connect

Next, you need to format the publishing date of the RSS feed item before adding it to your Excel sheet. This is accomplished by adding a step in Pabbly Connect using the Text Formatter feature. Select the ‘Text Formatter’ app and choose the ‘Split Text’ action event.

Map the publishing date from the previous RSS feed step and set the separator to a space. This will allow you to separate the date from the time. Once configured, click ‘Save and Send Test Request’ to ensure the date is correctly formatted. You will see the separated date components in the results.

4. Adding RSS Feed Items to MS Excel Using Pabbly Connect

After formatting the publishing date, the next step is to add the RSS feed data to your MS Excel spreadsheet. In Pabbly Connect, click on the plus icon to add another action step, and select ‘Microsoft Excel’ as the application.

Choose the action event as ‘Add Row to Worksheet’. Connect to your Microsoft account and select the appropriate Excel workbook and sheet where you want to store the RSS feed items. You will need to map the fields such as the headline, link, website address, and formatted publishing date.

• Map the headline to the title from the RSS feed.
• Map the link to the feed link.
• Map the website address from the feed link.

After mapping all necessary fields, click ‘Save and Send Test Request’ to test that the data is added correctly to your Excel sheet.

5. Final Steps and Automation Confirmation

Finally, review your Excel sheet to confirm that the RSS feed item has been successfully added. You should see the new row populated with the RSS feed data, including the title, link, website address, and the formatted publishing date.

This automation only needs to be set up once in Pabbly Connect. After the initial setup, the workflow will automatically run every 20 minutes, adding new RSS feed items to your Excel spreadsheet without any manual intervention.

By using Pabbly Connect, you can streamline your workflow and keep your Excel sheet updated with the latest RSS feed posts effortlessly.

Conclusion

In this tutorial, we demonstrated how to automate the addition of RSS feed items to your MS Excel spreadsheet using Pabbly Connect. By following these steps, you can ensure your data is consistently updated with minimal effort.