Create a portfolio index from new Linear projects
Give each new initiative a row in one overview you can sort and revisit.
Trigger
Project Created
Fires when a new Linear project is created. Covers projects in both public and private teams — polls with the connected user's token, so visibility matches what the connected user can see in Linear.
Action
Append Rows to Sheet by Name
Tool to append rows to a sheet by column names. Use after verifying the sheet handle and column names.
Why this helps
Projects spread across teams can be difficult to keep in view when your attention is focused on today's tasks.
- See new initiatives in a single portfolio list.
- Make cross-project reviews simpler.
- Spend less time rebuilding project summaries.
Setup
Build it in a few focused steps.
- 1Connect Linear and Gigasheet to Notis once through the portal.
- 2Create the automation in the portal or ask Notis conversationally.
- 3Ask Notis to append newly created Linear projects and useful project context to your Gigasheet portfolio index.
- 4Select the Linear Project Created trigger and choose a channel for run reports.
- 5Test with one real project creation and check the index.
Questions about this workflow
Does this include private team projects?
The Project Created trigger covers projects the connected Linear user can see, including public and private teams.
Can I use the index for planning?
Yes. Describe the project details you want included and maintain a sheet suited to your review.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Linear to Gigasheet. A trigger fires from one place; an action lands in another.
Linear triggers
Gigasheet actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Delete sheet or folder by handle
Tool to delete a sheet or folder by handle. Use after obtaining the handle of a sheet or empty folder. Set recursive=True to delete all children of a folder.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Client State Current Version
Tool to fetch the current client-state version metadata for a sheet. Use after obtaining a sheet handle to determine the current version identifier for creating views.
Comment Received Trigger
Triggered when a comment is received.
Get Connector Connections
Tool to list connector connections. Use after setting a valid Gigasheet API token.
Issue Created Trigger
Triggered when a new issue is created.
Get Dataset by Handle
Tool to get dataset metadata. Use after you have obtained the dataset handle.
Issue Updated Trigger
Triggered when an issue is updated. For example labels are changed, issue status is changed, etc.
Get Dataset Columns
Tool to list all column metadata (IDs, names, types) for a dataset. Use after obtaining a dataset handle.
Private Team Comment Created
Fires when a new comment is posted on an issue in a private Linear team (polled with the connected user's token).
Get Dataset Export Download URL
Tool to retrieve the download URL for an exported dataset. Use after initiating an export and obtaining its handle.
Private Team Issue Created
Fires when a new issue appears in a private Linear team (polled with the connected user's token).
Get Dataset Views
Tool to list all views associated with a specific dataset. Use after confirming the dataset handle and its status.
Private Team Issue Properties Updated
Fires when properties on an issue change in a private Linear team (polled with the connected user's token).
Get Docs Formulas Functions
Tool to retrieve all supported formula functions. Use after authenticating with a valid API token.
Connect any two apps with Notis in the middle.
Linear and Gigasheet, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Gigasheet.