AutomationMart
Home/Browse/Capture vendor status updates via tokenized email links and Google Sheets
n8n

Capture vendor status updates via tokenized email links and Google Sheets

n8nn8n17 modulesv1.0
GmailGoogle Sheets

Quick Overview This workflow sends scheduled vendor status ping emails with one-click buttons, then captures responses via an n8n webhook and logs the selected status and timestamp to Google Sheets using a one-time token per ping cycle. How it works 1. Runs every Monday at 8am on a schedule. 2. Reads all vendors from a Google Sheets “Vendors” tab and keeps only rows where status is set to Active. 3. Generates a unique token per vendor, builds four status-link URLs (On Track, At Risk, Delayed, Ne

At a glance

Capture vendor status updates via tokenized email links and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets
Modules
17
Price
Free
Version
v1.0
Capture vendor status updates via tokenized email links and Google Sheets workflow diagram

About this workflow

Quick Overview This workflow sends scheduled vendor status ping emails with one-click buttons, then captures responses via an n8n webhook and logs the selected status and timestamp to Google Sheets using a one-time token per ping cycle. How it works 1. Runs every Monday at 8am on a schedule. 2. Reads all vendors from a Google Sheets “Vendors” tab and keeps only rows where status is set to Active. 3. Generates a unique token per vendor, builds four status-link URLs (On Track, At Risk, Delayed, Needs PM Input), and timestamps the ping. 4. Updates the matching vendor row in Google Sheets with the new token and ping timestamp and clears any prior response fields. 5. Sends an HTML email to each vendor via SMTP with four one-click status buttons that link back to the n8n webhook. 6. When a vendor clicks a button, the webhook validates the vendorid, status value, and token against Google Sheets, writes the response status and timestamp back to the sheet (and clears the token), and returns either a confirmation page or an error page. Setup 1. Create a Google Sheet with a “Vendors” tab that includes the required columns (including vendorid, status, contactemail, pingtoken, responsestatus, and timestamps). 2. Add a Google Sheets OAuth2 credential in n8n and replace YOURGOOGLESHEETID in all Google Sheets nodes. 3. Add an SMTP email credential (for example, Gmail SMTP with an app password) and set the sender address used for the email. 4. Set your public n8n webhook base URL and sender email in the Config code so the status links point to your production webhook URL. 5. Activate the workflow and use the webhook’s Production URL in the outgoing emails (not the Test URL).

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add a new row to a Google Sheets spreadsheet from a new company added to Custify

Every time a new company is created in Custify, Make will automatically add a new row to a Google Sheets spreadsheet.

Free

Send email notifications when cards are moved to a list in Trello

This automation watches cards that are moved to a list in Trello and sends email notifications via Gmail.

Free

TinyURL shortener via webhook

This n8n template allows you to automatically create shortened URLs using the TinyURL API by simply sending a webhook request. It's a quick and efficient way to integrate URL shortening into your automated workflows, ideal for sharing long links in social media, emails, or other applications. --- 🔧 How it works - Receive Link Webhook: This node acts as the entry point for the workflow. It listens for incoming POST requests and expects a JSON body containing the url to be shortened and your apike

Free

Save recipient data to Google Sheets every time a new Zoho Sign document is completed.

Every time a Zoho Sign document is completed, Make will iterate over each recipient and add the data to a new row in a Google Sheets spreadsheet.

Free

Send personalized hotel pre-arrival messages using OpenAI, Google Sheets and Slack

Description This workflow automates a personalized pre-arrival guest experience for hotels by combining Google Sheets, OpenAI, Email, and Slack. It detects upcoming check-ins, maintains unified guest profiles for new and returning guests, and sends warm, AI-generated welcome messages exactly 2 days before arrival, ensuring a premium, consistent experience without manual effort. ⚠️ Deployment Disclaimer This workflow is intended for self-hosted n8n instances. ⚙️ What This Workflow Does (Step-by-

Free

Save Telegram messages to a Google Sheets spreadsheet

Every time a new message is posted to a specified Telegram chat/channel, Make will automatically add that message to your Google Sheets spreadsheet as a new row. The template uses this example spreadsheet.

Free

Manage calendar with voice & text using GPT-4, Telegram & Google Calendar

Manage Calendar with Voice & Text Commands using GPT-4, Telegram & Google Calendar This n8n workflow transforms your Telegram bot into a personal AI calendar assistant, capable of understanding both voice and text commands in Romanian, and managing your Google Calendar using the GPT-4 model via LangChain. Whether you want to create, update, fetch, or delete events, you can simply speak or write your request to your Telegram bot — and the assistant takes care of the rest.

Free

Automate free IP analysis: NixGuard AI summaries & Wazuh integration

Supercharge Your Security Operations for Free Stop wasting time manually investigating suspicious IP addresses. This workflow template is your launchpad to automating real-time IP cybersecurity analysis using the NixGuard platform, which you can use for free. This is the first of a two-part system designed to integrate seamlessly into your existing security stack, especially with Wazuh. It calls our main workflow, Automate IP Reputation Checks and Get AI Risk Summaries from NixGuard, to do the h

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free