Extract Event Speaker Data to Google Sheets
This template automates the process of extracting speaker information from an event or conference website and saving it into a structured list in a Google Sheet.
This automation streamlines the collection of speaker data from any event website. Here’s how it works:
  1. Navigates to the Event: The automation begins by loading the event website URL you provide.
  2. Finds the Speakers: It intelligently searches the site for a "Speakers" section, clicking on links like "speakers" or "view all speakers" to navigate to the correct page. It can also handle common popups like cookie consent banners.
  3. Loads All Data: To ensure no speaker is missed on pages with infinite scroll, it automatically scrolls to the bottom of the page to load all content.
  4. Extracts Speaker Details: Using an AI-powered query, it scans the page and extracts a comprehensive list of all speakers. For each speaker, it captures their full name, job title, company, bio, photo URL, and session information.
  5. Saves to Google Sheets: Finally, it formats this information and appends it as new rows to the Google Sheet you specified, creating an organized list for your use.
Usage Ideas
  • Create targeted lead lists of industry experts for sales and marketing outreach.
  • Build a database of potential speakers for your own future events.
  • Compile speaker bios and photos for event programs or promotional materials.
  • Gather research on conference presenters and their topics within a specific field.
  • Quickly source industry influencers for potential collaborations or partnerships.
Customization Ideas
This template is a powerful starting point that you can easily adapt to your specific needs. You can ask to:
  • Change the Destination: Instead of saving to Google Sheets, you can send the data to a Slack channel, create records in a database, or save it in another format.
  • Customize Extracted Data: You can modify the list of information you want to collect for each speaker. For example, you could add their LinkedIn profile URL or remove their session details.
  • Adapt to Any Website: If a website uses unique navigation (e.g., a "Presenters" link instead of "Speakers"), you can specify the correct terms to use for navigation.
  • Format Your Output: The way data is written to your spreadsheet can be customized to match your existing column structure perfectly.
  • Limit the Scope: You can set a maximum number of speakers to process if you only need a sample from a large event.
HIPPA
SOC-2 TYPE 2
Airtop empowers anyone to turn ideas into powerful automations, by simply describing what they want to happen.
airtopⓒ2025