Track coupon points with Google Sheets, Drive Storage, and Gmail weekly summary
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs when someone submits an n8n form (“Coupon Points Tracker”) (plus 1 other trigger). Along the way it connects Google Drive, Google Sheets and Gmail.
How it runs
Trigger: When someone submits an n8n form (“Coupon Points Tracker”) (plus 1 other trigger).
- Upload file (Google Drive): uses Google Drive
- calcDate (Code): runs custom JavaScript code
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Merge: merges the data from its input branches
- filteredRows (Code): runs custom JavaScript code
- Clean Set (Edit Fields (Set)): sets or maps fields
- rewrite (Code): runs custom JavaScript code
- Append row in sheet (Google Sheets): append
- Send a message (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Google Drive
n8n-nodes-base.googleDrive - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge - n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set
From the author
Simple Coupon Points Tracker with Google Sheets and Weekly Summary Email Take full control of your expected loyalty points. This workflow helps you log every coupon and the points you should receive, store proof of purchase, and get a weekly summary so you…