How to update google sheet and later in the workflow read the content?

How To
1

Hi

I have an scenario that starts getting rss feed entries every 4 hours, each entry added into a new row in a google sheet document, column A: URL, column B: description and I left column D in blank because I’ll put the url for the main image. Inside the document, using coding I extract the main image url from that entry and put it in the column D in the same row as the original URL entry.

I need a module to read each new entry and get the image URL related to the main URL from rss entry. Im using the “search rows module” but for some reason Im getting the first image always, I mean the first image from the list, and i need to get the url image from each row that i’ve extracted.

Im usin this automation to get news, read the news use perplexity and chat gpt to create X and bluesky posts.

Any Ideas?

2

Hey Aldher,

add column E that says Done or something like that, then append the Search Rows module to search by column E being empty. Then when its done processing, add an Update a Row module that posts Done in column E.

OR if you are using an App script to extract the URL, have it call a Make webhook to trigger a scenario sending it the row number that needs to be processed next.

1 Like
3

Welcome to the Make community!

Do you really need a Google Sheets integration when all if not most of the RSS feeds already contain the data you need?

To do this, you can try using the RSS “Retrieve RSS feed items” module —

Retrieves RSS feed items from a specified URL.

For more information, see https://www.make.com/en/integrations/rss, and https://www.make.com/en/help/app/rss in the help centre.

Example

Here is an example of how your scenario could look:

Screenshot_2025-04-01_170404
Screenshot_2025-04-01_170404723×435 24.8 KB

This is just an example. Your final solution may or may not look like this depending on your requirements and actual input data.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like
4

Yes I need it because I have some values in the row, one of those is the URL for the main image that I’ve extracted from the article

5

I’ll try this, the column E with Status ad look for that. Ill be back with comments!

Thanks

6

Thanks evryone is working as i wanted

7

No problem, glad I could help!

1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.