Skip to main content

🏤 Scrapping of European Union events with Google Sheets

Workflow preview

Workflow preview
100%
🏤 Scrapping of European Union events with Google Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Tags: Scrapping, Events, European Union, Networking Context Hey! I’m Samir , a Supply Chain Engineer and Data Scientist from Paris, and the founder of [LogiGreen Consulting...

Best for

  • Market Research automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.code, n8n-nodes-base.if, n8n-nodes-base.html, n8n-nodes-base.httprequest, n8n-nodes-base.googlesheets, n8n-nodes-base.aggregate, n8n-nodes-base.wait, n8n-nodes-base.stickynote

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Samir Saci.

Original n8n.io source

1.1 Workflow description

Title
🏤 Scrapping of European Union events with Google Sheets
Workflow name
🏤 Scrapping of European Union events with Google Sheets

Tags: Scrapping, Events, European Union, Networking

Context

Hey! I’m Samir , a Supply Chain Engineer and Data Scientist from Paris, and the founder of LogiGreen Consulting.

We use AI, automation, and data to support sustainable and data-driven operations across all types of organizations.

This workflow is part of our networking strategy (as a business) to track official EU events that may relate to topics we cover.

> Want to stay ahead of critical EU meetings and events without checking the website every day?

This n8n workflow automatically scrapes the EU’s official event portal and logs the latest entries with clean metadata including date, location, category, and link.

📬 For collaborations, feel free to connect with me on LinkedIn

Who is this template for?

This workflow is useful for:

  • Policy & public affairs teams following institutional activities
  • Sustainability teams watching for relevant climate-related summits
  • NGOs and researchers interested in event calendars
  • Data teams building dashboards on public event trends

What does it do?

This n8n workflow:

  1. 🌐 Scrapes the EU events portal for new meetings and conferences
  2. 📅 Extracts event metadata (title, date, location, type, and link)
  3. 🔁 Handles pagination across multiple pages
  4. 🚫 Checks for duplicates already stored
  5. 📊 Saves new records into a connected Google Sheet

How it works

  1. Triggered daily via cron
  2. HTTP node loads the event listing HTML
  3. Extract HTML blocks for each event article
  4. Parse event name, link, type, location, and full date
  5. Concatenate and clean dates for easy tracking
  6. Store non-duplicate entries in Google Sheets

The workflow uses static data to track pagination and ensure only new events are stored, making it ideal for building up a clean dataset over time.

What do I need to get started?

You’ll need:

  • A Google Sheet connected to your n8n instance
  • No code or AI tools needed — just n8n and this template

Follow the Guide!

Sticky notes are included directly inside the workflow to guide you step-by-step through setup and customisation.

Notes

  • This is ideal for analysts and consultants who want clean, structured data from the EU portal
  • You can add filtering, email alerts, or AI classifiers later

This workflow was built using n8n version 1.93.0
Submitted: June 1, 2025

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Initiate Static Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 2 - Store Tables

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 3 - page+1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 4 - If

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 5 - Extract Blocks

Type / Role
n8n-nodes-base.html - html
Config choices
Version 1.2

Block 6 - Query EU Website

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 7 - Load Old Records

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 8 - Aggregate

Type / Role
n8n-nodes-base.aggregate - aggregate
Config choices
Version 1

Block 9 - Events Already Existing?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 10 - 15 sec

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 11 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 12 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 13 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 15 - Collect Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 16 - Parse Information

Type / Role
n8n-nodes-base.html - html
Config choices
Version 1.2

Block 17 - Combine New + Old Records

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3

Block 18 - Store New Records

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 19 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 20 - Return Lines Scrapped

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 21 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow 🏤 Scrapping of European Union events with Google Sheets
Complexity advanced
Nodes 21
Categories Market Research
Author Samir Saci
Published 01 Jun 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/4561/4561.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does 🏤 Scrapping of European Union events with Google Sheets do?

Tags: Scrapping, Events, European Union, Networking Context Hey! I’m Samir , a Supply Chain Engineer and Data Scientist from Paris, and the founder of [LogiGreen Consulting...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research use case.