Capture vendor status updates via tokenized email links and Google 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

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).
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 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
Send email notifications when cards are moved to a list in Trello
TinyURL shortener via webhook
Save recipient data to Google Sheets every time a new Zoho Sign document is completed.
Send personalized hotel pre-arrival messages using OpenAI, Google Sheets and Slack
Save Telegram messages to a Google Sheets spreadsheet
Manage calendar with voice & text using GPT-4, Telegram & Google Calendar
Automate free IP analysis: NixGuard AI summaries & Wazuh integration
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.
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.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you