Connect Connectif to AI, Sheets, Databases & BI Tools

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

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

Connectif fields

Windsor.ai's Connectif connector offers 35 fields, organized in 1 tables such as EmailCampaigns. Here are 30 of them:

  • Date (date): The start of the week the metrics are grouped into.
  • Account Name (account_name): The Connectif store name.
  • Campaign (campaign): The name of the email.
  • Account ID (account_id): The id of the Connectif Data Explorer report the account was created with.
  • 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...
  • Email Click Through Rate (email_click_through_rate): Unique clicks divided by emails sent.
  • Data Source (datasource): The name of the Windsor connector returning the row
  • Email Click To Open Rate (email_click_to_open_rate): Unique clicks divided by unique opens.
  • Day of month (day_of_month): Day of the month
  • Email Conversion Rate (email_conversion_rate): Purchases attributed to email divided by emails sent.
  • Now (now): Current timestamp
  • Email Open Rate (email_open_rate): Unique opens divided by emails sent.
  • Source (source): The name of the Windsor connector returning the row
  • Email Unsubscribe Rate (email_unsubscribe_rate): Unsubscribes divided by emails sent.
  • Today (today): Today's date
  • Emails Sent (emails_sent): The number of emails sent.
  • Day of week and day number (week_day): Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
  • Month (month): The month the metrics are grouped into.
  • 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
  • Purchases Attributed To Email (purchases_attributed): The number of purchases attributed to email.
  • Week ISO (week_iso): Week, ISO format (Mon-Sun).
  • Total Clicks (total_clicks): The total number of email clicks.
  • Yearmonth (year_month): Year and month, e.g. 2024|3
  • Total Opens (total_opens): The total number of email opens.
  • Year month name (year_month_name): Year and month with the month name written out, e.g. "Jan 2025".
  • Total Purchase Amount (total_purchase_amount): The total amount of purchases attributed to email.
  • Year of week (year_of_week): The year that contains first day of the week (Sun-Sat).
  • Unique Clicks (unique_clicks): The number of unique email clicks.
  • Year of week, ISO (year_of_week_iso): The year that contains first day of the ISO week (Mon-Sun).
  • Unique Opens (unique_opens): The number of unique email opens.

Use Connectif data in ChatGPT and Claude

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

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