Latenode

Automation Templates

Ready-to-use workflow templates for AI agents, browser automation, and messaging integrations. Get started in minutes.

Found 201 templates linked to integration “google-workspace”

Data, spreadsheets & databases

Fully automate stock trading by syncing Alpaca and Google Sheets

This workflow automates a stock trading strategy by integrating real-time market data from Google Sheets with the Alpaca paper trading API. It tracks daily stock sentiment scores, identifies the top-performing stocks, and automatically executes buy and sell orders to rebalance the portfolio. Designed to work in tandem with an AI-powered stock sentiment analysis workflow, this solution bridges the gap between market insights and trading execution, providing a fully automated, algorithm-driven investment strategy for traders who want to put their research into action without manual effort.

21s$0.0013
AI agents & chatbots

Automate newsletter creation, delivery, and client outreach with Latenode

This Latenode automation helps users streamline the entire newsletter creation and delivery process, from sourcing content to distributing it to clients. It integrates with Google Sheets, Google Drive, and Gmail to automate newsletter generation using GPT-4O AI, handle approvals, and send newsletters to client lists, all triggered from a simple spreadsheet. Whether you're a marketer, content creator, or small business owner, this workflow simplifies newsletter management with built-in workflows and eliminates manual tasks. Key steps include gathering newsletter topics, generating content with GPT-4O, uploading to Google Drive, and sending emails to clients with attached newsletters.

31s$0.0020
Scraping & data collection

Personalized cold email icebreakers with website scraping and AI

This automation workflow creates an advanced AI-powered cold email personalization system that generates deeply personalized multi-line icebreakers to improve cold email reply rates. The system scrapes website data for each prospect, analyzes multiple pages using GPT-4 to summarize the content, and then generates custom email openers that make recipients believe the sender has significant knowledge about their business and interests. This allows the user to personalize their cold email campaigns and achieve higher engagement rates. The workflow integrates with Apify for web scraping, OpenAI GPT-4 for content summarization and icebreaker generation, and Google Sheets to store the prospect data and generated icebreakers.

43s$0.0027
Social media

Automate Facebook ad data extraction and analysis in Google Sheets

This workflow automates the process of extracting Facebook ad data, analyzing the content using AI-powered tools, and storing the resulting insights directly in a Google Sheets spreadsheet. The system fetches ads from the Facebook Ad Library, processes text, image, and video ads using different AI models, and generates detailed summaries and rewritten ad copies. This solution is designed for PPC agencies and marketers who need strategic intelligence on competitor ads. The workflow integrates with Apify for web scraping, Gemini and OpenAI for content analysis, Google Drive for storage, and Google Sheets for data storage.

59s$0.0037
AI agents & chatbots

Automate stock sentiment analysis with EODHD News API and Google Gemini

This automated workflow leverages the Google Gemini AI model to analyze news sentiment for a list of stock tickers, providing actionable insights to help investors, traders, and financial analysts make informed decisions. It fetches the latest news articles from the EODHD News API, processes them through the sentiment analysis model, and writes the results (ticker, sentiment score, rationale) to a Google Sheet. This solution is designed for those who want to automate the monitoring of market news and sentiment to stay ahead of the curve.

25s$0.0016
Integrations & automation

Automate conversion of Markdown to formatted Google Docs documents

This Latenode workflow automates the process of converting Markdown content into a formatted Google Docs document, eliminating the manual copy-paste and formatting work. It is ideal for technical writers, content creators, marketers, and developers who write in Markdown but need to collaborate or publish using Google Docs format. The workflow integrates with Google Drive and the n8n automation tool to convert the Markdown to HTML, add information about the Google Drive location, merge the content with an empty Google Docs document, and update the formatting. This streamlines the content creation and review process, allowing users to focus on the writing rather than the formatting.

10s$0.0006
SEO, marketing & analytics

Scrape Pinterest content and sync to Google Sheets for SEO analysis

This Latenode automation enables users to scrape Pinterest content based on specific keywords using an AI-powered agent and the BrightData automation platform. The workflow initiates a scraping job via the BrightData API, monitors its progress, and then formats the extracted data (post title, content, URL, image URL) into a structured output that is saved to a Google Sheet. This solution is designed for SEO and marketing analytics, streamlining the process of gathering relevant Pinterest data to support these use cases.

25s$0.0016
Messaging & bots

Instant WhatsApp customer support with Google Docs knowledge base

This automated workflow sets up a smart AI-powered WhatsApp assistant that can instantly answer customer questions by drawing real-time information from a Google Docs knowledge base. The system uses Langchain AI models to understand and respond to user queries, and stores conversation logs in a Google Sheet for review. The workflow is triggered by new messages received on a WhatsApp Business API phone number, and follows a multi-step process to fetch the knowledge base, generate AI-powered responses, and send them back to the user within a 24-hour window. This solution aims to provide efficient and personalized customer support through an integrated messaging and knowledge management system.

39s$0.0025
Social media

Automate AI video creation and cross-platform publishing

This automation template helps content creators, social media managers, YouTubers, and digital marketers generate high-quality AI-powered videos and effortlessly distribute them across multiple social media platforms. The workflow starts by fetching video ideas from a Google Sheet, then uses Veo3 to create the videos and the Blotato API to post them to platforms like Instagram, TikTok, YouTube, Facebook, Twitter, and more. It automates the entire process, from initial concept generation to final video publication, allowing users to scale short-form content creation without the need for complex video editing tools.

28s$0.0018
AI agents & chatbots

Schedule client appointments via WhatsApp, sync with Cal.com and SMS

This automated WhatsApp booking system is designed for solo entrepreneurs, consultants, coaches, clinics, and any business that handles client appointments. It utilizes a conversational AI assistant to engage with users, integrates with the Cal.com scheduling platform to check availability, and sends SMS reminders to clients without the need for live agents. The workflow captures incoming WhatsApp messages, collects booking details, creates new prospect records, schedules appointments in Cal.com, and sends automated SMS reminders for upcoming sessions. This AI-powered system aims to streamline the entire booking experience for both the business and the client.

38s$0.0024
Data, spreadsheets & databases

Automate video analysis: AI insights from Google Drive to Google Sheets

This Latenode automation extracts video files from Google Drive, analyzes their content using AI-powered insights from Google Gemini, and saves the resulting data into a spreadsheet. It serves as an AI-powered video analyst that operates on a schedule, providing users with structured summaries of their video content. The workflow downloads videos, validates them, sends them to the Google Gemini AI service for analysis, and formats the insights before storing them. This automation simplifies the process of gaining meaningful insights from video data stored in Google Drive, empowering users to leverage their video assets more effectively.

22s$0.0014
Messaging & bots

Automate Telegram customer support with GPT-4 and Google Docs

This no-code workflow transforms a Telegram bot into an intelligent, always-on AI support agent. It retrieves relevant information from a Google Docs knowledge base to provide accurate and instant responses to customer queries. The workflow captures incoming messages on the Telegram bot, processes them using an OpenAI GPT-4-based language model, and sends the AI-generated responses back to the user via Telegram. This automation solution is designed for businesses that need to offer efficient customer support through a conversational interface, while leveraging their existing documentation stored in Google Docs.

20s$0.0012
Scraping & data collection

Automate YouTube comment analysis & email summary reports

This workflow automates the collection and analysis of YouTube comments from a video, using the YouTube API, OpenAI (GPT-4o), and Gmail to send a summary report via email. It provides insights on sentiment, common topics, viewer questions, and feedback for content creators and social media analysts. The workflow fetches the comments, analyzes them using GPT-4o, and sends a structured email report with actionable insights. Whether you're a YouTuber, brand manager, or social media analyst, this workflow helps you automate sentiment analysis and receive insights directly in your inbox, all triggered from a simple spreadsheet.

24s$0.0015
AI agents & chatbots

AI-powered business proposal creation with Google Slides & PandaDoc

This workflow automates the creation of personalized business proposals using AI, Google Slides, and PandaDoc. It is triggered by a form submission capturing customer details, then leverages OpenAI to generate a customized proposal. The proposal is then formatted in Google Slides and delivered to the customer via email and a PandaDoc document for electronic signature and document management. This solution helps businesses quickly produce polished, AI-generated proposals during live sales calls, improving responsiveness and closing rates.

24s$0.0015
Video, audio & media

Automate AI video creation, Google Drive storage, and YouTube publishing

This automation solution allows users to generate high-quality AI-powered videos using the Google Veo3 service, store the video files in Google Drive, and then automatically publish them to a connected YouTube channel. The workflow is triggered from a Google Sheet, where users can input video prompts and other metadata. The generated videos are then downloaded, uploaded to Google Drive, and published to YouTube with optimized titles and descriptions using GPT-4o. This end-to-end solution streamlines the video creation and distribution process, enabling users to efficiently create and share engaging video content across multiple platforms.

37s$0.0023
Email

Automatically sort and categorize Gmail emails using AI

This Latenode automation transforms a messy Gmail inbox into an organized command center by automatically sorting incoming emails into custom categories and labels using AI-driven analysis of email content and context. The workflow is triggered on a schedule, classifying emails with an AI language model and applying the appropriate labels in Gmail. It integrates with Google Sheets to manage the category definitions, and users can configure parameters like the frequency, maximum emails processed, and optional filters. This automation streamlines email organization, saving users time and effort.

21s$0.0013
Social media

Automatically sync LinkedIn comment leads to Google Sheets

This social media automation workflow enables users to automatically extract and enrich leads from LinkedIn post comments, without requiring a LinkedIn login. It uses the powerful Apify web scraping tool to fetch comments and profile data, which is then consolidated and exported to a Google Sheet or CSV file for further analysis and follow-up. The workflow includes features like pagination handling, data batching, and deduplication to ensure comprehensive and efficient data collection. By automating this lead generation process, users can efficiently identify and qualify potential leads from targeted LinkedIn posts.

17s$0.0011
Scraping & data collection

Scrape competitor prices, sync to Google Sheets, get Telegram alerts

This Latenode automation allows users to monitor the prices of competitor products and automatically update a Google Sheets spreadsheet and send price change alerts to a Telegram channel. It works by fetching a list of product URLs and last known prices from a Google Sheet, scraping the current prices from the competitor websites, computing the price changes, and then logging the price history to the Google Sheet while sending notifications via Telegram for any significant price drops or increases. This helps users stay informed about their competitors' pricing strategies and make more informed decisions about their own product offerings.

21s$0.0013
Scraping & data collection

Sync Google Shopping prices to your Google Sheet and get email alerts

This comprehensive n8n automation template monitors product prices on Google Shopping daily using Bright Data's web scraping service. It retrieves a list of product URLs from a Google Sheet, extracts the current pricing and other details, and compares them to the previous data. When a price drop is detected, the workflow sends a personalized email alert to the user, allowing them to take advantage of the change. This template is well-suited for e-commerce businesses and online retailers who want to stay on top of competitor pricing and offer the best deals to their customers.

14s$0.0009
AI agents & chatbots

AI-powered job search and tracking in Google Sheets

This workflow automates the job search process by leveraging the Adzuna job search API, GPT-3.5 language models, and Google Sheets to discover, analyze, and track relevant job listings. It retrieves real-time job data from Adzuna, summarizes and scores the listings using AI, and logs the results in a Google Spreadsheet. This end-to-end solution streamlines the job discovery and application process, allowing users to efficiently find and apply for opportunities that match their skills and preferences.

45s$0.0029
Documents & invoicing

Automate PDF invoice data extraction to Google Sheets

This workflow automates the processing of invoices by extracting key information from PDF invoices stored in a Google Drive folder using AI-powered natural language processing with OpenAI. The extracted data is then automatically inserted into a Google Sheets spreadsheet, streamlining the invoice management process and reducing manual data entry. This solution is designed for companies that manage invoices through Google Drive, business owners seeking to minimize manual data entry, and accounting/finance teams looking to automate invoice processing. The workflow integrates Google Drive, Google Sheets, and OpenAI's language model to enable this end-to-end invoice processing automation.

21s$0.0013
Data, spreadsheets & databases

Sync Tesla news & sentiment to Google Sheets

This Latenode automation is an AI-powered agent that performs real-time sentiment analysis on Tesla (TSLA) news to support trading decisions. It aggregates headlines from five trusted sources, including Google News, Yahoo Finance, Electrek, TeslaNorth, and CleanTechnica, and uses the DeepSeek Chat language model to classify the sentiment of the news and generate structured summaries. The tool is a critical sub-agent in the broader Tesla Quant Trading AI Agent system, providing investors and swing traders with valuable insights to inform their trading strategies.

16s$0.0010
AI agents & chatbots

Sync LINE chat history to Google Sheets and get AI-powered responses

This AI-powered LINE chatbot integration enables businesses and support teams to provide intelligent, context-aware customer interactions. By leveraging Google Sheets to store conversation history and Gemini AI for generating personalized responses, the chatbot can maintain contextual awareness and deliver tailored replies. The workflow is triggered by incoming messages from LINE users, retrieves relevant chat history, generates an AI-powered response, and updates the conversation log in Google Sheets. This automation aims to enhance customer experience through smart, memory-enabled chatbots, making it a valuable tool for companies looking to streamline support and foster stronger client relationships.

15s$0.0009
Scraping & data collection

Automatically Sync Amazon Prices to Google Sheets via Bright Data

This automated workflow enables users to monitor the real-time prices of Amazon product listings directly from a Google Sheets spreadsheet, using Bright Data's Amazon Scraper API. It retrieves the latest pricing information for a list of specified products, updating the Google Sheet records to support market research, competitor analysis, and personal price tracking. The workflow is triggered on a scheduled basis, reading product URLs from the spreadsheet, processing them in batches, and making API requests to Bright Data to fetch the current prices. It then updates the Google Sheet with the new data, providing a centralized and up-to-date view of the monitored products.

11s$0.0007