I’m looking for someone to build a flow that targets Carolyn Hax advice columns from the
Washington Post Archives. Specifically any advice columns that have to do with parenting, teenagers, self-worth/confidence and related topics. The advice columns will be extracted and entered into google sheets with one row per column and specific metadata in separate columns.
If this is something that is doable without have to manually click on each advice column link than this would be great. Please reach out and let me know what you’d charge to create this flow. Thanks!!
Hi @willthack pleasure to meet you.
My thinking is in the direction of the following agent (called Hax Column Extractor):
This agent automatically scans the Washington Post’s Carolyn Hax advice column archives to identify and extract columns related to parenting, teenagers, self-worth, and confidence. It collects links to each column, visits them without manual clicks, and uses AI to extract key details such as the publication date, title, full advice content, and the column’s URL. It then analyzes each column’s content to determine if it matches the target topics, and only saves the relevant ones into a structured Google Sheet, with each row containing the column’s metadata and text. This allows for efficient, hands-free curation of themed advice columns for further use or analysis.
This is definitely doable with Gumloop and can be set up to run without manual clicking.
I can set up the flow to push everything into Google Sheets, one row per column as you described.
Let me know if you want to discuss timing and pricing.