Skip to content →
Browse

Google Sheets

Linear crafted

Build custom analytics from issue data

A Google Sheets spreadsheet of Linear issues and their metadata
Linear issues automatically sync to a Google Sheet
A Google Sheets spreadsheet of Linear issues and their metadata
Linear issues automatically sync to a Google Sheet
An active Google Sheets integration on Linear with actions to "Update now" and "Open Google Sheets".
Immediately refresh the sheet data from settings

Overview⁠

Create a copy of all of your workspace issue data in Google Sheets. This integration is most commonly used to build custom dashboards and analytics.

How it works⁠

When you enable the integration, the app will create a Google sheet called Linear Issues in your Google Drive. From then on, the sheet will update hourly but you can also go to settings to immediately refresh the data.

To build analytics from the data (see examples), import or reference data from the sheet Linear created using IMPORTRANGE, VLOOKUP or similar functions. In addition to building out custom analytics and dashboards, this integration can be helpful if you ever want to view your workspace and issue data back in time. For advanced queries, consider using the Zapier integration or API instead.

Configure⁠

A Linear admin can connect their Google account to Linear in settings. Only the user who created the sheet will have access to it, so use Google Sheets' sharing settings to invite others.

You might be interested in

Build your own integration

Create your own integration with Linear’s API and submit it to the directory.

Start building