Help with the template: Get RSS feed updates in a single email summarizing all posts that contain a specific keyword

Error in Scenario with Google Sheets and RSS Feed

Goal:
I am attempting to create a Make.com scenario that retrieves RSS feed updates containing specific keywords mentioned in a Google Sheets document. The Google Sheets document has two columns: one for RSS feed URLs and another for associated keywords. The scenario is set to compile these feeds into a single email summary.

Steps Tried:

  1. Configured the Google Sheets module to search for rows.
  2. Set up the RSS module to retrieve feed items.
  3. Used Tools modules to compose strings and aggregate tables.
  4. Arranged an Email module to send out the compiled email.
  5. On running the scenario, I encounter a validation error suggesting an invalid reference to a variable in the link before module ‘3’.

I have confirmed that the column headers in Google Sheets are accurate and that I’m referencing the right module numbers. However, I’m stuck on the error message which states “Invalid reference in filter ‘0-0’ on link before module ‘3’.”

I would greatly appreciate any guidance on what might be going wrong with my variable references or filters.

Thank you in advance for your assistance!

This is de google sheets table:

And the configuration:




image

Blueprint:
blueprint.json (27.5 KB)

I can´t download the Imput/output budles but here you are a ss:


Welcome to the Make community!

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Input/Output bundles

Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes

Thank you for the retro Sam!

Quien me ayude le invito unas tacos wey ajua (soy de México) así que puedo decir eso

Hey @Leonardo_Flores :wave:

I just wanted to let you know that the official language of our community is English, as is stated in our Code of Conduct. We want to create a space where everybody can chat and resolve their issues. Thank you for understanding!

:arrow_right: Here’s the translated message:

Whoever helps me I’ll buy you some tacos wey ajua (I’m from Mexico) so I can say that.