Connect Apsis One to AI, Sheets, Databases & BI Tools

Windsor.ai's Apsis One connector extracts your Apsis One data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.

How to connect Apsis One to Windsor.ai

  1. Create your free Windsor.ai account or log in.
  2. Select Apsis One and grant Windsor.ai access to your Apsis One data.
  3. Pick the fields and date range you need and preview the data.
  4. Choose a destination and start syncing your Apsis One data.

Apsis One fields

Windsor.ai's Apsis One connector offers 37 fields. Here are 30 of them:

  • Activity Name (activity_name): The name of the email activity
  • Sender (sender): Email sender name
  • Subject (subject): Email subject
  • Event Type (event_type): Type of the event
  • Event Count (event_count): Count of current event type
  • Unique Event Count (unique_event_count): Unique count of current event type
  • Date (date): Date of the events
  • Device (device): Device type (Only for CLICKED and OPENED events).
  • Abuse Section (abuse_section): Discriminator of the abuse (Only for ABUSE events).
  • Account ID (account_id): The account ID
  • Address (address): Primary email address attribute of the targeted profile (from the same data section as the event)
  • Bounce Code (bounce_code): Bounce code (Only for BOUNCED events).
  • Data fetched at (data_fetched_at): UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that...
  • Data Source (datasource): The name of the Windsor connector returning the row
  • Day of month (day_of_month): Day of the month
  • Event Time (event_time): Time of the event reported by the event source. This feature was introduced at the beginning of 2020 so events prior to that may have event_time equal to 0. The value of 0 is also possible when the...
  • (Internal) Event Uniqueness Id (event_uniqueness_id): (Internal) Custom field to count unique events
  • Link Id (link_id): ID of the link (Only for CLICKED events).
  • Link Title (link_title): Title given to the link in the email template (Only for CLICKED events).
  • Link Url (link_url): URL of the link target (Only for CLICKED events).
  • Location (location): Only for CLICKED and OPENED events.
  • Month (month): Number of the month
  • Now (now): Current timestamp
  • Source (source): The name of the Windsor connector returning the row
  • Today (today): Today's date
  • Unsubscribe Topic (unsubscribe_topic): Discriminator of the unsubscribed topic (Only for UNSUBSCRIBED events).
  • Week (week): Week (Sun-Sat).
  • Day of week and day number (week_day): Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
  • Day of week and day number, ISO (week_day_iso): Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
  • Week ISO (week_iso): Week, ISO format (Mon-Sun).

Use Apsis One data in ChatGPT and Claude

Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Apsis One is connected to Windsor.ai, you can ask questions about your Apsis One data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.

Available destinations for your Apsis One data

AI assistants

ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)

Spreadsheets

Google Sheets, Excel, Airtable

Databases & warehouses

BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store

BI & dashboards

Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau

File storage

Amazon S3 Storage, Azure Blob Storage

Code

Python/R Code

Popular connectors

Browse all 350+ connectors