Stay on top of sustainability policy without long manual review. The flow scans a public legislative page, keeps only sustainability items, logs them to a sheet, and creates follow up tasks with clear details. It fits ESG teams, public affairs, and research groups that need a daily shortlist to study.

Here is how it runs. A manual trigger pulls the page HTML, then HTML parser nodes extract reference number, committee, rapporteur, title, and PDF link for each record. A batch loop sends the description and committee to an AI classifier to answer yes or no on sustainability. The result is merged back, an If node keeps only the yes items, Google Sheets stores them, and Google Tasks creates one task per item due tomorrow at 09:00 with notes for quick review. A small set step also cleans links before processing.

Connect OpenAI, Google Sheets, and Google Tasks, then map sheet columns and choose a task list. Expect a short daily run that cuts review time from hours to minutes and reduces missed files. Great for daily monitoring, preparing briefings, and routing work to subject matter experts.

• Manual trigger for on demand runs and testing
• HTTP Request fetches the agenda page with a dynamic date filter
• HTML extract captures Reference Number, Committee, Rapporteur, Title and PDF link
• Set step cleans and standardizes links before processing
• Split in Batches loops through items safely and reliably
• OpenAI classification answers yes or no on sustainability based on text
• Merge and If nodes combine results and keep only relevant items
• Google Sheets records selected items for tracking and reporting
• Google Tasks creates follow ups due tomorrow at 09:00 with notes

• Reduce manual review from 2 hours to 10 minutes
• Automate 90 percent of repetitive screening work
• Improve data quality by 95 percent with structured fields
• Connect Google Sheets, Google Tasks and AI in one flow
• Ensure nothing is missed with tasks due tomorrow at 09:00

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Google Tasks and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. OpenAI credentials: Double click the Classification Agent node, open the Credential to connect with menu, select Create new credential, then paste your OpenAI API key from your OpenAI account API page. Save and test the connection.
4. Google Sheets credentials: Double click the Record Sustainability Procedures node, choose Create new credential, then follow the on screen OAuth steps. Select the target spreadsheet by URL or ID and pick the sheet tab. Map Reference Number, Committee, Rapporteur, Title or Description and PDF Link fields.
5. Google Tasks credentials: Double click the Google Tasks node, create a new credential and complete OAuth. Choose the correct Task list and keep the due date set to tomorrow at 09:00 if you want the same schedule.
6. Verify HTML extraction: Run the workflow in test mode and open the Extract HTML Blocks and Parse Blocks node outputs. If Blocks is empty, adjust the CSS selector .erpl_document-wrapper to match the page. Confirm all fields are present.
7. Review the HTTP Request URL date filter. It is set to load the prior session day. Adjust the minus value if you need a different range.
8. Run a full test: Click Execute, confirm the AI node returns yes or no, check the If node counts, then verify that rows appear in your Google Sheet and tasks appear in your chosen Google Tasks list.
9. Troubleshooting: If Sheets fails to write, share the spreadsheet with the connected Google account and confirm the sheet tab name. If task times look off, check the time zone in your n8n instance and your Google account. If the AI step errors, confirm the API key and chosen model.
10. Tune the AI filter: In the Classification Agent node, update the system prompt to widen or narrow the topic beyond sustainability if your use case changes.