🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

Gmail + Google Sheets: approvals tracked, no chasing

Gmail + Google Sheets: approvals tracked, no chasing - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
Gmail + Google Sheets: approvals tracked, no chasing - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

You write the draft, send it for review, and then the waiting game starts. Somewhere between “Looks good” and “Can you tweak this?”, decisions get buried in inbox threads and you end up nudging people like it’s a part-time job.

Marketing managers feel it when content calendars slip. Agency owners feel it when clients “approved it”… but nobody can find where. And if you run a lean team, Gmail approvals tracking becomes the difference between shipping weekly content and constantly playing catch-up.

This n8n workflow sends drafts for approval through Gmail and logs every decision in Google Sheets. You’ll see what it does, what you need, and what kind of time and sanity you get back.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Gmail + Google Sheets: approvals tracked, no chasing

The Problem: Approvals Live in People’s Inboxes

Content approvals sound simple until you do them at scale. A draft gets written (sometimes by AI), it gets emailed, someone replies with “Approved” but also adds a note, and now nobody is sure what the “final” version is. Next week, you’re looking back for proof of approval, and all you have is a half-remembered Gmail thread and a comment like “ship it.” It’s not just wasted time. It’s missed deadlines, rework, and that quiet stress of not knowing what’s actually approved.

The friction compounds. Here’s where it breaks down in real teams.

  • Approval decisions get scattered across reply chains, forwards, and “quick yes” messages that never make it into your tracker.
  • Someone asks, “What’s the status?” and you spend 15 minutes searching Gmail, then updating a Sheet after the fact.
  • Edits come in as vague feedback, so the writer makes changes, but there’s no timestamped record of what was requested.
  • When a client disputes what was approved, you have no clean audit trail to point to.

The Solution: Automated Draft Creation + Click-to-Approve Tracking

This workflow ties the whole loop together: request, draft, review, and decision. A content request comes in through a simple form (topic, tone, keywords), and GPT‑4o generates a draft plus a quality score from 0–100. The workflow then creates unique review links and sends a clean Gmail message to your reviewer with options to approve, request changes, or reject. When they click, n8n captures the action instantly and writes it back to Google Sheets with a timestamp and status. No copy-pasting feedback. No “did you see my email?” follow-ups.

The workflow starts with your intake form and turns it into a structured request row in Sheets. From there, AI generates the draft, the reviewer gets a single email that’s easy to act on, and every outcome is logged automatically so you can see the truth at a glance.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you run 10 drafts a week through review. Manually, it’s usually 10 minutes to send the email, another 10 minutes to chase a response later, and about 5 minutes to update your tracking sheet, so you’re burning roughly 4 hours weekly on admin. With this workflow, submitting the request takes about 5 minutes, the email is sent automatically, and the decision logs itself when the reviewer clicks. You still do the human part (review), but the busywork basically disappears.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Google Sheets for status tracking and audit trail
  • Gmail (Google Workspace) to send reviewer emails
  • OpenAI API key (get it from the OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, set three variables, and test a webhook form submission.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A request triggers everything. A form submission arrives with the topic, tone, and keywords, and the workflow formats that info into a clean record you can track.

The draft is generated and structured. GPT‑4o creates the first version and outputs a quality score (0–100), which gets packaged into a consistent draft format so reviewers aren’t reading a messy blob of text.

Review links are created inside n8n. The workflow builds unique URLs for approve, edit requested, or reject, then composes a reviewer-friendly email in Gmail.

Clicks become tracked decisions. When the reviewer chooses an action, a webhook captures it and updates Google Sheets with the status and timestamp, then shows a simple confirmation page back to the reviewer.

You can easily modify the model choice and the quality scoring weights based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Form Trigger

Set up the intake form that starts the workflow and captures the content requirements.

  1. Add or open 📥 Content Intake Form and set Path to 79adff4f-bffa-47ef-9e28-6bad05d94d89.
  2. Set Form Title to 🎨 AI Content Request.
  3. Set Form Description to Submit your content requirements and let AI create the first draft. You'll review and approve before publishing..
  4. Confirm the form fields match the defined options (Content Type, Topic / Title, Target Audience, Key Points / Requirements, Tone of Voice, Word Count, Reviewer Email, Priority).
Tip: If you edit any form field labels, update downstream mappings in Assemble Request Details and Record to Tracking Sheet to keep the data consistent.

Step 2: Connect Google Sheets

Configure the tracking sheet and make sure all Google Sheets nodes are authenticated and point to the correct document.

  1. Open Record to Tracking Sheet and set Operation to append, Sheet Name to Content Requests, and Document ID to your spreadsheet ID (replace [YOUR_ID]).
  2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Record to Tracking Sheet.
  3. Open Update Draft in Sheet and set Operation to update, Sheet Name to Content Requests, and Document ID to your spreadsheet ID.
  4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Draft in Sheet.
  5. For the remaining Google Sheets nodes (✅ Mark as Approved, ❌ Mark as Rejected, ✏️ Mark Needs Changes), verify Operation is update and each uses Sheet Name Content Requests with your spreadsheet ID.
  6. Credential Required: Add googleSheetsOAuth2Api credentials to ✅ Mark as Approved, ❌ Mark as Rejected, and ✏️ Mark Needs Changes (these nodes require credentials but have none configured).
⚠️ Common Pitfall: Leaving [YOUR_ID] in any Sheets node will cause update/append failures. Replace it everywhere.

Step 3: Set Up the AI Draft Generation

Configure the AI prompt and connect the OpenAI model to generate the initial content draft.

  1. Open Assemble Request Details and keep the assignments that generate IDs and timestamps, including requestId set to {{ 'REQ-' + $now.format('yyyyMMdd-HHmmss') }}, createdAt set to {{ $now.toISO() }}, and wordTarget set to {{ $json.wordCount === 'Short (300-500 words)' ? 400 : $json.wordCount === 'Medium (800-1200 words)' ? 1000 : 2000 }}.
  2. In 🤖 Create AI Draft, set Prompt Type to define and keep the prompt text exactly as defined to preserve the instructions and variable mapping.
  3. Open OpenAI GPT-4o Chat and set Model to gpt-4o with Temperature 0.7 and Max Tokens 3000.
  4. Credential Required: Connect your openAiApi credentials in OpenAI GPT-4o Chat. This node is connected as the language model for 🤖 Create AI Draft, so credentials are applied there.
  5. In Structure Draft Output, keep the JavaScript to calculate wordCount, qualityScore, and generate status pending_review.
Tip: If the draft output format changes, update parsing in Structure Draft Output so the title extraction and quality scoring still work.

Step 4: Configure Review Email Output

Build review URLs, compose the HTML email, and send it to the reviewer.

  1. In 🔗 Build Review URLs, keep the base URL logic and ensure your environment variable WEBHOOK_URL is set or replace https://your-n8n-instance.com with your live n8n URL.
  2. In 📧 Compose Review Email, keep the HTML template so the action buttons map to ${data.reviewLinks.approve}, ${data.reviewLinks.requestEdit}, and ${data.reviewLinks.reject}.
  3. Configure ✉️ Dispatch Review Email with Send To {{ $json.reviewerEmail }}, Subject 🎨 AI Content Ready: {{ $json.title }}, and Message {{ $json.htmlEmail }}.
  4. Credential Required: Connect your gmailOAuth2 credentials in ✉️ Dispatch Review Email.

Step 5: Configure Review Actions and Routing

Set up the webhook that handles approve/reject actions and ensures updates are written to the tracking sheet with the correct response pages.

  1. Open 🔔 Review Action Hook and set Path to f077ff3f-1a68-4c38-a010-527f8d519e96 with Response Mode responseNode.
  2. Confirm Validate Approval? checks leftValue {{ $json.query.action }} equals approve.
  3. Confirm Validate Rejection? checks leftValue {{ $json.query.action }} equals reject.
  4. 🔔 Review Action Hook outputs to both Validate Approval? and Validate Rejection? in parallel.
  5. For approved items, verify ✅ Mark as Approved writes Status approved, Approved At {{ $now.toISO() }}, and Review Status Approved, then returns Reply: Approved Page.
  6. For rejected items, verify ❌ Mark as Rejected writes Status rejected and Review Status Rejected, then returns Reply: Rejection Page.
  7. For edit requests, confirm the second output from Validate Approval? routes to ✏️ Mark Needs Changes, then returns Reply: Edit Requested.
⚠️ Common Pitfall: If your review buttons point to the wrong host, 🔔 Review Action Hook will not receive the action. Ensure the base URL in 🔗 Build Review URLs matches your public n8n URL.

Step 6: Test and Activate Your Workflow

Run a full test from form submission to approval to validate the end-to-end flow.

  1. Click Execute Workflow and submit the 📥 Content Intake Form with sample data.
  2. Confirm rows are appended in Record to Tracking Sheet and later updated by Update Draft in Sheet with status pending_review and quality metrics.
  3. Check that ✉️ Dispatch Review Email sends the HTML email and the action buttons open the correct review links.
  4. Click each action link (approve, reject, edit) and verify the sheet updates in ✅ Mark as Approved, ❌ Mark as Rejected, or ✏️ Mark Needs Changes and the browser receives the correct response page.
  5. When satisfied, toggle the workflow to Active to run it in production.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Google Sheets permissions can be picky with shared drives. If updates fail, check the Google connection in n8n and confirm the Sheet is accessible to the connected account.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Related Workflows

If you already start in Sheets and just want the “send for review” part, Google Sheets to Gmail, drafts ready for approval pairs nicely as a lighter-weight option for simple queues.

For content teams that live and die by search performance, Google Sheets + Gmail approvals for SEO drafts is helpful when you want approvals tied to keyword targets and on-page requirements.

Need the approval gate but want more emphasis on AI drafting in the inbox flow? Gmail + OpenAI: approve AI drafts before sending is a good companion when you’re iterating drafts quickly.

When your process starts from research instead of a form, Slack + OpenAI: LinkedIn drafts from any URL is a smart add-on for turning links into draft posts your team can approve the same day.

Finally, if your “content” includes video and approvals lead to publishing, Google Drive to YouTube, publish videos with less busywork helps once the file is final and you’re ready to push it live.


Quick reference:

Frequently Asked Questions

How long does it take to set up this Gmail approvals tracking automation?

About 30–45 minutes if your Google and OpenAI accounts are ready.

Do I need coding skills to automate Gmail approvals tracking?

No. You’ll mostly connect accounts and paste in a Sheet ID and reviewer email. There is a little configuration, but it’s not “developer only.”

Is n8n free to use for this Gmail approvals tracking workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few dollars a month for light drafting).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Gmail approvals tracking workflow for multi-step approvals?

Yes, but you’ll want to adjust the “Build Review URLs” and email composition logic so it routes to the right reviewer in the right order. Common customizations include adding a second reviewer, sending “edit requested” feedback back to the requester, and changing the quality-score threshold that decides which drafts need extra scrutiny. If you keep the Google Sheets status field consistent, reporting stays simple.

Why is my Gmail connection failing in this workflow?

Usually it’s an OAuth permission issue or the wrong Google account connected. Reconnect Gmail in n8n, confirm you’re using the intended Workspace account, and check the n8n credential’s access scope. If emails are sending but links don’t work, the issue is often the webhook URL you set in the workflow variables.

How many drafts can this Gmail approvals tracking automation handle?

A lot. On n8n Cloud, it depends on your monthly execution limit, and on self-hosted it mostly depends on your server. Practically, teams run dozens of drafts a day without issues as long as you keep your Google and OpenAI connections healthy.

Is this Gmail approvals tracking automation better than using Zapier or Make?

Often, yes. This flow needs branching logic (approve vs. reject vs. edit requested) and clean webhook handling, which n8n does without turning every “if” into another paid task. You also get the self-hosting option, which is a big deal if you run lots of approvals. Zapier or Make can still be fine for a tiny process, like “send email then update a row,” but the moment you want an audit trail that’s reliable, n8n is usually the calmer choice. If you’re unsure, Talk to an automation expert and get a quick recommendation.

Once this is running, approvals become a system instead of a scavenger hunt through Gmail. The workflow handles the repetitive tracking so you can focus on shipping better content.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.