Scrape Google Events data to Google Sheets via SerpApi

Description

Description

This workflow automates the process of scraping Google Events data using SerpApi and organizing it in Google Sheets for analysis and tracking.

Who's it for
Event organizers** who need to monitor competitor events in their area
Marketing teams** tracking local events for partnership opportunities
Researchers** collecting event data for analysis
Business owners** monitoring industry events and conferences

How it works
The workflow searches Google Events using SerpApi's Google Events engine, processes the returned data, and saves it to a Google Sheets spreadsheet. It handles pagination automatically to collect multiple events and flattens the nested API response into a structured format.

What it does
Configures search parameters - Sets the search query, total events to fetch, and pagination settings
Fetches events via SerpApi - Makes paginated requests to Google Events API with proper rate limiting
Processes and flattens data - Transforms nested event data into a flat structure with all relevant fields
Saves to Google Sheets - Appends the processed events to a Google Sheets document for easy analysis

Requirements
SerpApi account** with API key (Get one here)
Google Sheets API access** (OAuth2 credentials)
Google Sheets document** - Make a copy of this template sheet

How to set up
Configure SerpApi credentials in the HTTP Request node
Set up Google Sheets OAuth2 authentication
Update the Google Sheets document ID in the final node to point to your copy
Modify search parameters in the "Set Search Parameters" node:
Change query to your desired search terms
Adjust total_events (10 events per page)
Set start position for pagination
Run the workflow using the manual trigger

How to customize the workflow
Search terms**: Modify the query in the Set node (e.g., "conferences in New York", "music events Los Angeles")
Event count**: Adjust total_events to fetch more or fewer events
Output format**: Modify the Google Sheets column mapping to include/exclude specific fields
Rate limiting**: Adjust the requestInterval in the HTTP Request node if needed
Scheduling**: Replace the Manual Trigger with a Schedule Trigger for automated runs

Output data includes
Event title, description, and direct link
Start date and timing information
Venue and address details
Ticket information and pricing
Event location map links
Event images
Original search query for tracking

Note: This workflow respects SerpApi rate limits with built-in delays between requests and processes up to 10 events per API call efficiently.