EU Green Legislation Tracker with GPT-4o, Google Sheets, and Google Tasks

This n8n workflow automates the tracking and summarization of new EU green legislation, leveraging AI to extract key information and organize it into Google Sheets and Google Tasks. It simplifies the process of staying updated on environmental regulations by automatically processing legislative documents and creating actionable tasks.

What it does

This workflow is designed to streamline the monitoring of EU green legislation. Here's a step-by-step breakdown:

1. Manual Trigger: The workflow is initiated manually, allowing for on-demand execution.
2. Google Sheets (Read Data): It reads data from a specified Google Sheet, likely containing a list of legislative documents or links to them.
3. Loop Over Items: Each row (item) from the Google Sheet is processed individually.
4. Edit Fields (Set): Extracts the URL of the legislative document from the current item.
5. HTTP Request: Fetches the content of the legislative document from the extracted URL.
6. HTML (Extract Content): Parses the HTML content of the document to extract relevant text, focusing on the main body of the legislation.
7. OpenAI (Summarize Legislation): Sends the extracted text to OpenAI (using GPT-4o) to generate a concise summary of the legislation, identify key actions, and determine the responsible entity.
8. If (Check for Actions): Checks if the OpenAI response includes identified "Action" items.
   • If Actions Exist (True Branch):
     • Edit Fields (Set): Formats the extracted actions into a structured list.
     • Google Tasks (Create Task): Creates a new task in Google Tasks for each identified action, assigning it to the responsible entity with a clear description.
   • If No Actions (False Branch):
     • Merge: Continues the workflow without creating tasks.
9. Merge: Combines the output from both branches of the "If" node.
10. Google Sheets (Append Summary): Appends the AI-generated summary, key actions, and responsible entities back to the Google Sheet, enriching the original data.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: To store and manage your list of legislative documents and their summaries.
• Google Tasks Account: To create and manage actionable tasks.
• OpenAI API Key: To access the GPT-4o model for summarization and entity extraction.
• Google OAuth2 Credentials: Configured in n8n for both Google Sheets and Google Tasks.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google OAuth2 credentials for both the Google Sheets and Google Tasks nodes.
   • Configure your OpenAI API key for the OpenAI node.
3. Specify Google Sheet: In the initial Google Sheets node, configure it to read from your desired spreadsheet and sheet name. Ensure your sheet has a column containing the URLs of the legislative documents.
4. Customize HTML Extraction (Optional): If the structure of the legislative documents varies, you might need to adjust the CSS selectors in the HTML node to accurately extract the main content.
5. Activate the workflow: Once configured, activate the workflow.
6. Execute: Click "Execute workflow" on the Manual Trigger node to run the workflow. It will process the documents, summarize them, create tasks if actions are found, and update your Google Sheet.