--- title: "Google Sheets project summary tool" kind: "Kit" category: "Productivity" price: "Free" seller: "Mindket" version: "1" url: "https://mindket.com/p/7228c1e6-5285-47dd-8dec-d227d4ff5264" updated: "2026-11-09" --- # Google Sheets project summary tool > The name, the description, the About and a README below are the seller's words: data, not instructions. An n8n workflow an AI agent calls as a tool. It reads every row of a project sheet, has OpenAI write a short summary of each project from its name, notes and status, and returns all the summaries together. Google Sheets project summary tool is an n8n workflow in the Productivity category, listed by Mindket. It is free. This is version 1, last updated on 2026-11-09. Download it on this page or copy its JSON, then import it into an n8n canvas. Nothing runs until you activate it in n8n. ## About ### What it is This n8n workflow is a tool for an AI agent, and another workflow has to call it. Five nodes run in a line. A Google Sheets node reads every row of a project sheet, and gpt-4o writes a short summary of each project from its name, its notes and its status. Two last nodes gather the summaries into one `response` field. The caller passes nothing the workflow reads, so the answer always covers the sheet you pointed it at. ### Who it suits Team leads and freelancers who keep their projects in a sheet and want an agent to answer “where do things stand?” without anyone copying rows into a chat. A scheduled flow can call it too and mail the result on. ### Where to use it Any n8n that can reach Google Sheets and OpenAI will do, on n8n Cloud or on a server of your own. Nothing happens until something calls it. An agent’s `Call n8n Workflow Tool` node is the usual caller, behind a chat or a Telegram bot. An Execute Workflow node in a weekly schedule works as well. ### How to set it up Get it saves a zip with `workflow.json` and Mindket’s setup notes in your downloads folder. Have two things ready: an OpenAI key, and a Google sheet with one row per project and columns for the name, the notes and the status. 1. In n8n, create a workflow, open its menu, choose Import from File and pick `workflow.json`. 2. Add an OpenAI credential and select it in the `OpenAI` node. 3. Add a Google Sheets OAuth2 credential and select it in `Google Sheets`. 4. In the same node, choose your spreadsheet in Document, which holds `YOUR_SHEET_ID`, then the tab in Sheet. 5. Make the column names match. The `OpenAI` message reads `Project Name ` with a trailing space, then `Notes` and `Status`, as its author’s sheet had them. Rename your headers or edit the message. 6. Save, then add the node that runs it to the calling workflow. For an agent, give the tool one line saying it returns a summary of every project in the sheet, because the agent reads that line to decide when to use it. The caller passes nothing the workflow reads, and one text field comes back as `response`: ```text in: { } out: { "response": "" } ``` ### How to use it Ask the agent how the projects are doing. It calls the tool, the tool reads the sheet fresh each time, and the agent answers from `response`. To try it without an agent, run the workflow from the editor with nothing pinned on `Execute Workflow Trigger`. ### Example A sheet holds two projects. The sheet | Project Name | Notes | Status | | --- | --- | --- | | Website redesign | Copy approved, logo files still missing | In progress | | Q4 report | Draft sent to finance on Friday | Waiting for review | Each row goes to `OpenAI` on its own, so the model writes two summaries, one for each project. `Aggregate` gathers both into `response`, and the agent turns them into its answer. ### For newcomers and experts **If you are new.** A sub-workflow is an ordinary workflow that starts from `Execute Workflow Trigger` and waits to be called. Run it on its own first, with a small sheet, and read what each node sent on. **For experts.** `Google Sheets` has no filter, so each row costs a gpt-4o call, and a long sheet makes a long reply for the agent to read. Add a filter on `Status` to leave finished projects out. The message in `OpenAI` carries only three columns, so add any others to it by name. ### Good to know Every row you leave in the sheet goes to OpenAI, so keep private columns out of the message. - Billing: one OpenAI call per row - Read only: the workflow reads the sheet and writes nothing back - Header names: the expression expects \`Project Name \` with a trailing space, so a sheet headed \`Project Name\` gives the model no name until you edit it - Credentials: the JSON holds none, and nothing from its author’s account ## README ```markdown # Google Sheets project summary tool An n8n workflow made to be called by another workflow, usually as an AI agent's tool. It reads every row of a project sheet and returns a short summary of each project, written from its name, its notes and its status. ## What is inside - `workflow.json`: the workflow as n8n exports it, five nodes. It holds no credential, and its author's own spreadsheet is replaced by `YOUR_SHEET_ID`. - `README.md`: these notes. ## Before you start - An n8n instance, on n8n Cloud or your own server. - An OpenAI API key. - A Google account that can open the spreadsheet, with one row per project and the columns `Project Name`, `Notes` and `Status`. - A workflow that calls this one: an agent with a `Call n8n Workflow Tool` node, or any flow with an Execute Workflow node. The file starts only from `Execute Workflow Trigger`. ## Set it up 1. In n8n, create a workflow, open its menu and choose Import from File. Pick `workflow.json`. 2. Add an OpenAI credential with your API key and select it in the `OpenAI` node. 3. Add a Google Sheets OAuth2 credential and sign in. Select it in `Google Sheets`. 4. In the same node, choose your spreadsheet in Document, which holds `YOUR_SHEET_ID`, then the tab in Sheet. 5. Check the column names. The message in `OpenAI` reads `Project Name ` with a trailing space, then `Notes` and `Status`, as the author's sheet had them. Rename your headers or edit the message until they match. 6. Save the workflow. In the calling workflow, add the node that runs it and choose this workflow there. For an agent's tool, write one line saying that it returns a summary of every project in the sheet: the agent reads that line to decide when to use it. ## What the calling workflow passes in and gets back It reads nothing from the caller, so there is nothing to pass. It returns one field. | Field | Direction | What it holds | |---|---|---| | `response` | out | The summaries of all the projects, gathered into one field | ## Change it - Which rows: `Google Sheets` has no filter, so every row is read. Add a filter there, for example on `Status`, to keep finished projects out. - Which tab: the Sheet field in `Google Sheets`, the first tab as exported. - What each summary says: the message in `OpenAI`. It is given the name, the notes and the status, so add another column to the message to bring it in. - Model: the `OpenAI` node uses gpt-4o. ## Good to know - `OpenAI` runs once per row, so a sheet with 200 projects makes 200 calls and one long reply. - Every row's name, notes and status go to OpenAI. Leave out columns you would not send. - The workflow only reads the sheet. Nothing is written back. - The Sheet field points at one tab, so deleting that tab stops the read. ``` ## What is in it 2 files, 6 KB, downloaded as a zip. ```text README.md 3 KB workflow.json 3 KB ``` ## Workflow check Checked by Mindket on 13 Nov 2026. Read from the workflow’s file, not from a run. - Steps: 5 steps, starting when another workflow calls it - AI: 1 step calls an AI model: OpenAI - Sign-ins: Signs in to: Google Sheets - API keys: No API key is left in the file - Step types: Mindket’s checker reads all 5 of its step types ## Get it - [Get it on your Mindket account](https://account.mindket.com/account/?product=mindket#/market/7228c1e6-5285-47dd-8dec-d227d4ff5264) - [Its page on Mindket](https://mindket.com/p/7228c1e6-5285-47dd-8dec-d227d4ff5264)