Get Started
Back to Templates

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

Created by

Created by: Prueba || prueba

Prueba

Last update

Last update a day ago

Categories

Share

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

  1. Go to Google Sheets (sheets.google.com)
  2. Click "Blank" to create new spreadsheet
  3. Name it "Smart Price Monitor"
  4. Create first sheet named "Products"
  5. 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

  1. In the same spreadsheet, create new sheet (click + at bottom)
  2. Name it "Price_History"
  3. 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

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

STEP 3: Set Up Google Cloud Connection

3.1 Create Google Cloud Project

  1. Go to: console.cloud.google.com
  2. Click "Create Project"
  3. Name it "Price Monitor"
  4. Click "Create"

3.2 Enable Google Sheets API

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

STEP 4: Set Up OpenAI Account

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

STEP 5: Import the Workflow

  1. In n8n, click "Workflows" in the left sidebar
  2. Click "Add Workflow" button (top right)
  3. Click the three dots menu (⋮)
  4. Select "Import from File"
  5. Choose the .json file
  6. 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:

  1. "Get Products"
  2. "Get Price History"
  3. "Add to History"
  4. "Update Product Sheet"

How to update each:

  1. Click on the node
  2. Find "Document ID" field
  3. Delete "YOUR_GOOGLE_SHEETS_DOCUMENT_ID"
  4. Paste your Sheet ID from Step 2
  5. Click "Refresh" icon next to the field
  6. Select your sheet name from dropdown
  7. Click "Execute Node" to test
  8. If you see data, it works!

STEP 7: Configure OpenAI Credentials

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

STEP 8: Configure Gmail Credentials

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

Test the Workflow

1 Manual Test

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

2 Verify Results

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

Set Up Automatic Execution

1 Replace Manual Trigger

  1. Click on "Manual Trigger" node
  2. Press Delete key
  3. Click "+" to add new node
  4. Search for "Schedule Trigger"
  5. Select it

2 Activate Workflow

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