⚡ Track coupon points with Google Sheets, Drive Storage, and Gmail weekly summary
⚡ 74 views · ⚡ Personal Productivity
Description
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 can quickly spot any points that haven’t been credited and follow up with the program if needed.
Who’s it for
Ideal for frequent coupon users or anyone collecting loyalty points from programs like Payback, Miles & More, or similar reward systems. If you want a centralized, reliable way to track expected points, organize screenshots, and make sure nothing goes missing, this workflow is built for you.
How it works
Log coupon details and screenshots: Submit your coupon info via an n8n form. Screenshots are automatically saved in a Google Drive folder, and coupon data is appended to a Google Sheet. Weekly points summary: Every week, a scheduled trigger scans your sheet for coupons that are due to have points credited. It generates a clear summary email via Gmail so you can easily see which points are expected and follow up if the program hasn’t credited them.
How to set up
- Google credentials: Configure OAuth2 credentials in n8n for Google Drive, Sheets, and Gmail.
- Google Drive: Create a folder for storing screenshots and link it in the workflow.
- Google Sheets: Create a sheet with these columns, or use the Google Sheets Template and then set the sheet ID and name in the workflow nodes.
Coupon Name | Account Used to Buy | Program | Points | Bonus Points | Purchase Date | Redeem Delay (days) | Claimable Date | Coupon Screen - Email node: Configure Gmail credentials and recipient address for weekly summaries.
- Form trigger: Open the form URL to submit coupon data from any device.
- Schedule trigger: Runs weekly to send the summary; timing can be adjusted.
Requirements
- n8n instance with Google OAuth2 credentials for Drive, Sheets, and Gmail
- Google Drive folder ID for screenshots
- Google Sheets ID and sheet name for logging points
- Gmail account for sending summary emails
Stay on top of your expected points, ensure no reward slips through the cracks, and keep proof safely stored automatically. Happy tracking!
🔗 Nodes Used
Google Sheets, Google Drive, Gmail, Schedule Trigger, n8n Form Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File