Connect Spotify to AI, Sheets, Databases & BI Tools
Windsor.ai's Spotify connector extracts your Spotify 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 Spotify to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Spotify and grant Windsor.ai access to your Spotify data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Spotify data.
Spotify fields
Windsor.ai's Spotify connector offers 376 fields, organized in 8 tables such as Ad, Ad_Set, Age, Campaign, Country, Gender, Genre, Platform. Here are 30 of them:
-
Date (
date): Date -
Account Name (
account_name): The account name -
Campaign (
campaign): Dimension for campaign. -
Country (
country): Dimension for country. -
Account ID (
account_id): The account ID -
Ad (
ad): Dimension for ad. -
Ad_Set (
ad_set): Dimension for ad_set. -
Age (
age): Dimension for age. -
Campaign Add To Cart (
campaign_add_to_cart): The number of add-to-cart events attributed to this campaign -
Country Add To Cart (
country_add_to_cart): The number of add-to-cart events attributed to this country -
Gender (
gender): Dimension for gender. -
Genre (
genre): Dimension for genre. -
Platform (
platform): Dimension for platform. -
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... -
Ad Add To Cart (
ad_add_to_cart): The number of add-to-cart events attributed to this ad -
Ad_Set Add To Cart (
ad_set_add_to_cart): The number of add-to-cart events attributed to this ad set -
Age Add To Cart (
age_add_to_cart): The number of add-to-cart events attributed to this age group -
Campaign Average Order Value (
campaign_average_order_value): The average revenue per purchase attributed to this campaign -
Country Average Order Value (
country_average_order_value): The average revenue per purchase attributed to this country -
Gender Add To Cart (
gender_add_to_cart): The number of add-to-cart events attributed to this gender -
Genre Add To Cart (
genre_add_to_cart): The number of add-to-cart events attributed to this genre -
Platform Add To Cart (
platform_add_to_cart): The number of add-to-cart events attributed to this platform -
Data Source (
datasource): The name of the Windsor connector returning the row -
Ad Average Order Value (
ad_average_order_value): The average revenue per purchase attributed to this ad -
Ad Set Asset Format (
ad_set_asset_format): Format of the asset (AUDIO/VIDEO/IMAGE) -
Age Average Order Value (
age_average_order_value): The average revenue per purchase attributed to this age group -
Campaign Clicks (
campaign_clicks): The number of impressions in which your ad was clicked -
Country Clicks (
country_clicks): The number of impressions in which your ad was clicked -
Gender Average Order Value (
gender_average_order_value): The average revenue per purchase attributed to this gender -
Genre Average Order Value (
genre_average_order_value): The average revenue per purchase attributed to this genre
Use Spotify data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Spotify is connected to Windsor.ai, you can ask questions about your Spotify data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.
- How to connect your data to ChatGPT
- How to connect your data to Claude
- How to connect Windsor MCP to any MCP client
Available destinations for your Spotify 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