Automated Local Events to Google Calendar Sync

This n8n workflow automates the process of scraping, cleaning, and posting local community events to a Google Calendar, streamlining event management. The process begins with a scheduled trigger every morning at 8:00 AM, which initiates the workflow. It then makes an HTTP request through Bright Data’s Web Unlocker proxy to fetch the HTML content of a public events page, such as a city or library website. Next, it parses this raw HTML to extract key event data including titles, locations, target audiences, and raw times using CSS selectors. The extracted data is then processed in a code node, which removes invalid placeholders, formats times into ISO standard with timezone offsets, and aligns the event details. Finally, the clean, structured event data is used to create calendar events in Google Calendar. This automation is ideal for organizations or community managers looking to keep an online calendar updated daily without manual intervention, providing real-time access to public events.