Automated Smart Price Monitor with AI Prediction, Google Sheets and Gmail

Description

Think of this workflow as your personal shopping assistant that:
Watches prices for you 24/7
Learns when prices are good or bad
Sends you an email when it's time to buy
Keeps a history of all price changes

✅ Prerequisites (What You Need Before Starting)

1. Google Account (Free)
You need Gmail and Google Sheets

2. OpenAI Account (Paid - but cheap)
Needed for AI price analysis

3. Product URLs
Currently configured for Amazon products

🔧 Step-by-Step Configuration

STEP 1: Create Your Google Sheets

1.1 Create Products Sheet
Go to Google Sheets (sheets.google.com)
Click "Blank" to create new spreadsheet
Name it "Smart Price Monitor"
Create first sheet named "Products"
Add these column headers in Row 1:
Column A: URL_Product
Column B: Product_Name
Column C: Target_Price
Column D: User_Email
Column E: Last_Price
Column F: Last_Check
Column G: AI_Recommendation
Column H: AI_Confidence
Column I: Urgency_Score
Column J: Predicted_Trend
Column K: Should_Buy

1.2 Create Price History Sheet
In the same spreadsheet, create new sheet (click + at bottom)
Name it "Price_History"
Add these column headers in Row 1:
Column A: URL_Product
Column B: Price
Column C: Date
Column D: Timestamp

1.3 Add Your First Product
In the "Products" sheet, add your first product:
Row 2, Column A: Paste full Amazon URL
Row 2, Column B: Type product name (e.g., "Sony Headphones")
Row 2, Column C: Type your maximum price (e.g., 150)
Row 2, Column D: Type your email address

STEP 2: Get Google Sheets ID

Open your Google Sheet
Look at the URL in your browser
Copy the long code between /d/ and /edit
Example URL: https://docs.google.com/spreadsheets/d/1ABC123xyz456/edit
Your ID is: 1ABC123xyz456
Save this ID - you'll need it further

STEP 3: Set Up Google Cloud Connection

3.1 Create Google Cloud Project
Go to: console.cloud.google.com
Click "Create Project"
Name it "Price Monitor"
Click "Create"

3.2 Enable Google Sheets API
In the search bar, type "Google Sheets API"
Click on it and click "Enable"

STEP 4: Set Up OpenAI Account

Go to: platform.openai.com
Click "Sign Up" or "Log In"
Add payment method (required for API use)
Go to: platform.openai.com/api-keys
Click "Create new secret key"
Name it "n8n-price-monitor"
Copy the key (starts with "sk-")
IMPORTANT: Save this key safely - you can't see it again!

STEP 5: Import the Workflow

In n8n, click "Workflows" in the left sidebar
Click "Add Workflow" button (top right)
Click the three dots menu (⋮)
Select "Import from File"
Choose the .json file
Click "Import"

STEP 6: Configure Google Sheets Credentials

6.1 Update Google Sheet IDs
You need to update 5 nodes with your Sheet ID:

Nodes to update:
"Get Products"
"Get Price History"
"Add to History"
"Update Product Sheet"

How to update each:
Click on the node
Find "Document ID" field
Delete "YOUR_GOOGLE_SHEETS_DOCUMENT_ID"
Paste your Sheet ID from Step 2
Click "Refresh" icon next to the field
Select your sheet name from dropdown
Click "Execute Node" to test
If you see data, it works!

STEP 7: Configure OpenAI Credentials

Click on "OpenAI Chat Model" node (bottom of workflow)
Under "Credential to connect with", click "Create New"
Select "OpenAI API"
Give it a name: "My OpenAI"
Paste your API key from Step 4 (starts with "sk-")
Click "Save"

STEP 8: Configure Gmail Credentials

Click on "Send Email Notification" node
Under "Credential to connect with", click "Create New"
Select "Gmail OAuth2"
Follow the on-screen instructions to connect your Gmail
Authorize n8n to send emails on your behalf
Click "Save"

Test the Workflow

1 Manual Test
Make sure you have at least one product in your Google Sheet
Click "Execute Workflow" button (top right)
Watch the nodes light up as they execute
Check for any red error nodes
If all green, check your email!

2 Verify Results
Check your "Price_History" sheet - you should see new entries
Check your "Products" sheet - last columns should be updated
If product price meets criteria, check your email for notification

Set Up Automatic Execution

1 Replace Manual Trigger
Click on "Manual Trigger" node
Press Delete key
Click "+" to add new node
Search for "Schedule Trigger"
Select it

2 Activate Workflow
Click the toggle switch at the top right
It should turn green and say "Active"
Your workflow is now running automatically!