Introduction
API endpoints
Annotate Named entity recognition Categorize Semantic similarity Sentiment Extract article information Detect language
Get articles Get articles for topic page Get article details Stream of new articles
Get events Get events for a topic page Get event details Stream of events Get list of breaking events
Get mentions
Suggest concepts Suggest categories Suggest sources Suggest authors Suggest locations Suggest event types
API Usage
Reference
Terminology
Supported languages
Response format
Building queries
Search query language
Keyword search modes
Integrations
MCP Integration
OverviewExample 1Example 2Example 3

Example 3: Sentiment Analysis Workflow

This workflow retrieves articles from Event Registry API, processes them with sentiment data, and appends results to a Google Sheet for sentiment analysis purposes.

Workflow Steps

  1. Schedule Trigger - Runs at regular intervals (hourly, daily, etc.)
  2. HTTP Request - Fetches articles with sentiment data
  3. Split Out - Separates articles into individual items
  4. Edit Fields - Transforms article data for spreadsheet
  5. Google Sheets - Appends data to spreadsheet

Step-by-Step Node Configuration

1. Schedule Trigger Node

  1. Add a Schedule Trigger node from the trigger nodes
  2. Configure the following:
  3. Trigger Times: Select your preferred schedule (e.g., Every Hour, Every Day, or Custom Cron)
  4. For Custom Cron: Enter cron expression (e.g., 0 * * * * for hourly, 0 0 * * * for daily)
  5. Click "Back to canvas" in the upper left corner

2. HTTP Request Node

  1. Add an HTTP Request node after the Schedule Trigger
  2. Configure the following settings:
  3. Method: Select POST from the dropdown
  4. URL: Enter https://eventregistry.org/api/v1/article/getArticles
  5. Authentication: Select Generic Credential Type
  6. Credential Type: Select Custom Auth
  7. Credential for Custom Auth: Select your Event Registry API credential
  8. Send Body: Check the box
  9. Body Content Type: Select JSON
  10. Specify Body: Specify body using JSON
  11. Body: Enter the following request body JSON:
  12. Important: Set includeArticleSentiment: true to retrieve sentiment scores for each article
  13. Click "Back to canvas" in the upper left corner

3. Split Out Node

  1. Add a Split Out node after the HTTP Request node
  2. Configure the following:
  3. Fields to Split Out: Enter articles.results
  4. Include: Select No Other Fields from the dropdown
  5. This separates each article into its own item for processing
  6. Click "Back to canvas" in the upper left corner

4. Edit Fields Node

  1. Add an Edit Fields node after the Split Out node
  2. Click Add Value for each field you want to map to spreadsheet columns:
  3. Field Name:title, Value:{{ $json.title }}
  4. Field Name:date, Value:{{ $json.date }}
  5. Field Name:source, Value:{{ $json.source.title }}
  6. Field Name:url, Value:{{ $json.url }}
  7. Field Name:sentiment, Value:{{ $json.sentiment }}
  8. Field Name:body, Value:{{ $json.body }}
  9. Note: Ensure field names match your Google Sheet column headers exactly
  10. Click "Back to canvas" in the upper left corner

5. Google Sheets Node

  1. Add a Google Sheets node after the Edit Fields node
  2. Configure your Google Sheets credentials first (if not already done):
  3. Go to Credentials → Add credential → Google
  4. Follow the OAuth flow to connect your Google account
  5. Back in the Google Sheets node, configure:
  6. Operation: Select Append from the dropdown
  7. Credential: Select your Google Sheets credential
  8. Document: Click Select and choose your Google Sheet from the list
  9. Sheet Name: Select the specific sheet/tab from the dropdown
  10. Data Mode: Select Map Each Column Manually
  11. For each column in your sheet, click Add Column:
  12. Column: Select the column name (e.g., Title, Date, Source)
  13. Value: Enter the corresponding field from Edit Fields (e.g., {{ $json.title }}, {{ $json.date }})
  14. Repeat for all columns (Title, Date, Source, URL, Sentiment, Body)
  15. Click "Back to canvas" in the upper left corner

Customization Ideas

  • Adjust article count: Modify articlesCount (max 50 per request)
  • Filter by keyword: Change the keyword parameter
  • Filter by date: Add dateStart and dateEnd parameters
  • Filter by source: Add sourceUri parameter
  • Prevent duplicates: Add logic to check for existing articles before appending (use article URL or ID as unique identifier)

Additional Resources