extract yesterday records and extracthtmlcontent html and google tasks
Configured with Google Sheets, Google Tasks, Html, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Routing
- Transform
- Web / API
- Integration
- Trigger
- AI & models
- Data store
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| Loop Over Items | Routing | Loop Over Items | See node parameters |
| Merge | Transform | Merge | See node parameters |
| If | Routing | If | See node parameters |
| Extract Yesterday Records | Web / API | HTTP Request | See node parameters |
| Extract HTML Blocks | Transform | Html | extractHtmlContent |
| Parse Blocks | Transform | Html | extractHtmlContent |
| Google Tasks | Integration | Google Tasks | See node parameters |
| When clicking ‘Test workflow’ | Trigger | Manual Trigger | See node parameters |
| Classification Agent | AI & models | Open Ai | See node parameters |
| Collect Answer | Transform | Edit Fields | See node parameters |
| Record Sustainability Procedures | Data store | Google Sheets | append |
| Edit Links | Transform | Edit Fields | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
googleSheetsOAuth2Api
Workflow notes
1. First Block: scrape the page to extract all the legislative procedures scheduled for debate yesterday
1. First Block: scrape the page to extract all the legislative procedures scheduled for debate yesterday
This workflow sends an HTTP request to collect the HTML of the page by block. For each block we extract the information of the procedures: Reference Number. Committee, Rapporteur, Title/Description, PDF Link.
How to setup?
Nothing to do
2. Use a LLM to keep only the procedures related to sustainability
2. Use a LLM to keep only the procedures related to sustainability
We loop though all items parsed and we provide the description and the committee to a LLM (Open AI). The LLM will use these information to assess if the procedure is related to sustainability or not.
How to setup?
- Open AI Node:
- Add the required credentials Open AI credentials and select the model (Example: Open AI 4o-mini)
- Adapt the system prompt with the topic you want to filter out or keep. Learn more about the AI Agent Node
3. Topics related to sustainability are stored in a Google Sheet
3. Topics related to sustainability are stored in a Google Sheet
The output of the LLM is combined with the other fields. A IF node filters out all the procedure not related to sustainability. The remaining items are loaded in a Google Sheet.
How to setup?
- Record outputs in the Google Sheet Node:
- Add your Google Sheet API credentials to access the Google Sheet file
- Select the file using the list, an URL or an ID
- Select the sheet in which you want to record your working sessions
- Map the fields: Reference Number. Committee, Rapporteur, Title/Description, PDF Link Learn more about the Google Sheet Node
4. Create Sustainability Study Task
4. Create Sustainability Study Task
Create a Google Task for each EU legislative file related to sustainability, scheduled for tomorrow at 09:00 AM.
How to setup?
- Add a task in Google Task:
- Add your Google Task API credentials to access your task list
- Change the Task List name Learn more about the Google Task Node
Sticky Note4
extract yesterday records and extracthtmlcontent html and google tasks
extract yesterday records and extracthtmlcontent html and google tasks
Purpose and structure
This folder contains the extract yesterday records and extracthtmlcontent html and google tasks workflow. Its executable nodes use googleSheets, googleTasks, html, httpRequest, if, manualTrigger, merge, openAi, set, splitInBatches. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
When clicking ‘Test workflow’
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Googletasks/0881_Googletasks_HTTP_Update_Webhook.json MIT; preserve source notices.