Log project updates to Google Sheets

What it is

This n8n workflow is a tool for other workflows to call. It has no trigger of its own. Whatever calls it passes one input named query, a project update in text or JSON. OpenAI (gpt-4o) pulls out the project name, the notes and the status, and Google Sheets adds a row for that project or updates the row that already carries its name. The last node sets response to done. Four nodes in all.

Who it suits

Builders of n8n AI agents who want a tool for logging a project update, and teams that keep project status in a sheet. Skip it if nothing will call it. A person cannot start it from a form, and a sheet you edit by hand needs no workflow.

Where to use it

Inside a larger workflow, as the target of an Execute Workflow node or as a tool an AI agent can call. Any n8n that can reach OpenAI and Google works.

Setup

Get it saves a zip with workflow.json and Mindket’s setup notes in your downloads folder. Its author puts setup at about 9.5 minutes.

1. In n8n, create a workflow, open its menu, choose Import from File and pick workflow.json.
2. Add an OpenAI credential with your key and select it in OpenAI.
3. Make a sheet whose first row holds Project Name, Notes and Status.
4. Add a Google Sheets credential and select it in Google Sheets. Replace YOUR_SHEET_ID with your sheet’s ID and pick the sheet again.
5. Save and publish it, then open the calling workflow and choose this one in its Execute Workflow node or tool.

The trigger declares no fields, so n8n hands over whatever the caller sends, and only query is used. The caller passes this and gets one field back:

{
  "query": "<the project update, as text or JSON>"
}

{
  "response": "done"
}

How to use it

Call it with a project update, such as a line from a stand-up or a note an agent wrote. OpenAI splits it into Project Name, Notes and Status. The sheet node matches on Project Name, so a project already in the sheet has its notes and status replaced, and a new name gets a new row.

Example

An agent passes Website redesign: copy approved, waiting on the designer, on track. The sheet then holds one row for Website redesign with the notes and the status as the model split them, and the agent receives done.

For newcomers and experts

If you are new. A tool workflow does nothing by itself. It runs when another workflow calls it. To try it alone, pin a test item with a query field on the trigger and press Execute workflow.

For experts. The OpenAI node runs gpt-4o with JSON output on, and its one message is a system message that holds the update. Its answer arrives under message.content, which is where the sheet mapping reads it. Because matching uses the project name alone, two projects that share a name share a row.

Good to know

The model decides how an update is split, and the sheet records whatever it returns.

• Billing: each call is one OpenAI request
• Wording: an update that never states a status leaves the model to fill the field, so ask callers to include one
• Names: a different spelling of a project name makes a new row
• Privacy: the whole query goes to OpenAI, and the three fields go to your sheet
• Credentials: the JSON holds none, and nothing from its author’s account