Connect Productive.io to AI, Sheets, Databases & BI Tools
Windsor.ai's Productive.io connector extracts your Productive.io 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 Productive.io to Windsor.ai
- Create your free Windsor.ai account or log in.
- Select Productive.io and grant Windsor.ai access to your Productive.io data.
- Pick the fields and date range you need and preview the data.
- Choose a destination and start syncing your Productive.io data.
Productive.io fields
Windsor.ai's Productive.io connector offers 78 fields, organized in 9 tables such as General, Budgets, Companies, Invoices, People, Projects, Services, Tasks, Time Entries. Here are 30 of them:
-
Project Name (
project_name): Project name as shown in Productive.io. -
Actual Hours (
actual_hours): Worked minutes converted to hours. -
Date (
date): Per-record date — server-filtered (`date` for time entries, `invoiced_on` for invoices) or a snapshot of `date_to` for dimensional / snapshot resources. -
Account Name (
account_name): The Windsor account name for the Productive workspace. -
Account ID (
account_id): The Windsor account ID for the Productive workspace. -
Actual Minutes (
actual_minutes): Raw `attributes.worked_time` from `/deals` — minutes. -
Company Domain (
company_domain): Domain associated with the Productive company. -
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... -
Invoice Amount (
invoice_amount): Invoice amount in major currency units (cents / 100). -
Person Email (
person_email): Contact email address for the Productive person. -
Project Archived At (
project_archived_at): Timestamp the project was archived; null for active projects. -
Service Deal ID (
service_deal_id): Deal (budget) the service is attached to. -
Task Assignee ID (
task_assignee_id): Productive person ID assigned to the task. -
Time Entry Billable (
time_entry_billable_flag): Boolean — whether the time entry has any billable time. Derived from `billable_time > 0` since Productive exposes billability as a numeric, not a boolean attribute. -
Billable Hours (
billable_hours): Billable minutes converted to hours. -
Company ID (
company_id): Unique identifier for the company (client). -
Data Source (
datasource): The name of the Windsor connector returning the row -
Invoice Amount (Cents) (
invoice_amount_cents): Raw `attributes.amount` from `/invoices` — minor currency units. -
Person First Name (
person_first_name): Given name of the Productive person. -
Project Company ID (
project_company_id): Productive company (client) the project belongs to. -
Service ID (
service_id): Unique identifier for the service. -
Task Closed At (
task_closed_at): Timestamp the task was closed; null for open tasks. -
Time Entry Billable Minutes (
time_entry_billable_minutes): Billable portion of the time entry in minutes (`attributes.billable_time`). -
Billable Minutes (
billable_minutes): Raw `attributes.billable_time` from `/deals` — minutes. -
Company Name (
company_name): Company (client) name as shown in Productive.io. -
Day of month (
day_of_month): Day of the month -
Invoice Company ID (
invoice_company_id): Productive company (client) the invoice belongs to. -
Person ID (
person_id): Unique identifier for the person. -
Project ID (
project_id): Unique identifier for the project in Productive.io. -
Service Name (
service_name): Service name as shown in Productive.io.
Use Productive.io data in ChatGPT and Claude
Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Productive.io is connected to Windsor.ai, you can ask questions about your Productive.io 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 Productive.io 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