What I want to achieve:
-
Process multiple URLs (from a Google Spreadsheet)
-
Retrieve the HTML body for each URL (with a HTTP request containing a ScraperAPI)
-
Extract all … blocks from the HTML
-
Convert those sections into plain text
-
Combine all text from one URL into a single document
-
Save it into one Google Doc per URL (no separate docs per section)
What I’ve built so far:
Per URL:
-
HTTP Request retrieves the HTML
-
Text Parser > Match pattern finds … blocks
-
Iterator that processes those sections one by one
-
HTML to Text converts each section into plain text
-
Tools > Text Aggregator collects the text
- Problem: The output still contains multiple operations, so Make runs the next step once per bundle
-
Google Docs > Create a document. This creates multiple documents per URL
- Problem: I would like to have 1 document with the texts of 1 URL
What can I try to fix my problem?
In the screenshot you see a Set variable module instead of a Google Doc for test reasons. I’m testing with a single URL from a single row in the Google Spreadheet.
I believe the solution should lie in an aggregator or iteration. But I’m new to Make.com and even other threads in this community, Youtube video’s and endless discussions with GPT and Claude couldn’t help.
Because I think the problem lies in this module, I’ve added a screenshot of the Text Aggregator module.
