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

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!