Candra Reza
Templates by Candra Reza
Track expenses from receipt photos with Telegram & Google Sheets using OCR.space
Hello automation enthusiasts! 👋 Want to automatically track your expenses from receipts without hefty OCR service costs? I've got you covered! I've updated my Personal Finance Tracking Chatbot template to incorporate a free OCR service (OCR.space). This powerful n8n workflow lets you effortlessly log your expenses by sending a picture of your receipt to your Telegram bot. The OCR will extract key details like amount, date, and description, which are then neatly saved into your Google Sheets! Why use this template? 📸 Free OCR-Powered Expense Tracking: Simply send a photo of your receipt to your Telegram bot and let OCR.space do the heavy lifting – without breaking the bank! 📊 Automated Google Sheets Entry: Extracted data is seamlessly appended to your Google Sheet for easy financial overview. 💰 Manual Entry Still Available: Easily record incomes and expenses via text commands for transactions without receipts. 🤖 Instant Telegram Confirmations: Get immediate feedback on successful recordings, whether manual or OCR-processed. ✨ Customizable Parsing: The included Function node allows you to refine the data extraction logic to perfectly match your receipt formats. What Do You Need? An n8n account (self-hosted or cloud) Your own Telegram Bot (free and easy to create!) A free API Key from OCR.space. A Google account and an empty Google Spreadsheet for your financial data. A Google Spreadsheet with "Income" and "Expenses" sheets (with columns like Date, Description, Amount, Category, Type, Source). Who Is This For? This template is perfect for anyone who wants to gain more control over their personal finances in an efficient and hassle-free way. No more complex apps, just use your personal chatbot! How to Use It? Get Your Free OCR.space API Key: Visit ocr.space/OCRAPI and sign up for a free key. Import this JSON template into your n8n instance. Configure Credentials: Set your Telegram Bot Token, Google Sheet ID, and OCR.space API Key as environment variables in n8n. Activate the workflow. Start tracking your finances by sending text commands (e.g., income salary 5000, expense coffee 15 food) or just snapping a photo of your receipt to your Telegram bot! Let's simplify your financial management with automation! Feel free to try it out and modify it to suit your needs. If you have any questions, leave a comment below!
By Candra RezaAutomated company research & lead enrichment with GPT-4o and Google Sheets
Supercharge your sales and marketing with this AI-powered workflow! 🚀 Stop wasting hours on manual company research. This template deploys an autonomous AI agent that takes a list of company names from a Google Sheet, scours the web to find critical information, and automatically updates your sheet with the enriched data. What it does: Reads a list of companies to research from a Google Sheet. Uses an AI agent equipped with Google Search and web scraping tools. Extracts key data points like LinkedIn URLs, pricing details, integrations, market focus (B2B/B2C), and more. Structures the output into a clean JSON object. Updates the original Google Sheet with the new information. Key Features & Customization: This workflow is built to be easily customized. You can modify the AI's prompt in the "AI company researcher" node and adjust the "Structured Output Parser" to gather any public data point you need, such as recent news, key executives, or their technology stack. Required Credentials: OpenAI Google Sheets SerpApi or ScrapingBee for search capabilities
By Candra RezaAudit & monitor SEO performance with GPT-4 Advisor, PageSpeed Insights & Slack alerts
Unleash the full potential of your website's search engine performance and user experience with this all-in-one n8n automation template. Designed for SEO professionals and webmasters, this suite provides meticulous on-page and technical SEO auditing, deep insights into Core Web Vitals (LCP & INP), and an intelligent AI-powered chatbot for instant insights and troubleshooting. Key Features: Comprehensive On-Page SEO Audit: Automatically checks for missing or malformed titles, meta descriptions, H1s (including multiple H1s), missing alt text on images, and canonical tag issues. Detailed Technical SEO Scan: Verifies HTTPS implementation, robots.txt accessibility and content, and sitemap.xml presence. Core Web Vitals Monitoring: Leverages Google PageSpeed Insights to continuously track and alert on critical performance metrics like Largest Contentful Paint (LCP) and Interaction to Next Paint (INP). AI-Powered Analysis & Recommendations: Integrates advanced AI models (ChatGPT, Claude, or Gemini) to analyze audit findings, provide actionable recommendations for improvements, and even suggest better alt text for images based on content context. Intelligent SEO Chatbot: A dynamic chatbot triggered by webhooks understands natural language queries, extracts entities (URLs, keywords, SEO topics), and provides instant, AI-generated answers about SEO best practices, Core Web Vitals explanations, or even specific site data (via Google Search Console integration). Automated Reporting & Alerts: Logs all audit data to Google Sheets for historical tracking and sends real-time Slack alerts for critical SEO issues or performance degradations. Streamline your SEO workflow, ensure optimal website health, and react swiftly to performance challenges. This template is your ultimate tool for staying ahead in the competitive digital landscape.
By Candra RezaSync new Shopify products to Odoo
Seamlessly sync newly created Shopify products into Odoo with this smart, no-code n8n workflow. It automatically checks for duplicates and creates new products only when needed – fully compatible with a standard Odoo setup. 🚀 Key Features: Trigger-based Automation: The workflow starts instantly when a new product is created in your Shopify store. Intelligent Duplicate Check: It searches for an existing product in Odoo using the Shopify product's SKU as the Internal Reference. Smart Conditional Logic: If a matching product is found, the workflow automatically stops to prevent creating duplicates. If no match is found, it proceeds to create a new product in Odoo. Automatic Product Creation: Creates a new Odoo product by mapping the following data from Shopify: Product Name Public Price Internal Reference Description Universal Compatibility: Works with both Odoo Community and Enterprise editions without any custom modules. Fully Customizable: The workflow is open and can be easily extended in the n8n canvas to add more fields or custom logic. 🛠 Requirements: An n8n instance (self-hosted or cloud). Shopify credentials with API access. Odoo credentials with standard XML-RPC API access. 💡 Use Case: This workflow is the perfect solution for any business that regularly adds new products to Shopify and needs them automatically mirrored in Odoo for inventory, sales, or accounting purposes. Eliminate manual data entry, save time, and ensure your product catalogs are always in sync.
By Candra Reza