Hey everyone, I’m trying to create an automation scenario in Make.com that processes an RSS feed dynamically.
I want to paste an RSS feed URL into a Google Sheet, have Make.com read it, and then automatically create a new sheet where the first row consists of the names of the RSS item attributes (e.g., ‘Title’, ‘Description’, ‘Summary’, ‘Author URL’, ‘URL’, ‘Date Updated’, ‘Date Created’, ‘Comments’, etc.).
This stage is only for creating the new sheet and setting up the header row—it’s not about regularly extracting and storing news from that RSS feed. Essentially, I don’t want to manually create a new sheet with different columns every time I add a new RSS feed. Instead, I just want to paste an RSS feed URL into my main sheet, and Make.com should handle the rest—extracting the RSS item attributes and creating the appropriate headers in a new Google Sheet.
I already know how to map the value of an output (e.g., mapping ‘www.google.com’ to the “URL” column within a sheet). What I need to extract is the name of the item itself (e.g., in this case, ‘URL’). How can I set up an automation to dynamically pull and store these field names as column headers?
Thanks!