Connect LINE to AI, Sheets, Databases & BI Tools

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

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

LINE fields

Windsor.ai's LINE connector offers 44 fields, organized in 4 tables such as bot_info, insight_followers, insight_message_delivery, insight_message_event. Here are 30 of them:

  • followers (followers__followers): The number of times, as of the specified date, that a user added this LINE Official Account as a friend for the first time. The number doesn't decrease even if a user later blocks the account or when...
  • Date (date): The Date
  • account name (account_name): Same as channel_id
  • account id (account_id): Same as channel_id
  • basicId (basic_id): Bot's basic ID
  • blocks (followers__blocks): The number of users blocking the account as of the specified date. The number decreases when a user unblocks the account.
  • api_broadcast (message__api_broadcast): Number of broadcast messages sent with the Send broadcast message Messaging API operation.
  • Message Delivered (message_delivered): Number of messages delivered for the request. LINE returns null when the value is less than 20.
  • channel ID (channel_id): Unique identifier for the channel
  • display name (display_name): Bot's display name
  • insight_followers_status (followers__status): Status of the counting process of number of followers. One of: ready, unready, out_of_service
  • api_multicast (message__api_multicast): Number of multicast messages sent with the Send multicast message Messaging API operation.
  • Message Request ID (message_request_id): Request ID of the broadcast or narrowcast message, returned in the x-line-request-id response header when the message was sent.
  • 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...
  • targeted_reaches (followers__targeted_reaches): The number of users, as of the specified date, that the LINE Official Account can reach through targeted messages based on gender, age, and/or region. This number only includes users who are active...
  • api_narrowcast (message__api_narrowcast): Number of narrowcast messages sent with the Send narrowcast message Messaging API operation.
  • Message Send Time (message_send_time): The date and time (UTC) at which the message was sent.
  • Data Source (datasource): The name of the Windsor connector returning the row
  • api_push (message__api_push): Number of push messages sent with the Send push message Messaging API operation.
  • Message Unique Click (message_unique_click): Number of users who opened any URL in the message. LINE returns null when the value is less than 20.
  • Day of month (day_of_month): Day of the month
  • api_reply (message__api_reply): Number of replies sent with the Send reply message Messaging API operation.
  • Message Unique Impression (message_unique_impression): Number of users who opened the message (displayed at least one bubble). LINE returns null when the value is less than 20.
  • Month (month): Number of the month
  • auto_response (message__auto_response): Number of auto-response messages sent.
  • Now (now): Current timestamp
  • broadcast (message__broadcast): Number of messages sent to all of this LINE Official Account's friends (broadcast messages).
  • Source (source): The name of the Windsor connector returning the row
  • chat (message__chat): Number of messages sent from LINE Official Account Manager Chat screen.
  • Today (today): Today's date

Use LINE data in ChatGPT and Claude

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

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