Google Sheets Automation Workflows
3,632 ready-made Google Sheets workflows for n8n, Make, Zapier, Activepieces, and Pipedream. Spreadsheet-driven automations: logging, reporting, syncing rows to and from every tool in your stack.
Nutrition Tracker & Meal Logger with Telegram, Gemini AI, and Google Sheets
# Telegram Nutrition AI Assistant (Alternative to Cal AI App) > AI-powered nutrition assistant for Telegram - log meals, set goals, and get personalized daily reports with Google Sheets integration. ## Description This n8n template creates a **Telegram-based Nutrition AI Assistant** designed as an **open-source alternative to the Cal AI mobile app**. It allows users to interact with an AI agent via text, voice, or images to track meals, calculate macros, and monitor nutrition goals directly from Telegram. The system integrates **Google Sheets** as the database, handling both user profiles and meal logs, while leveraging **Gemini AI** for natural conversation, food recognition, and daily progress reports. ## Key Features * **Multi-input support**: Text, voice messages (transcribed), and food images (AI analysis). * **Macro calculation**: Automatic estimation of calories, proteins, carbs, and fats. * **User-friendly registration**: Simple onboarding without storing personal health data (no weight/height required). * **Goal tracking**: Users can set and update calorie and protein targets. * **Daily reports**: Personalized progress messages with visual progress bars. * **Google Sheets integration**: * `Profile` table for user targets. * `Meals` table for food logs. * **Advanced n8n nodes**: Includes use of `Merge`, `Subworkflow`, and `Code` nodes for data processing and report generation. ## Acknowledgment Inspired by the Cal AI concept - this template demonstrates how to reproduce its main functionality with **n8n, Telegram, and AI agents** as a flexible, open-source automation workflow. ## Tags * `telegram` * `ai-assistant` * `nutrition` * `meal-tracking` * `google-sheets` * `food-logging` * `voice-transcription` * `image-analysis` * `daily-reports` * `n8n-template` * `merge-node` * `subworkflow-node` * `code-node` * `telegram-trigger` * `google-gemini` ## Use Case Use this template if you want to: * Log meals using **text, images, or voice messages**. * Track nutrition goals (calories, proteins) with daily progress updates. * Provide a **chat-based nutrition assistant** without building a full app. * Store structured nutrition data in **Google Sheets** for easy access and analysis. ## Example User Interactions * User sends a photo of a meal - AI analyzes the food and logs calories/macros. * User sends a voice message - AI transcribes and logs the meal. * User types “report” - AI returns a daily nutrition summary with progress bars. * User says “update my protein goal” - AI updates profile in Google Sheets. ## Required Credentials * Telegram Bot API (Bot Token) * Google Sheets API credentials * AI Provider API (Google Gemini or compatible LLM) ## Setup Instructions 1. Create two Google Sheets tables: * **Profile**: `User_ID, Name, Calories_target, Protein_target` * **Meals**: `User_ID, Date, Meal_description, Calories, Proteins, Carbs, Fats` 2. Configure the Telegram Trigger with your bot token. 3. Connect your AI provider credentials (Gemini recommended). 4. Connect Google Sheets with your credentials. 5. Deploy the workflow in n8n. 6. Start interacting with your nutrition assistant via Telegram. ## Extra Notes * **Green section**: Handles Telegram trigger and user check. * **Red section**: Registers new users and sets goals. * **Blue section**: Processes text, voice, and images. * **Yellow section**: Generates nutrition reports. * **Purple section**: Main AI agent controlling tools and logic. --- ## Need Assistance? If you'd like help customizing or extending this workflow, feel free to reach out: Email: [johnsilva11031@gmail.com](mailto:johnsilva11031@gmail.com) LinkedIn: [John Alejandro Silva Rodríguez](https://www.linkedin.com/in/john-alejandro-silva-rodriguez-48093526b/)
n8n$24.99Automate AI Video Creation and YouTube Upload with Google Sheets
This workflow automates the creation of AI-generated videos using Google Veo3, saves them to Google Drive, generates optimized YouTube titles with GPT-4o, and uploads them to YouTube. It is triggered by a Google Sheet, streamlining the entire process from video creation to publication.
n8n$14.99Automate SEO Keyword Generation with ChatGPT from Google Sheets
Streamline your SEO strategy by automatically generating keyword suggestions using ChatGPT based on new entries in Google Sheets. This workflow enhances content creation efficiency and quality.
Make$3.99Generate Personalized Cold Email Icebreakers with GPT-4-mini and Google Sheets
## How it works This workflow helps you supercharge your cold email campaigns by enriching leads in Google Sheets with AI-generated personalization. For every lead in your sheet, the workflow: 1. Fetches rows from Google Sheets 2. Loops through each lead one by one 3. Uses OpenAI to generate: - A personalized cold email icebreaker - A shortened version of the company name 4. Saves the results back into your Google Sheet The result: a lead list that's instantly ready for highly personalized cold outreach. ## Setup steps 1. Connect your **Google Sheets account** and select the sheet with your leads. - Your sheet should have columns like: first name, last name, company name, industry, city, etc. - Adjust the column mapping in the "Update Row in Sheet" node to match your sheet's structure. 2. Connect your **OpenAI account** in the "Message a Model" node. 3. Optionally, tweak the AI prompt to match your preferred tone of voice for icebreakers. 4. Click **Execute Workflow** whenever you want to enrich your sheet with new personalized content. ## Requirements - OpenAI account (API key) - Google Sheets account with a lead list - n8n instance (self-hosted or cloud)
n8n$9.99Automated AI Degree Audit Using Google Sheets and OpenAI
This workflow automates the degree audit process for senior students by leveraging AI to evaluate completed courses against program requirements, providing a comprehensive summary of remaining credits and courses directly in Google Sheets.
n8n$9.99Automate Daily Lead Outreach from Google Sheets via Outlook
Streamline your lead management by automatically sending templated emails to new leads from Google Sheets using Outlook, ensuring each lead is contacted only once.
n8n$9.99Automate Lead Generation by Scraping Emails from Google Maps to Google Sheets
This workflow automates the extraction of business emails from Google Maps and exports them to Google Sheets, enabling cost-effective lead generation without third-party APIs.
n8n$14.99Automate SEO Blog Creation and Publishing with AI and Google Sheets
Streamline the creation and publishing of SEO-optimized blog posts using AI for content generation, Google Sheets for keyword management, and WordPress for direct publishing. This workflow saves time and ensures consistent, high-quality content.
n8n$24.99Automate Instagram Image Analysis with Apify, OpenAI, and Google Sheets
This workflow automates the process of analyzing Instagram images using Apify for scraping, OpenAI for visual analysis, and Google Sheets for data management, all within n8n.
n8n$9.99Automate YouTube Transcript Extraction via Google Sheets and Webhooks
This n8n workflow automates the extraction of YouTube video transcripts using Google Sheets monitoring and webhook API calls, enhancing content creation and accessibility.
n8n$9.99Automate Google Sheets Cleanup by Removing Duplicates via Profile URLs
Streamline your Google Sheets by automatically removing duplicate entries based on profile URLs, ensuring your data remains clean and efficient.
n8n$4.99Automate LinkedIn Job Scraping and Storage in Google Sheets
Streamline your job search by automatically scraping LinkedIn job postings using RSS feeds, summarizing them with AI, and storing the details in Google Sheets.
n8n$14.99Automate Google Sheets with AI-Driven Text Generation in n8n
Learn to automate Google Sheets operations in n8n by reading, appending, and updating rows with AI-generated text using OpenAI's GPT-4o.
n8n$9.99Automate Job Applications and Track Status with LinkedIn, Indeed, and Google Sheets
Streamline your job application process by automatically applying to jobs listed in Google Sheets and tracking their status with LinkedIn and Indeed integrations.
n8n$14.99Generate a daily multi-asset market report with TwelveData, Groq and Google Sheets
# Multi-Asset Daily Market Snapshot This workflow fully automates the creation of a daily multi-asset market report. It retrieves live pricing data for specified indices, forex pairs and commodities using the TwelveData API, manages rate limits safely and feeds the normalized data into a Groq-powered AI (Llama-3). The AI generates a professional, institutional-grade market summary which is then automatically logged in Google Sheets and emailed to your inbox. ### Quick Implementation Steps 1. **Import the Workflow:** Upload the JSON file into your n8n workspace. 2. **Add Your Keys:** In the `Environment Config` node, paste your TwelveData API key. 3. **Connect Accounts:** Authenticate your Google Sheets, Gmail and Groq API credentials in their respective nodes. 4. **Prepare the Sheet:** Create a Google Sheet with two tabs ("Sheet1" for reports, "Error logs" for failures) matching the column headers defined in the Google Sheets nodes. 5. **Execute:** Click "Test Workflow" (or trigger it manually) to fetch data and receive your daily snapshot. ## What It Does This workflow acts as an automated quantitative analyst. It starts by establishing your target asset watchlists across three categories: Indices (e.g., SPY, QQQ), Forex (e.g., EUR/USD) and Commodities (e.g., Gold, Oil). It breaks these lists down and carefully queues them up to fetch daily pricing from the TwelveData API. To ensure it doesn't overwhelm the API and get blocked, it uses a batching system with a built-in 15-second throttle. As data flows in, the workflow actively monitors for errors. If an API call fails or hits a hard limit, it instantly logs the failure details into an "Error logs" Google Sheet and sends an emergency failure alert via Gmail. Successfully fetched data is normalized into a clean format, calculating daily percentage changes and basic bullish/bearish trends. Finally, the cleaned dataset is passed to a Llama-3 AI agent via Groq. Instructed to act as a macro strategist, the AI parses the numbers to generate a structured snapshot including a market summary, key movers, risk sentiment and actionable outlook. A custom script safely extracts these exact sections, logs the complete report into your main Google Sheet for historical tracking and delivers the final formatted text straight to your Gmail. ## Who’s It For This automation is ideal for - day traders, - macro analysts, - portfolio managers, - and financial newsletter writers. It is exceptionally useful for anyone who spends the first hour of their morning manually checking tickers and writing up market summaries to share with a team or clients. ## Requirements to Use This Workflow * An active **n8n instance**. * A **TwelveData API Key** for fetching real-time/daily financial market data. * A **Groq API account** to utilize the Llama-3 language model. * A **Google Workspace account** to authenticate both Google Sheets and Gmail nodes. * A **Google Sheet** pre-configured with the exact column headers expected by the workflow. ## How It Works & How To Set Up **1. Configure the Environment** Open the `Environment Config` node and input your `twelve_api_key`. The base API URL is already set up for you. **2. Define Your Watchlist** Open the `Set Market Assets` node. Here you will see comma-separated lists for Indices, Forex and Commodities. You can replace these ticker symbols with any standard symbols supported by TwelveData. **3. API Throttling & Fetching** The `Rate Controlled Queue` node processes one ticker at a time, followed by a 15-second `API Throttle` wait. This ensures you comply with free-tier or basic API limits. The `Fetch Asset Prices` node automatically constructs the HTTP request for each symbol. **4. Error Handling Pipeline** The `Validate API Response` node checks if the TwelveData response status is "ok". If not, the workflow branches downward, logging the specific error code and symbol to your Google Sheet and sending a localized Gmail alert, before continuing the loop. **5. AI Processing & Normalization** Once all loops finish, the `Normalize Market Data` node calculates the price changes. The `AI Market Insights` node then feeds this to Groq. You must select your Groq credentials in the attached `Insights` model node. **6. Final Delivery** The `Parse AI Output` node uses Regex to strictly format the AI's response. Finally, the `Log Daily Market Report` node saves the record and the `Send Today's market summary` node emails you the results. ## How To Customize Nodes * **Wait Node (API Throttle):** If you have a premium TwelveData API plan with higher rate limits, you can reduce or remove the 15-second wait time to make the workflow run instantly. * **AI Market Insights:** You can edit the System Message to change the AI's output tone or request additional sections (like "Crypto Outlook") if you add crypto tickers to your watchlist. * **Send Today's market summary:** The current email format is plain text. You
n8n$14.99Talk to Your Google Sheets Using ChatGPT-5
This n8n workflow template creates an intelligent data analysis chatbot that can answer questions about data stored in Google Sheets using OpenAI's GPT-5 Mini model. The system automatically analyzes your spreadsheet data and provides insights through natural language conversations. ## What This Workflow Does - **Chat Interface**: Provides a conversational interface for asking questions about your data. - **Smart Data Analysis**: Uses AI to understand column structures and data relationships. - **Google Sheets Integration**: Connects directly to your Google Sheets data. - **Memory Buffer**: Maintains conversation context for follow-up questions. - **Automated Column Detection**: Automatically identifies and describes your data columns. ## Try It Out! --- ### 1. Set Up OpenAI Connection #### Get Your API Key 1. Visit the [OpenAI API Keys](https://platform.openai.com/api-keys) page. 2. Go to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview). 3. Add funds to your billing account. 4. Copy your API key into your **OpenAI credentials** in n8n (or your chosen platform). --- ### 2. Prepare Your Google Sheet #### Connect Your Data in Google Sheets - Data must follow this format: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?gid=365710158#gid=365710158) - **First row** contains column names. - Data should be in **rows 2-100**. - Log in using **OAuth**, then select your workbook and sheet. --- ### 3. Ask Questions of Your Data You can ask natural language questions to analyze your marketing data, such as: - **Total spend** across all campaigns. - **Spend for Paid Search only**. - **Month-over-month changes** in ad spend. - **Top-performing campaigns** by conversion rate. - **Cost per lead** for each channel. --- ## Need Help or Want to Customize This? [rbreen@ynteractive.com](mailto:rbreen@ynteractive.com) | [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/) | [n8n Automation Experts](https://ynteractive.com/)
n8n$9.99Automate LinkedIn Lead Generation and Personalized Outreach with Google Sheets
Streamline your LinkedIn prospecting by automatically finding leads and crafting personalized outreach messages using Google Sheets and AI-powered tools.
n8n$9.99Automate Website SEO Monitoring and Reporting with Google Sheets and Gmail
This workflow automates the monitoring of website SEO health using Google Sheets, generates detailed PDF reports for well-performing sites, and sends email alerts for sites with poor performance.
n8n$14.99Automate Pipedrive Deal Tracking in Google Sheets
This workflow automates the process of fetching deals from Pipedrive, categorizing them by stage, and logging them into Google Sheets for efficient sales pipeline reporting.
n8n$9.99Automate Timesheet Creation with AI and Google Sheets
Leverage AI to automatically generate detailed timesheets by collecting data from Gmail, Google Calendar, and GitHub, and organizing it in Google Sheets. Ideal for developers, consultants, and remote teams.
n8n$24.99Automate Email Summarization and Logging with AI and Google Sheets
This workflow automatically processes incoming emails, generates AI-powered summaries, and logs them into Google Sheets for easy tracking and analysis.
n8n$9.99Email Support Agent with Gemini & GP Fallback Using Gmail + Google Sheets
# **Master Your First AI Email Agent with Smart Fallback!** Welcome to your hands-on guide for building a resilient, intelligent email support system in n8n! This workflow is specifically designed as an educational tool to help you understand advanced AI automation concepts in a practical, easy-to-follow way. --- ### **What You'll Learn & Build:** This powerful template enables you to create an automated email support agent that: * **Monitors Gmail** for new customer inquiries in real-time. * **Processes requests** using a primary AI model (Google Gemini) for efficiency. * **Intelligently falls back to a secondary AI model** (OpenAI GPT) if the primary model fails or for more complex queries, ensuring robust reliability. * **Generates personalized and helpful replies** automatically. * **Logs every interaction** meticulously to a Google Sheet for easy tracking and analysis. --- ### **Why a Fallback Model is Game-Changing (and Why You Should Learn It):** * **Unmatched Reliability (99.9% Uptime):** If one AI service experiences an outage or rate limits, your automation seamlessly switches to another, ensuring no customer email goes unanswered. * **Cost Optimization:** Leverage more affordable models (like Gemini) for standard queries, reserving premium models (like GPT) only when truly needed, significantly reducing your API costs. * **Superior Quality Assurance:** Get the best of both worlds - the speed of cost-effective models combined with the accuracy of more powerful ones for complex scenarios. * **Real-World Application:** This isn't just theory; it's a critical pattern for building resilient, production-ready AI systems. --- ### **Perfect for Beginners & Aspiring Automators:** * **Simple Setup:** With drag-and-drop design and pre-built integrations, you can get this workflow running with minimal configuration. Just add your API keys! * **Clear Educational Value:** Learn core concepts like AI model orchestration strategies, customer service automation best practices, and multi-model AI implementation patterns. * **Immediate Results:** See your AI agent in action, responding to emails and logging data within minutes of setup. --- ### **Getting Started Checklist:** To use this workflow, you'll need: * A **Gmail account** with API access enabled. * A **Google Sheets** document created for logging. * A **Gemini API key** (your primary AI model). * An **OpenAI API key** (your fallback AI model). * An **n8n instance** (cloud or desktop). --- **Embark on your journey to building intelligent, resilient automation systems today!**
n8n$9.99Automate AI-Driven Stock Trading with Alpaca and Google Sheets
Leverage AI insights for automated stock trading by integrating Alpaca's paper trading API with Google Sheets. This workflow executes trades based on sentiment analysis, ensuring dynamic portfolio management.
n8n$14.99Automate Personalized Email Responses with AI, Gmail, and Google Sheets
Streamline your email outreach by automatically generating and sending personalized responses using AI, Gmail, and Google Sheets. This workflow enhances engagement by crafting context-aware emails tailored to each inquiry.
n8n$9.99
More integrations
Need a custom Google Sheets workflow?
Our automation experts build tailored Google Sheets integrations for your exact stack.
Request a Custom Workflow