Start free

LINE connector · Official Account reports

Read & reportRead-only source

See what uses your LINE message allowance, and how friends respond.

Bring LINE Official Account statistics into your reports and AI assistants: messages sent each day by type, followers, new friends and blocks, and how much of this month’s allowance is left.

  • Break down messages sent each day by type
  • Watch new friends against new blocks after broadcasts
  • Ask ChatGPT or Claude if the allowance covers the next broadcast
LINESheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

LINE reportSample data
DateFollowersNew friends
2026-11-1448,210312
2026-11-1548,402236
2026-11-1648,960611
Refreshes on your schedule in Google Sheets

LINE reporting for one Official Account

One LINE Official Account is the data source. Days are Japan time, ending yesterday; the newest day can still be counting.

Messages sent

Read each day’s broadcast, targeted, step, auto-response, greeting, chat and system messages, and the total.

Friends

See followers, new friends, targeted reaches, blocks and new blocks by day.

Message allowance

Check this month’s target limit, messages sent and messages remaining.

Counting days

A day LINE is still counting shows as unready instead of failing the report.

Report datasets and details

Reports you can build

3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Messages sent by day
  • Friends by day
  • Monthly message allowance
What each dataset reports
  • Messages sent by day

    Messages your LINE Official Account sent each day (Japan time), split by how they were sent: broadcasts, targeted messages, step messages, auto-responses, greetings, chats and messages sent by your own systems. Up to 31 days.

  • Friends by day

    Friends, new friends, targeted reach and blocks for your LINE Official Account each day (Japan time). Up to 31 days.

  • Monthly message allowance

    This month's target limit for sent messages and how many messages have been sent so far (Japan time month).

Metrics and dimensions

27 report fields across 3 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send LINE data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAsk Claude about these numbers in a sentence.
ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect LINE to ChatGPT or Claude for Official Account questions

Use Datapipe’s MCP access as your LINE reporting tool. Ask about messages sent, friends and blocks.

Example

On which days last week did new blocks outnumber 10% of new friends, and what did we send that day?

For each day last week, divide new blocks by new friends, list the days above 10%, and show broadcast and targeted messages sent that day.

Start with LINE

What you need

A long-lived channel access token from the Messaging API tab of your channel in the LINE Developers Console. The Messaging API must be turned on for the Official Account.

What to know

Read-only. Up to 31 days per report, because LINE limits statistics requests per hour. Messages sent this month is approximate, as LINE reports it.

How it works

  1. Create your free account, then choose LINE in Data sources.

  2. Paste your long-lived channel access token.

  3. Choose messages, friends or the allowance and a destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with LINE

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Messages sent by day and type, friends and blocks by day, and this month’s message allowance.

Japan time, as LINE counts its statistics.

LINE limits how many statistics requests an account can make each hour. Refresh on a schedule to build a longer record.

No. It only reads statistics.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each LINE account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Keep your Official Account on budget.

Start free, add LINE and bring messages and friends into the tools you already use.

Start free See setup requirements