I have two different RSS feeds that each provide unique information that I want on the same row of a Google Sheet. Both are pulling information from Reddit.
Feed 1 (default Reddit RSS):
- publish date
- original poster
- link to Reddit post
- post title
Feed 2 has lots of information, but I am trying to pull exclusively the article URL that the Reddit post links to.
I want both RSS outputs to be on the same row in a Google Sheet so that I have all the fields from Feed 1 and Feed 2 in the same row. However, if I make two separate zaps and use the Create Spreadsheet Row step, the article URL and the other information will be on separate rows, which is not ideal. When I try to use the “Lookup Spreadsheet Row in Google Sheets” step and “Update Spreadsheet Row in Google Sheets” step together, I don’t know how to make the “Update” step actually paste in the URL I want.
How can I ensure that both RSS outputs land on the same row?
Thanks in advance.
Best answer by GetUWiredView original