Connect DataMediq to AI, Sheets, Databases & BI Tools

Windsor.ai's DataMediq connector extracts your DataMediq 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 DataMediq to Windsor.ai

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

DataMediq fields

Windsor.ai's DataMediq connector offers 25 fields, organized in 2 tables such as Dimensions, Metrics. Here they are:

  • Company Name (company_name): Company
  • Sales (sales): Sales
  • Account name (account_name): The associated account name
  • Account ID (account_id): The associated account id.
  • 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...
  • priceRavp (price_ravp): priceRavp
  • atc1Class (atc_1_class): atc1Class
  • Data Source (datasource): The name of the Windsor connector returning the row
  • Units (units): Units
  • atc1ClassDescription (atc_1_class_description): atc1ClassDescription
  • Now (now): Current timestamp
  • atc2Class (atc_2_class): atc2Class
  • Source (source): The name of the Windsor connector returning the row
  • atc2ClassDescription (atc_2_class_description): atc2ClassDescription
  • Today (today): Today's date
  • atc3Class (atc_3_class): atc3Class
  • atc3ClassDescription (atc_3_class_description): atc3ClassDescription
  • atc4Class (atc_4_class): atc4Class
  • atc4ClassDescription (atc_4_class_description): atc4ClassDescription
  • Brand (brand): Brand
  • Pack (pack): Pack
  • Product Group (product_group): Product Group
  • Pzn (pzn): Pzn
  • Week (week): Week number in ISO 8601 format, Monday-Sunday.
  • Year (year): Year (yyyy)

Use DataMediq data in ChatGPT and Claude

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

Available destinations for your DataMediq 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