Templates by Prueba
Automatic Notion database backup to Google Drive with Telegram notifications
🔍 Workflow Overview What This Workflow Does This workflow automatically saves copies of all your Notion databases to Google Drive. It's like creating a safety backup of your important Notion information, similar to saving important documents in a filing cabinet. Target Audience: Anyone who uses Notion and wants to protect their data by creating automatic backups to Google Drive. --- Prerequisites (What You Need Before Starting) Required Accounts Notion Account - Where your databases are stored Google Account - For Google Drive storage Telegram Account - To receive backup notifications (free messaging app) Required Software n8n Community Edition v2.0.0 installed on your computer or server Web browser (Chrome, Firefox, Safari, or Edge) --- Step-by-Step Configuration Guide PART 1: Setting Up Notion Access Step 1: Create a Notion Integration Step 2: Share Your Databases with the integration --- PART 2: Setting Up Google Drive Access Step 1: Create a Google Drive Folder Step 2: Connect Google Drive to n8n --- PART 3: Setting Up Telegram Notifications Step 1: Create a Telegram Bot Step 2: Get Your Chat ID Step 3: Connect Telegram to n8n --- PART 4: Installing the Workflow in n8n Step 1: Import the Workflow Step 2: Configure Credentials For Notion nodes (Get All Databases, Get Database Pages) For Google Drive nodes (Create Backup Folder, Upload Backup File, etc.) For Telegram node (Send Telegram Notification) Step 3: Configure the Workflow Settings --- PART 5: Testing Your Workflow Step 1: Run a Test Step 2: Verify the Backup If Something Goes Wrong Red X marks on nodes: Check that all credentials are properly connected "Not found" errors: Make sure you shared your Notion databases with the integration No Telegram message: Verify your Chat ID is correct No files in Google Drive: Check your Folder ID is correct
By PruebaAutomated 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) Google Account (Free) You need Gmail and Google Sheets OpenAI Account (Paid - but cheap) Needed for AI price analysis 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 "YOURGOOGLESHEETSDOCUMENTID" 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!
By Prueba