Granola to Google Sheets meeting log workflow

PromptCreate

Build a code workflow that turns every new Granola meeting note into a structured row in a Google Sheets meeting log. The flow is fully deterministic: there is no judgement step, just fetch, normalize, and append.

Trigger: poll Granola for the new_note event. When a new note appears, pass the note id into the rest of the pipeline.

Step 1 — Fetch the note. Call Granola Get Note with the triggering note id. Pull the full note metadata: title, created/meeting date, attendees (emails and names), the linked Google Calendar event if present, summary_text, summary_markdown, and the public note URL. Transcript content is not needed for the row, but capture whether a transcript is available as a boolean.

Step 2 — Normalize into a fixed column schema. Produce one row with these columns in this order: meeting_date (ISO date), meeting_title, meeting_type (inferred from the title with simple keyword rules: 1:1, standup, interview, customer call, internal, other), attendee_count (integer), attendee_domains (comma-separated unique email domains, excluding the workspace owner's own domain), summary_excerpt (first 280 characters of summary_text, single line), action_item_count (count of bullet lines under any heading whose text contains "action" in summary_markdown; fall back to 0 if no such section exists), transcript_available (TRUE/FALSE), calendar_event_link (URL or empty), granola_note_url. Keep the parsing simple and forgiving: missing fields become empty strings, never nulls.

Step 3 — Append to Google Sheets. Call Google Sheets Append Values on a configurable spreadsheet id and tab name (default tab name: "Meeting Log"). Use USER_ENTERED so dates and links render natively. Insert a single row in the column order above.

Configuration the user should be able to edit: the target spreadsheet id, the target tab name, and an optional title-keyword denylist that skips logging (for example "personal", "therapy").

Error handling: if Get Note returns 404 (note deleted or not accessible), skip silently. On 429 from either service, back off and retry. Do not fail the run on a single bad note; log the error and continue.

Output: one appended row per meeting. No notifications, no side effects. The spreadsheet is the product.

What does this prompt do?

Watches Granola for every new meeting note your account can see.
Pulls the meeting title, date, attendees, summary, and a link back to the note.
Adds one tidy row per meeting to a Google Sheets log so you can search, filter, and pivot later.
Counts action items from the summary and infers a meeting type from the title so the sheet is ready for analysis.

What do I need to use this?

A Granola account on a Business or Enterprise plan with a personal API key.
A Google account with access to the spreadsheet you want to use as your meeting log.
A Google Sheet (existing or new) where rows should be appended.

How can I customize it?

Change the columns the workflow writes, for example add deal name, customer segment, or meeting owner.
Filter which notes get logged, like only meetings with external attendees or only certain calendar event titles.
Point it at a different spreadsheet or tab, or split rows across tabs by meeting type.

FAQs

Will this capture every meeting in my Granola account?

It captures every note your personal Granola key can see. That includes notes you created and notes shared with you. It does not see notes in private folders that have not been shared with you.

Can I use this with a spreadsheet that already has data?

Yes. The workflow appends new rows after the last row of your existing table, so your historical data stays intact. Just make sure your header row matches the columns the workflow writes.

What happens if I edit a note in Granola after the row has been logged?

The row stays as it was first written. This workflow logs new notes as they appear. If you want updates to flow through too, you can extend it to update the matching row when a note changes.

Do I need to know how to code to use this?

No. You connect Granola and Google Sheets once, pick the spreadsheet, and the workflow runs on its own. You can tweak the columns and filters without touching code.

How fresh will the log be?

New meeting notes show up in your sheet within a few minutes of Granola finishing the recap, so the log is effectively live.

Related templates

Weekly Amazon S3 bucket security audit posted to Slack

Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.

Agentic Task

Turn procurement portal tenders into CRM deals each morning

Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.

+1

Agentic Task

Draft polite follow-ups for emails that never got a reply

Every weekday at 4pm, spot the threads that went quiet, stage a ready-to-send nudge in your mailbox, and get a ranked Slack recap.

Agentic Task

Turn today's Granola meeting notes into TickTick tasks

Every weekday at 6pm, the commitments you made in meetings become TickTick tasks with real due dates, no duplicates, and a tidy Slack recap.

Agentic Task

Flag VIP client emails in Zoho Mail and alert your team

Keep a spreadsheet of your most important senders, and every email from one gets labeled, posted to your team channel, and logged automatically.

Deterministic Code

Send Yotpo review requests when Shopify orders ship

The moment an order is fulfilled, we register it with Yotpo so the review request is timed off real delivery, and we log every sync so failures never go unnoticed.