Google Drive Workflows
1.381 Ergebnisse — 188 herunterladbare Workflow-Dateien, 1.193 quellenverknüpfte n8n-Referenzen
Clawdbot n8n & HTTP Request — Google Drive
On a workflow trigger, fetches data via HTTP, converts it to a file, saves it to Google Drive, and notifies via Telegram.
Clawdbot n8n with Telegram & Google Drive
On a Telegram message, an AI agent uses Drive, Sheets, Gmail, Calendar, Airtable, weather, and search tools to act and reply in Telegram.
Mini Muhasebe & Telegram
On a Telegram message or incoming Gmail, OpenAI extracts receipt data, logs it to Google Sheets, and stores files in Google Drive.
Mini Muhasebe with Telegram & Google Sheets — Google Gemini
On a Telegram message, Google Gemini parses the entry, saves it to Google Sheets, archives files to Google Drive, and replies in Telegram.
Premium SEO with Google Sheets & Schedule
On a schedule, reads keywords from Google Sheets, drafts SEO content with OpenRouter and SerpApi, and publishes to Google Docs, WordPress, Notion, and Gmail.
Expenses Tracker (video)
On a form submission, fetches and batches expense entries, logs them to Google Sheets, archives files to Google Drive, and alerts Slack.
PPC Thievery & Google Drive
On manual trigger, fetches files from Google Drive, analyzes ad copy with OpenAI, and writes results to Google Sheets.
Chat File Agent with HTTP Request
On a chat message or Google Drive upload, embeds files into Supabase and answers questions with an OpenAI RAG agent.
Run AI employee onboarding with Groq, Google Workspace, and Gemini
Quick overview This workflow ingests onboarding documents from Google Drive into an in-memory vector store with Google Gemini embeddings, then runs a multi-channel onboarding chatbot powered by Groq, sends role-based welcome emails via Gmail when a new hire appears in Google Sheets, and schedules day 1/7/30 check-in emails. How it works Manually runs an ingestion flow that lists files in a specified Google Drive folder, downloads them, extracts text, and indexes them into an in-memory vector store using Google Gemini embeddings. Receives employee questions via n8n Chat (and optionally Slack or Telegram), normalizes the message into a single format, and rejects empty or overly long inputs. Uses a Groq LLM agent with per-user session memory to retrieve relevant excerpts from the in-memory company_docs knowledge base and generate a grounded answer, or directs the user to HR when no relevant content is found. Routes the assistant’s response back to the originating channel (n8n Chat, and optionally Slack or Telegram). Triggers every minute on updates to a Google Sheets “Hires” sheet, validates rows marked as Hired, and skips hires already present in the “Tracking” sheet. Builds a depart
Archive and index legal PDFs from Gmail with Gemini, Sheets and Google Drive
Quick Overview This workflow monitors Gmail for unread emails with PDF attachments, uses Google Gemini to extract Japan Electronic Books Preservation Act filing metadata, logs a searchable index in Google Sheets, and archives documents into Google Drive folders while notifying Slack when extraction or classification fails. How it works Polls Gmail hourly for unread emails that contain attachments and downloads the attached files. Extracts text from the first PDF attachment. Sends the extracted text to Google Gemini to pull out transaction date, counterparty, amount, and document type, and alerts Slack if the document text cannot be read. Builds an Act-compliant PDF filename from the extracted fields and checks that date, counterparty, and amount are all present. If required metadata is missing, posts a warning to a Slack channel to handle the document manually. If metadata is complete, appends a row to a Google Sheets “Document Index”, marks the Gmail message as read to prevent reprocessing, and uploads the PDF to the matching Google Drive folder (invoice/receipt/contract) or flags it in Slack if unclassified. Setup Connect credentials for Gmail, Google Gemini (PaLM) API, Google Sh
Send CRM lead outreach emails with Notion, Gmail, Google Drive and OpenAI
Quick Overview This workflow watches a Notion CRM for leads ready to contact, checks Gmail to avoid duplicate outreach, then sends or drafts an email with Google Drive PDF attachments and updates the lead status in Notion, with bounce detection that marks invalid emails (using OpenAI to extract addresses). How it works Triggers when a lead page is updated in a selected Notion CRM database. Validates that the lead’s Email field looks like an email address and searches Gmail Sent for recent messages to that recipient to detect prior outreach. If the lead was already emailed and the current status is safe to overwrite, it updates the Notion lead status to “Emailed.” If the lead was not previously emailed, it downloads two PDF attachments from Google Drive, converts them to Gmail attachments, and either creates a Gmail draft for specific domains (optionally sending a Twilio SMS to a rep) or sends a generic vs personalized Gmail email based on whether a contact name exists. After sending, it waits briefly, searches Gmail for bounce messages mentioning “Address not found,” and updates the Notion record to “INVALID EMAIL” (or sets “Emailed” when the status indicates the lead is in an acti
Save starred Gmail emails as Markdown notes to an Obsidian Google Drive folder
Quick overview This workflow runs daily, finds starred Gmail emails that are not yet labeled as saved, converts each email into a Markdown note with YAML frontmatter, uploads the note to a Google Drive folder synced with your Obsidian vault, and then labels the email to prevent duplicates. How it works Runs every day at 7am on a schedule trigger. Searches Gmail for emails matching your query (default: starred) while excluding messages already labeled obsidian-saved. Converts each matching email into a Markdown file with YAML frontmatter (title, from, date, tags) and the email body, using a date-prefixed, filesystem-safe filename. Processes emails one at a time to avoid rate limits and ensure reliable saves. Creates a .md file in the selected Google Drive folder using the generated filename and Markdown content. Adds the obsidian-saved label to the original Gmail message so it is skipped in future runs. Setup Add Gmail OAuth credentials and ensure your account has access to read messages and apply labels. Add Google Drive OAuth credentials and select the destination Drive and folder ID where your Obsidian vault syncs (for example, a folder inside your vault). Create a Gmail label na
WCreate daily vaping news avatar videos with Perplexity, Browserless, HeyGen, Telegram and Google Drive
Quick Overview This workflow runs daily at 9 AM, uses Perplexity to compile vaping industry news, optionally captures article screenshots via Browserless, and generates a HeyGen avatar video from a template. It then polls for completion, sends a Telegram notification, and archives the final video to Google Drive. How it works Runs daily at 9 AM and sets the output mode (portrait/landscape) and background type (screenshot or inline_title). If set to inline_title, it asks Perplexity for 4 ready-to-use stories (title, script, subtitle) and maps them into HeyGen template variables. If set to screenshot, it asks Perplexity for up to 10 stories, validates article accessibility with Browserless scraping until it collects 4 reachable URLs, and prepares the final story list. For the screenshot path, it screenshots each article with Browserless, uploads each image to HeyGen, and combines each story with its uploaded image URL. It sends the assembled template variables to HeyGen to generate a template-based video (in test mode) with the configured dimensions. It waits briefly, polls HeyGen until the video status is completed, and formats the final video metadata. It posts an optional Telegram
WClone brand voices and generate voiceovers with Smallest AI and Google Drive
Quick Overview This workflow receives a webhook request with an audio sample URL, voice name, and script, clones a voice and generates a matching voiceover using Smallest AI, uploads the MP3 to Google Drive, logs the voice ID in Google Sheets, and returns a public link in the webhook response. How it works Receives a POST webhook request containing an audio_url, voice_name, and script text. Downloads the provided voice sample file from the audio_url. Sends the sample to Smallest AI Voice Cloning to create a new voice profile and extracts the returned voiceId. Truncates the script text to a safe length and synthesizes speech with Smallest AI using the cloned voice ID. Uploads the generated MP3 voiceover to Google Drive and updates its sharing settings to be publicly readable. Appends the cloned voice ID and voice name to a Google Sheets “voice library” spreadsheet and returns a JSON response with the voice ID, Drive link, and timestamp. Setup Create a Smallest AI API key, store it securely in n8n, and replace the hardcoded Authorization: Bearer ... header used for voice cloning. Add a Smallest AI credential in n8n for the speech synthesis step and ensure it has access to the same Sm
Tailor ATS-ready resumes and cover letters with Gemini, Google Drive, Notion, and Gmail
Quick overview Transform any resume into a professional, ATS-compliant document with AI. Supports Global ATS, German, and Japanese resume formats, generates personalized cover letters, and automates PDF creation and delivery for every job application. How it works Receives an n8n form submission with the company name, job description, selected ATS type, and an optional request to generate a cover letter. Lists resume PDF files from a specified Google Drive folder, downloads each file, extracts the PDF text, and cleans it into a single plain-text resume input. Uses Google Gemini to rewrite the resume into pure-HTML output tailored to the job description, choosing Global ATS, German Lebenslauf, or Japanese Rirekisho formatting based on the selected ATS type. Converts the generated HTML resume into a PDF using the PDF.co HTML-to-PDF API and retrieves the resulting PDF from the returned URL. Uploads the generated resume PDF to a Google Drive output folder, then reads the existing Notion database entries to compute the next serial number and creates a new Notion database page linking to the uploaded file. If cover letter generation is requested, uses Google Gemini to write a localized c
WTranslate audio transcripts with Gladia, Google Drive, and Google Sheets
Quick overview This workflow collects a public media URL and target language via an n8n form, sends the audio/video to Gladia for transcription and translation, then saves a Markdown transcript file to Google Drive and logs the outcome (success or failure) to Google Sheets. How it works Receives a form submission containing a publicly reachable audio/video URL and a target language code. Starts a Gladia pre-recorded job with transcription enabled and translation configured for the requested target language. Waits and repeatedly polls Gladia’s result URL until the job finishes, errors, or reaches the maximum number of attempts. When Gladia reports the job as done, builds a Markdown file containing the original transcript, the translated transcript, and language metadata. Uploads the Markdown file to Google Drive. Appends a “Translated” row to Google Sheets with the media URL, detected language, target language, and a Drive link, or logs a “Failed” row with error details if any step fails. Setup Add a Gladia API key using an HTTP Header Auth credential (header name x-gladia-key) and select it for both Gladia HTTP Request steps. Connect Google Drive OAuth credentials and choose the de
WTranscribe speaker-labeled recordings with Gladia, Google Drive, and Slack
Quick overview This workflow collects a public media URL via an n8n form, sends it to Gladia for diarized transcription, formats the result as a speaker-labeled Markdown note, saves it to Google Drive, and posts the Drive link (or any failure reason) to a Slack channel. How it works Receives a form submission containing a public audio/video URL and an optional hint for the number of speakers. Starts an asynchronous Gladia pre-recorded transcription job with speaker diarization enabled. Waits and repeatedly polls Gladia for the job status until it is done, errors, or reaches the configured maximum number of attempts. When complete, converts Gladia’s diarized utterances into a readable Markdown transcript grouped by speaker and timestamped. Uploads the transcript file to Google Drive and posts a Slack message with the share link. If the Gladia requests fail or the job times out/errors, posts a Slack message describing the failure. Setup Create an HTTP Header Auth credential for Gladia (header x-gladia-key) and select it on both Gladia HTTP Request steps. Connect a Google Drive OAuth2 account and choose the target Drive/folder where transcripts are uploaded. Connect a Slack account an
Rotate YouTube channel banners on a schedule with Google Sheets and Drive
Quick Overview This workflow runs daily at 8am to rotate a YouTube channel banner based on a schedule stored in Google Sheets, downloading the banner image from Google Drive, applying it via the YouTube API, and updating the sheet to mark the banner as applied. How it works Runs every day at 8am on a schedule trigger. Reads the banner rotation plan from Google Sheets, including swap date, Google Drive file ID, label, and status. Filters the sheet rows to keep banners due today or overdue that are not yet marked as Applied, and sorts them oldest-first. Downloads the selected banner image from Google Drive and uploads it as a YouTube channel banner. Fetches the current YouTube channel branding settings and updates the channel to activate the new banner while preserving existing branding fields. Updates the matching Google Sheets row to set Status to Applied and outputs a log record with the swap timestamp, channel ID, and banner details. Setup Add Google OAuth credentials for YouTube Data API and connect them to the YouTube nodes. Add Google Sheets and Google Drive credentials and connect them to the respective nodes. Set your YouTube channel ID in the banner configuration step. Upda
WCreate personalized videos from Google Sheets with iLoveVideoEditor and Gmail
Quick overview This workflow watches Google Sheets for new rows, renders a personalized video with iLoveVideoEditor using the row data, uploads the finished MP4 to Google Drive, writes the Drive link back to the same sheet row, and emails the link to the recipient via Gmail. How it works Triggers on a schedule when a new row is added to a specified Google Sheets worksheet. Skips rows where the Title field is empty. Starts a video render in iLoveVideoEditor from the cinematic-title template using the row’s Title and Subtitle as template variables. Polls iLoveVideoEditor every 60 seconds (up to 20 attempts) until the render status becomes completed, or stops early if the status becomes failed. When completed, downloads the MP4 from the render URL, uploads it to a specified Google Drive folder, and generates a shareable Drive view link. Updates the original Google Sheets row (matched by ID) with the Video URL and sends the Drive link to the row’s Email address via Gmail. If the render fails, times out, or errors, sends a failure alert email via Gmail with the row details. Setup Install the community node n8n-nodes-ilovevideoeditor (required for self-hosted n8n) and add your iLoveVideo
Create a Gmail morning audio briefing with Google Gemini and Google Drive
Quick Overview This workflow runs every weekday at 7 AM to fetch up to 10 unread Gmail messages from the last day, summarize them into a narrated script with Google Gemini, convert the script to an MP3 using Smallest.ai, upload it to Google Drive, and email you a public listening link. How it works Runs on a schedule every weekday at 7:00 AM. Pulls up to 10 unread Gmail emails from the last 24 hours. Cleans and categorizes the emails into URGENT, NEWSLETTERS, and OTHER sections while skipping common job-alert style messages. Uses a LangChain AI Agent powered by Google Gemini to turn the digest into a plain-text morning briefing script. Truncates the script to a safe character limit and converts it to speech as an MP3 with Smallest.ai. Uploads the MP3 to Google Drive, makes the file publicly readable, and sends a Gmail message with the listening link and the script text. Setup Connect your Gmail credentials for both reading unread emails and sending the briefing email, and update the recipient address in the outgoing email step. Add Google Gemini credentials in the Google Gemini Chat Model used by the AI Agent. Add your Smallest.ai API credentials for text-to-speech generation. Conn
Create narrated blog audio from RSS with Google Gemini, Smallest.ai and WordPress
Quick Overview This workflow polls a blog RSS feed, rewrites new posts into a spoken-word script using Google Gemini, generates an MP3 with Smallest.ai, uploads it to Google Drive, and updates the matching WordPress post to embed a public audio player. How it works Polls an RSS feed every minute to detect newly published or updated blog items. Extracts the post body and strips HTML, scripts, styles, and common entities to produce clean plain text. Uses Google Gemini to rewrite the text into a single, conversational narration script with an intro/outro and length limits. Sends the rewritten script to Smallest.ai to synthesize an English MP3 audio file. Uploads the MP3 to Google Drive and updates sharing so anyone with the link can play it. Updates the corresponding WordPress post to embed an HTML5 audio player pointing to the Google Drive link and includes the article text below it. Setup Set the RSS feed URL in the RSS Feed Trigger node and confirm the feed provides the fields used for the post content and GUID. Add credentials for Google Gemini (Google AI / Gemini) and select that connection in the chat model used by the rewrite step. Add your Smallest.ai API credentials and verif
Qualify leads and send personalized audio follow-ups with Gemini and Smallest.ai
Quick Overview This workflow receives lead submissions via a webhook, uses Google Gemini to qualify the lead and write a personalized spoken follow-up script, and for qualified leads generates an MP3 with Smallest.ai, shares it from Google Drive, emails it via Gmail, logs outcomes to Google Sheets, and alerts sales in Slack. How it works Receives a POST webhook request containing a lead’s name, email, and message. Sends the lead details to a Google Gemini–powered AI agent to determine whether the lead is qualified and, if so, generate a short personalized audio script. Parses the agent’s JSON response and routes the workflow based on the qualified flag. If the lead is qualified, Smallest.ai synthesizes the script into an MP3 and uploads it to Google Drive. Shares the Google Drive audio file publicly and sends the lead a Gmail message with a link to listen. Appends the qualified lead record (including the audio link and timestamp) to Google Sheets and posts a notification to a Slack channel. If the lead is unqualified, appends the lead details and timestamp to Google Sheets without generating audio or sending email. Setup Enable the webhook and copy the generated /lead-capture URL i
Generate and email PDF invoices from Google Sheets with Acrewity and Gmail
Quick overview This workflow watches for new order rows in Google Sheets, generates a styled HTML invoice, converts it to a PDF using Acrewity, emails the PDF via Gmail, archives it in Google Drive, and updates the order row status so successful and failed rows are clearly tracked. How it works Triggers every minute when a new row is added to the selected Google Sheets Orders worksheet. Applies your invoice settings (company name, logo URL, tax rate, currency, and email subject prefix) and builds invoice HTML from the row data. Validates required fields (including a valid customer email and a JSON array in the Items column) and writes an error message back to the sheet for invalid rows. Converts valid invoice HTML to a PDF using the Acrewity HTML-to-PDF API and turns the result into a binary file attachment. Sends the PDF invoice to the customer using Gmail. Uploads the PDF to a chosen Google Drive folder and updates the corresponding Google Sheets row with Status = Invoiced. Setup Install the community node package @acrewity/n8n-nodes-acrewity and add an Acrewity API credential. Add Google Sheets, Gmail, and Google Drive credentials in n8n. Create an Orders sheet with headers that
Extract and validate invoice data from Google Drive using OCR.Space, Gemini, and Google Sheets
Quick overview This workflow monitors a Google Drive folder for newly uploaded invoice files, extracts text with OCR.Space, uses Google Gemini to convert the OCR text into structured invoice fields, validates required values, then stores results in Google Sheets and sends Gmail notifications for success or manual review. How it works Triggers when a new file is created in a specified Google Drive folder. Downloads the uploaded invoice file from Google Drive and checks that the MIME type is PDF, JPG, JPEG, or PNG. Sends the file to the OCR.Space API to extract the invoice text and stops if OCR reports a processing error. Uses Google Gemini to convert the OCR text into structured JSON containing supplier, invoice metadata, amounts, currency, and line items. Validates and normalizes the extracted fields, flags missing required values, and marks the record for manual review when needed. If manual review is required, sends a Gmail alert listing missing fields; otherwise, appends key invoice fields to Google Sheets and sends a Gmail confirmation email. Setup Connect Google Drive OAuth2 credentials and set the folder ID to watch for invoice uploads. Provide an OCR.Space API key and ensure